ALTER DATABASE BACKUP CONTROLFILE TO TRACE Completed: ALTER DATABASE BACKUP CONTROLFILE TO TRACE Thu Jun 22 07:26:44 2006 Shutting down instance: further logons disabled Shutting down instance (normal) License high water mark = 1 Thu Jun 22 07:26:44 2006 ALTER DATABASE CLOSE NORMAL ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL... Thu Jun 22 07:26:44 2006 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Thu Jun 22 07:26:47 2006 ARCH shutting down ARC1: Archival stopped Thu Jun 22 07:26:47 2006 ARCH shutting down ARC0: Archival stopped Thu Jun 22 07:26:48 2006 ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thu Jun 22 07:27:35 2006 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.6.0. System parameters with non-default values: processes = 150 sessions = 170 timed_statistics = TRUE resource_limit = FALSE shared_pool_size = 159383552 sga_max_size = 487662076 large_pool_size = 8388608 java_pool_size = 159383552 enqueue_resources = 968 nls_language = AMERICAN nls_territory = AMERICA control_files = E:\MIRACLE\control01.ctl db_block_size = 8192 db_cache_size = 134217728 db_cache_advice = ON compatible = 9.2.0.0.0 log_archive_start = TRUE log_archive_dest = E:\MIRACLE\archive log_archive_format = %s.arc db_files = 200 db_file_multiblock_read_count= 16 dml_locks = 748 replication_dependency_tracking= TRUE transactions = 187 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 instance_name = TWR service_names = TWR parallel_min_servers = 0 parallel_max_servers = 5 background_dump_dest = E:\oracle\admin\TWR\bdump user_dump_dest = E:\oracle\admin\TWR\udump core_dump_dest = E:\oracle\admin\TWR\cdump audit_trail = NONE db_name = TWR open_cursors = 1500 parallel_automatic_tuning= FALSE pga_aggregate_target = 37748736 statistics_level = TYPICAL 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 Thu Jun 22 07:27:37 2006 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=8 ARC0: Archival started ARC1 started with pid=9 Thu Jun 22 07:27:38 2006 ARCH: STARTING ARCH PROCESSES COMPLETE Thu Jun 22 07:27:38 2006 ARC0: Thread not mounted Thu Jun 22 07:27:39 2006 ARC1: Archival started Thu Jun 22 07:27:39 2006 ARC1: Thread not mounted Thu Jun 22 07:27:41 2006 CREATE CONTROLFILE REUSE DATABASE "TWR" RESETLOGS ARCHIVELOG -- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 15 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 1361 LOGFILE GROUP 1 'E:\MIRACLE\REDO01.LOG' SIZE 10M, GROUP 2 'E:\MIRACLE\REDO02.LOG' SIZE 10M, GROUP 3 'E:\MIRACLE\REDO03.LOG' SIZE 10M, GROUP 4 'E:\MIRACLE\REDO04.LOG' SIZE 10M, GROUP 5 'E:\MIRACLE\REDO05.LOG' SIZE 10M -- STANDBY LOGFILE DATAFILE 'E:\MIRACLE\SYSTEM01.DBF', 'E:\MIRACLE\UNDOTBS01.DBF', 'E:\MIRACLE\TOOLS01.DBF', 'E:\MIRACLE\A4M01.DBF' CHARACTER SET BN8BSCII Thu Jun 22 07:27:41 2006 Successful mount of redo thread 1, with mount id 614401261 Thu Jun 22 07:27:41 2006 Completed: CREATE CONTROLFILE REUSE DATABASE "TWR" RESETLOGS Thu Jun 22 07:29:30 2006 ALTER DATABASE RECOVER DATABASE UNTIL CANCEL Thu Jun 22 07:29:30 2006 Media Recovery Start Thu Jun 22 07:29:30 2006 Media Recovery failed with error 1610 ORA-283 signalled during: ALTER DATABASE RECOVER DATABASE UNTIL CANCEL ... Thu Jun 22 07:31:21 2006 ALTER DATABASE RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL Thu Jun 22 07:31:21 2006 Media Recovery Start ORA-279 signalled during: ALTER DATABASE RECOVER DATABASE USING BACKUP CONT... Thu Jun 22 07:31:56 2006 ALTER DATABASE RECOVER CONTINUE DEFAULT Thu Jun 22 07:31:56 2006 Media Recovery Log E:\MIRACLE\ARCHIVE\43300.ARC Errors with log E:\MIRACLE\ARCHIVE\43300.ARC ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ... Thu Jun 22 07:31:57 2006 ALTER DATABASE RECOVER CONTINUE DEFAULT Thu Jun 22 07:31:57 2006 Media Recovery Log E:\MIRACLE\ARCHIVE\43300.ARC Errors with log E:\MIRACLE\ARCHIVE\43300.ARC ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ... Thu Jun 22 07:31:57 2006 ALTER DATABASE RECOVER CANCEL Thu Jun 22 07:31:57 2006 Media Recovery Cancelled Completed: ALTER DATABASE RECOVER CANCEL Thu Jun 22 07:38:46 2006 ALTER DATABASE OPEN Thu Jun 22 07:38:46 2006 ORA-1589 signalled during: ALTER DATABASE OPEN... Thu Jun 22 07:39:13 2006 ALTER DATABASE OPEN RESETLOGS Thu Jun 22 07:39:13 2006 RESETLOGS after incomplete recovery UNTIL CHANGE 898765395 Resetting resetlogs activation ID 0 (0x0) Thu Jun 22 07:39:14 2006 LGWR: Primary database is in CLUSTER CONSISTENT mode Assigning activation ID 614401261 (0x249f04ed) Thread 1 opened at log sequence 1 Current log# 5 seq# 1 mem# 0: E:\MIRACLE\REDO05.LOG Successful open of redo thread 1 Thu Jun 22 07:39:14 2006 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Jun 22 07:39:14 2006 SMON: enabling cache recovery Thu Jun 22 07:39:14 2006 Successfully onlined Undo Tablespace 1. Dictionary check beginning Tablespace 'TEMP' #2 found in data dictionary, but not in the controlfile. Adding to controlfile. Dictionary check complete Thu Jun 22 07:39:14 2006 SMON: enabling tx recovery Thu Jun 22 07:39:15 2006 Database Characterset is BN8BSCII replication_dependency_tracking turned off (no async multimaster replication found) Completed: ALTER DATABASE OPEN RESETLOGS Thu Jun 22 09:19:56 2006 ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE\ORADATA\TWR\TEMP01.DBF' REUSE Thu Jun 22 09:19:56 2006 ORA-1119 signalled during: ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\ORACLE\ORAD... Thu Jun 22 10:01:36 2006 Shutting down instance: further logons disabled Shutting down instance (immediate)