DG ora-ora-16016 Error

Source: Internet
Author: User

The repository 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 wasn't restored from a sufficiently old backup
Ora-01110:data file 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# 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# unavailable


Copy these two logs from the main library to the repository:
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.

Re-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

DG ora-ora-16016 Error

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.