错
误:File #483 added to control file as 'UNNAMED00483' becausethe parameter STANDBY_FILE_MANAGEMENT is set to MANUALThe file should be manually created to continue.Errors with log +FRA/cweolb/archivelog/2015_08_02/thread_1_seq_225515.7695.886664431MRP0: Background Media Recovery terminated with error 1274Errors in file /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_pr00_19398846.trc:ORA-01274: cannot add datafile '+DATA/cweol/datafile/tstlog.2015080201' - file could not be createdManaged Standby Recovery not using Real Time ApplyRecovery interrupted!Sun Aug 02 21:55:44 2015Recovered data files to a consistent state at change 61278149367Sun Aug 02 21:55:44 2015MRP0: Background Media Recovery process shutdown (CWEOLB)Mon Aug 03 10:57:23 2015ALTER SYSTEM SET standby_file_management='AUTO' SCOPE=BOTH;Mon Aug 03 10:58:29 2015 alter database recover managed standby database using current logfile disconnect from sessionAttempt to start background Managed Standby Recovery process (CWEOLB)Sun Aug 02 21:58:29 2015MRP0 started with pid=38, OS id=7733714 MRP0: Background Managed Standby Recovery process started (CWEOLB) started logmerger processSun Aug 02 21:58:34 2015Managed Standby Recovery starting Real Time ApplySun Aug 02 21:58:34 2015Errors in file /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_dbw0_9896432.trc:ORA-01186: file 483 failed verification testsORA-01157: cannot identify/lock data file 483 - see DBWR trace fileORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'File 483 not verified due to error ORA-01157MRP0: Background Media Recovery terminated with error 1111Errors in file /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_pr00_20250790.trc:ORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'ORA-01157: cannot identify/lock data file 483 - see DBWR trace fileORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'Managed Standby Recovery not using Real Time ApplySlave exiting with ORA-1111 exceptionErrors in file /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_pr00_20250790.trc:ORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'ORA-01157: cannot identify/lock data file 483 - see DBWR trace fileORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'Recovery Slave PR00 previously exited with exception 1111MRP0: Background Media Recovery process shutdown (CWEOLB)Completed: alter database recover managed standby database using current logfile disconnect from sessionMon Aug 03 11:03:03 2015alter database recover managed standby database using current logfile disconnect from sessionAttempt to start background Managed Standby Recovery process (CWEOLB)Sun Aug 02 22:03:03 2015MRP0 started with pid=38, OS id=16253320 MRP0: Background Managed Standby Recovery process started (CWEOLB) started logmerger processSun Aug 02 22:03:08 2015Managed Standby Recovery starting Real Time ApplySun Aug 02 22:03:08 2015Errors in file /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_dbw0_9896432.trc:ORA-01186: file 483 failed verification testsORA-01157: cannot identify/lock data file 483 - see DBWR trace fileORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'File 483 not verified due to error ORA-01157MRP0: Background Media Recovery terminated with error 1111Errors in file /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_pr00_19661014.trc:ORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'ORA-01157: cannot identify/lock data file 483 - see DBWR trace fileORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'Managed Standby Recovery not using Real Time ApplySlave exiting with ORA-1111 exceptionErrors in file /oracle/orabase/admin/CWEOLB/diag/rdbms/cweolb/CWEOLB/trace/CWEOLB_pr00_19661014.trc:ORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'ORA-01157: cannot identify/lock data file 483 - see DBWR trace fileORA-01111: name for data file 483 is unknown - rename to correct fileORA-01110: data file 483: '/oracle/orabase/ora11gr2/dbs/UNNAMED00483'Recovery Slave PR00 previously exited with exception 1111MRP0: Background Media Recovery process shutdown (CWEOLB)Completed: alter database recover managed standby database using current logfile disconnect from session
解决办法:
ALTER SYSTEM SET standby_file_management='MANUAL' SCOPE=BOTH;SQL> alter database create datafile '/oracle/orabase/ora11gr2/dbs/UNNAMED00483' as '+DATA/cweolb/datafile/tstlog.2015080201';Database altered.alter database recover managed standby database using current logfile disconnect from session;