Oracle Active Data Guard????????
???????????? ???????[ 2014/9/5 13:36:33 ] ????????????? Oracle ???????
?????????Oracle 11gR2 Active Data Guard???????????????standby_file_management=AUTO????????????standby_file_management=MANUAL??????????????????????????????????????????????????????$ORACLE_HOME/dbs???????д???????UNNAMED00003?????????????????????μ?澯?????
????Tue Sep 02 17:37:36 2014
????File #3 added to control file as 'UNNAMED00003' because
????the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
????The file should be manually created to continue.
????MRP0: Background Media Recovery terminated with error 1274
????Errors in file /u01/app/oracle/diag/rdbms/d012dg/d012band/trace/d012band_pr00_5702078.trc:
????ORA-01274: cannot add datafile '/oradata1/d012band/tsmisc06.dbf' - file could not be created
????Managed Standby Recovery not using Real Time Apply
????Recovery interrupted!
????Recovered data files to a consistent state at change 866102511
????Tue Sep 02 17:37:46 2014
????MRP0: Background Media Recovery process shutdown (d012band)
????Tue Sep 02 17:52:14 2014
????RFS[1]: Selected log 8 for thread 1 sequence 19136 dbid 2134147111 branch 809469738
????Tue Sep 02 17:52:25 2014
????Archived Log entry 511 added for thread 1 sequence 19135 ID 0x7f340827 dest 1:
????Tue Sep 02 17:53:23 2014
????alter database recover managed standby database using current logfile disconnect from session
????Attempt to start background Managed Standby Recovery process (d012band)
????Tue Sep 02 17:53:23 2014
????MRP0 started with pid=42?? OS id=7471452
????MRP0: Background Managed Standby Recovery process started (d012band)
????started logmerger process
????Tue Sep 02 17:53:29 2014
????Managed Standby Recovery starting Real Time Apply
????Tue Sep 02 17:53:30 2014
????Errors in file /u01/app/oracle/diag/rdbms/d012dg/d012band/trace/d012band_dbw0_4784178.trc:
????ORA-01186: file 3 failed verification tests
????ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
????ORA-01111: name for data file 3 is unknown - rename to correct file
????ORA-01110: data file 3: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00003'
?????????????/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00003?????????ο????£???11gR2 Active Data Guard????????[1]??http://blog.itpub.net/23135684/viewspace-759592/
????File 3 not verified due to error ORA-01157
????MRP0: Background Media Recovery terminated with error 1111
????Errors in file /u01/app/oracle/diag/rdbms/d012dg/d012band/trace/d012band_pr00_8716760.trc:
????ORA-01111: name for data file 3 is unknown - rename to correct file
????ORA-01110: data file 3: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00003'
????ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
????ORA-01111: name for data file 3 is unknown - rename to correct file
????ORA-01110: data file 3: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00003'
????Managed Standby Recovery not using Real Time Apply
????Slave exiting with ORA-1111 exception
????Errors in file /u01/app/oracle/diag/rdbms/d012dg/d012band/trace/d012band_pr00_8716760.trc:
????ORA-01111: name for data file 3 is unknown - rename to correct file
????ORA-01110: data file 3: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00003'
????ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
????ORA-01111: name for data file 3 is unknown - rename to correct file
????ORA-01110: data file 3: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00003'
????Recovery Slave PR00 previously exited with exception 1111
????MRP0: Background Media Recovery process shutdown (d012band)
????Completed: alter database recover managed standby database using current logfile disconnect from session
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11