Shulou(Shulou.com)06/01 Report--

The standby library cannot be opened:

SQL > alter database open

Alter database open

*

ERROR at line 1:

ORA-10458: standby database requires recovery

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: datafile 1:'+ DATA/phub/datafile/system.258.884216521'

Log error:

Standby Crash Recovery aborted due to error 16016.

Errors in file / u01/app/oracle/admin/PHUB/diag/rdbms/phub/PHUB/trace/PHUB_ora_5643.trc:

ORA-16016: archived log for thread 1 sequence# 16 unavailable

Wait timeout: thread 2 sequence 14

Standby Crash Recovery aborted due to error 16016.

Errors in file / u01/app/oracle/admin/PHUB/diag/rdbms/phub/PHUB/trace/PHUB_ora_5971.trc:

ORA-16016: archived log for thread 2 sequence# 14 unavailable

Copy these two logs from the primary to the standby:

And then register.

SQL > alter database register physical logfile'/ home/oracle/thread_1_seq_16.365.883970323'

Database altered.

SQL > alter database register physical logfile'/ home/oracle/thread_2_seq_14.363.884216233'

Database altered.

Then open database

SQL > alter database open

Database altered.

Background log:

Beginning Standby Crash Recovery.

Serial Media Recovery started

Managed Standby Recovery starting Real Time Apply

Sun Jul 05 00:33:32 2015

Media Recovery Log / home/oracle/thread_1_seq_16.365.883970323

Media Recovery Log / home/oracle/thread_2_seq_14.363.884216233

Incomplete Recovery applied until change 43399676704 time 07/02/2015 03:17:58

Completed Standby Crash Recovery.

Sun Jul 05 00:33:34 2015

SMON: enabling cache recovery

Dictionary check beginning

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.