备库:
[oracle@hostb SBDB1]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jul 31 22:26:46 2015
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 372449280 bytes
Fixed Size 1313484 bytes
Variable Size 322962740 bytes
Database Buffers 41943040 bytes
Redo Buffers 6230016 bytes
Database mounted.
SQL> recover standby database;
ORA-00279: change 1156098 generated at 07/31/2015 22:10:03 needed for thread 1
ORA-00289: suggestion : /home/oracle/archive/SBDB1/1_100_884907736.dbf
ORA-00280: change 1156098 for thread 1 is in sequence #100
Specify log: {=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00279: change 1156325 generated at 07/31/2015 22:14:44 needed for thread 1
ORA-00289: suggestion : /home/oracle/archive/SBDB1/1_101_884907736.dbf
ORA-00280: change 1156325 for thread 1 is in sequence #101
ORA-00278: log file '/home/oracle/archive/SBDB1/1_100_884907736.dbf' no longer
needed for this recovery
ORA-00279: change 1156336 generated at 07/31/2015 22:15:03 needed for thread 1
ORA-00289: suggestion : /home/oracle/archive/SBDB1/1_102_884907736.dbf
ORA-00280: change 1156336 for thread 1 is in sequence #102
ORA-00278: log file '/home/oracle/archive/SBDB1/1_101_884907736.dbf' no longer
needed for this recovery
ORA-00279: change 1156346 generated at 07/31/2015 22:15:13 needed for thread 1
ORA-00289: suggestion : /home/oracle/archive/SBDB1/1_103_884907736.dbf
ORA-00280: change 1156346 for thread 1 is in sequence #103
ORA-00278: log file '/home/oracle/archive/SBDB1/1_102_884907736.dbf' no longer
needed for this recovery
ORA-00308: cannot open archived log
'/home/oracle/archive/SBDB1/1_103_884907736.dbf'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SQL> alter database recover managed standby database disconnect from session;
alter database recover managed standby database disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SQL>