recover standby database (GAP)


bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 6 19:15:15 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2.0583E+10 bytes
Fixed Size 2190488 bytes
Variable Size 3019903848 bytes
Database Buffers 1.7515E+10 bytes
Redo Buffers 45883392 bytes
Database mounted.
SQL> recover standby database;
ORA-00279: change 1371278338695 generated at 07/06/2015 15:13:14 needed for
thread 2
ORA-00289: suggestion :
+DATA/kbazerdr/archivelog/2015_07_06/thread_2_seq_78032.975.884373355
ORA-00280: change 1371278338695 for thread 2 is in sequence #78032
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 1371278338695 generated at 07/06/2015 15:13:12 needed for
thread 1
ORA-00289: suggestion :
+DATA/kbazerdr/archivelog/2015_07_06/thread_1_seq_51690.2876.884365675
ORA-00280: change 1371278338695 for thread 1 is in sequence #51690
ORA-00279: change 1371279716895 generated at 07/06/2015 17:09:58 needed for
thread 1
ORA-00289: suggestion : +DATA
ORA-00280: change 1371279716895 for thread 1 is in sequence #51691
ORA-00278: log file
'+DATA/kbazerdr/archivelog/2015_07_06/thread_1_seq_51690.2876.884365675' no
longer needed for this recovery
ORA-00308: cannot open archived log '+DATA'
ORA-17503: ksfdopn:2 Failed to open file +DATA
ORA-15045: ASM file name '+DATA' is not in reference form
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '+DATA/kbazerdr/datafile/system.272.825112995'
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 6 19:17:40 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
Database altered.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: