通过GC创建dataguard备库失败一则(四)

2014-11-24 15:19:43 · 作者: · 浏览: 1
equence 27107 dbid 1083719948 branch 759079182
Archived Log entry 1 added for thread 1 sequence 27107 rlc 759079182 ID 0x40a48484 dest 4:
Thu Jul 25 16:34:21 2013
Primary database is in MAXIMUM AVAILABILITY mode
Changing standby controlfile to RESYNCHRONIZATION level
Standby controlfile consistent with primary
RFS[2]: Assigned to RFS process 21187
RFS[2]: Selected log 7 for thread 1 sequence 27119 dbid 1083719948 branch 759079182
Thu Jul 25 16:34:21 2013
Standby crash recovery aborted due to error 16426.
Errors in file /u01/app/ora11g/diag/rdbms/htdb7/htdb7/trace/htdb7_ora_13883.trc:
ORA-16426: 恢复操作请求了不正确的日志来应用重做数据。
Recovery interrupted!
Completed standby crash recovery.
Signalling error 1152 for datafile 1!
Errors in file /u01/app/ora11g/diag/rdbms/htdb7/htdb7/trace/htdb7_ora_13883.trc:
ORA-10458: standby database requires recovery
ORA-01152: 文件 1 没有从过旧的备份中还原
ORA-01110: 数据文件 1: '+DATA/htdb7/datafile/system.272.821719041'
ORA-10458 signalled during: alter database open...
Thu Jul 25 16:34:22 2013
RFS[3]: Assigned to RFS process 21194
RFS[3]: Selected log 8 for thread 1 sequence 27118 dbid 1083719948 branch 759079182
Thu Jul 25 16:34:23 2013
Archived Log entry 2 added for thread 1 sequence 27118 ID 0x40a48484 dest 1:
RFS[3]: Opened log for thread 1 sequence 27109 dbid 1083719948 branch 759079182
Thu Jul 25 16:34:23 2013
RFS[4]: Assigned to RFS process 21202
RFS[4]: Opened log for thread 1 sequence 27108 dbid 1083719948 branch 759079182
Thu Jul 25 16:34:23 2013
RFS[5]: Assigned to RFS process 21198
RFS[5]: Opened log for thread 1 sequence 27110 dbid 1083719948 branch 759079182
Archived Log entry 3 added for thread 1 sequence 27108 rlc 759079182 ID 0x40a48484 dest 4:
RFS[4]: Opened log for thread 1 sequence 27111 dbid 1083719948 branch 759079182
……
alter database open --第二次open时
Data Guard Broker initializing...
Data Guard Broker initialization complete
Signalling error 1152 for datafile 1!
Beginning standby crash recovery.
Serial Media Recovery started
Managed Standby Recovery starting Real Time Apply
Media Recovery Log +FRA/htdb7/archivelog/2013_07_25/thread_1_seq_27107.285.821723659
Media Recovery Log +FRA/htdb7/archivelog/2013_07_25/thread_1_seq_27108.288.821723663
Incomplete Recovery applied until change 53602571404 time 07/25/2013 15:20:25
Completed standby crash recovery.
Thu Jul 25 16:36:06 2013
SMON: enabling cache recovery
Dictionary check beginning
Thu Jul 25 16:36:06 2013
Errors in file /u01/app/ora11g/diag/rdbms/htdb7/htdb7/trace/htdb7_dbw0_13194.trc:
ORA-01186: 201
ORA-01157: / 201 - DBWR
ORA-01110: 201: '+DATA'
File 201 not verified due to error ORA-01157
Errors in file /u01/app/ora11g/diag/rdbms/htdb7/htdb7/trace/htdb7_dbw0_13194.trc:
ORA-01186: 202
ORA-01157: / 202 - DBWR
ORA-01110: 202: '+DATA'
File 202 not verified due to error ORA-01157
Dictionary check complete
Re-creating tempfile +DATA as +DATA/htdb7/tempfile/temp.304.821723767
Re-creating tempfile +DATA as +DATA/htdb7/tempfile/temp.305.821723767
Database Characterset is ZHS16GBK
No Resource Manager plan active
**********************************************************
WARNING: Files may exists in db_recovery_