I beg your pardon. The following is from my alert log and is was a "shutdown immediate": Thu Sep 29 12:01:00 2005 Completed: ALTER DATABASE CLOSE NORMAL Thu Sep 29 12:01:00 2005 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thu Sep 29 12:15:41 2005 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 1 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.5.0. System parameters with non-default values: processes = 800 timed_statistics = TRUE resource_limit = TRUE event = 10499 trace name context forever, level 10 shared_pool_size = 335544320 sga_max_size = 1058305200 large_pool_size = 33554432 java_pool_size = 67108864 nls_date_format = DD-MON-RRRR dbwr_io_slaves = 6 control_files = /ora1/92/dbs/ctrl12.ctl, /ora1/system/ctrl22.ctl, /ora1/archive/ctrl32.ctl db_block_size = 8192 db_cache_size = 419430400 compatible = 9.2.0.0 log_archive_start = TRUE log_archive_dest = log_archive_dest_1 = LOCATION=/ora1/archive/oldarch/arch log_archive_dest_state_1 = ENABLE log_archive_max_processes= 2 log_archive_format = log2_%s.arc log_buffer = 327680 db_files = 500 db_file_multiblock_read_count= 32 fast_start_mttr_target = 300 dml_locks = 500 undo_management = AUTO undo_tablespace = UNDOTBS undo_retention = 21600 remote_login_passwordfile= EXCLUSIVE db_domain = world global_names = FALSE instance_name = 02 service_names = linus2.world dispatchers = (protocol=tcp)(disptachers=2) shared_servers = 5 mts_servers = 5 local_listener = linus2 utl_file_dir = /ora1/local, /ora1/local/users job_queue_processes = 2 cursor_sharing = SIMILAR background_dump_dest = /ora1/92/rdbms/log user_dump_dest = /ora1/92/rdbms/users max_dump_file_size = 10240 core_dump_dest = /ora1/92/rdbms/core db_name = 02 open_cursors = 500 pga_aggregate_target = 67108864 Deprecated system parameters with specified values: mts_servers End of deprecated system parameter listing PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 CJQ0 started with pid=8 Thu Sep 29 12:15:49 2005 starting up 5 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=tcp))'... ARCH: STARTING ARCH PROCESSES ARC0 started with pid=15 ARC0: Archival started ARC1 started with pid=16 Thu Sep 29 12:15:53 2005 ARCH: STARTING ARCH PROCESSES COMPLETE Thu Sep 29 12:15:53 2005 ARC1: Archival started ARC1: Thread not mounted Thu Sep 29 12:15:53 2005 ARC0: Thread not mounted Thu Sep 29 12:15:54 2005 ALTER DATABASE MOUNT Thu Sep 29 12:16:00 2005 Successful mount of redo thread 1, with mount id 5766140 Thu Sep 29 12:16:00 2005 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Thu Sep 29 12:16:01 2005 ALTER DATABASE OPEN Thu Sep 29 12:16:03 2005 LGWR: Primary database is in CLUSTER CONSISTENT mode Thread 1 opened at log sequence 12582 Current log# 6 seq# 12582 mem# 0: /ora1/redo/log602.dbf Successful open of redo thread 1 Thu Sep 29 12:16:03 2005 SMON: enabling cache recovery Thu Sep 29 12:16:04 2005 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Thu Sep 29 12:16:04 2005 SMON: enabling tx recovery Thu Sep 29 12:16:04 2005 Database Characterset is WE8ISO8859P1 replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Sent: Tuesday, October 04, 2005 1:02 PM To: Brandon.Allen@xxxxxxxxxxx; oracledba.williams@xxxxxxxxx; makbo@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: Creating a controlfile - language needed? Brandon, Shutdown immediate is a controlled crash. Do a shutdown immediate. Then a startup. Review the alert.log file. Your will see a recovery takes place. Compare this with a shutdown and a shutdown abort. Simple test to see how it works. Tom -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Allen, Brandon Sent: Tuesday, October 04, 2005 12:35 PM To: oracledba.williams@xxxxxxxxx; makbo@xxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: Creating a controlfile - language needed? From the referenced web page: "Do not shutdown abort or immediate as these will require instance recovery." Am I missing something, or is that statement incorrect? I've never heard of shutdown immediate requiring instance recovery. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Dennis Williams Sent: Tuesday, October 04, 2005 9:02 AM There are several documents on the web that describe this process, for example: http://www.jlcomp.demon.co.uk/faq/db_move.html. Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l