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)