（1）當你在做恢愎或是應用archivelog 日志時，出現archivelog目錄不是提示的目錄時，狀況如下：

SQL> recover standby database;
ORA-00279: ???? 12509357275011 ??? 06/21/2013 08:10:42 ? (???? 1 ??)
ORA-00289: ?? : /u/product/oracle/11.2.0/db_1/dbs/arch1_51184_801402735.dbf
ORA-00280: ?? 12509357275011 (???? 1) ???? #51184

????: {=suggested | filename | AUTO | CANCEL}
exit
ORA-00308: ???????? 'exit'
ORA-27037: ????????
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

（2）我的archivelog 日志放置在其它目錄，咋辦！

（3）使用以下命令變更日志目錄，然后進行恢愎或是應用日志。

SQL> set logsource '+DG_ARCH/human/arch/';

SQL> recover standby database;
ORA-00279: ???? 12509357275011 ??? 06/21/2013 08:10:42 ? (???? 1 ??)
ORA-00289: ?? : +DG_ARCH/human/arch/1_51184_801402735.dbf
ORA-00280: ?? 12509357275011 (???? 1) ???? #51184

????: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: ???? 12509357275011 ??? 06/21/2013 08:10:30 ? (???? 2 ??)
ORA-00289: ?? : +DG_ARCH/human/arch/2_19472_801402735.dbf
ORA-00280: ?? 12509357275011 (???? 2) ???? #19472

ITPub博客

Change Default Archive Log Destination While Doing Recovery From SQLPLUS

最新文章