FAILURE IN PRIMARY DATABASE:
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to
a failed media recovery session
ORA-01110: data file 1:
'/u01/app/oracle/oradata/prime/system01.dbf'
SQL>
startup
ORACLE
instance started.
Total
System Global Area 1912602624 bytes
Fixed
Size 2925792 bytes
Variable
Size 1191185184 bytes
Database
Buffers
704643072 bytes
Redo
Buffers 13848576 bytes
Database
mounted.
ORA-10458:
standby database requires recovery
ORA-01196:
file 1 is inconsistent due to a failed media recovery session
ORA-01110:
data file 1: '/u01/app/oracle/oradata/prime/system01.dbf'
SQL>
alter database open read only;
alter
database open read only
*
ERROR
at line 1:
ORA-10458:
standby database requires recovery
ORA-01196:
file 1 is inconsistent due to a failed media recovery session
ORA-01110:
data file 1: '/u01/app/oracle/oradata/prime/system01.dbf'
PRIMARY
[oracle@ranesh
~]$ sqlplus /nolog
SQL*Plus:
Release 12.1.0.2.0 Production on Tue Sep 15 16:57:26 2020
Copyright
(c) 1982, 2014, Oracle. All rights
reserved.
SQL>
conn / as sysdba
Connected
to an idle instance.
SQL>
alter system switch logfile;
STANDBY
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Database
altered.
SQL>
alter database open read only;
Database
altered.
SQL> ALTER
DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
Database
altered.
PRIMARY:
[oracle@ranesh
~]$ sqlplus / as sysdba
SQL*Plus:
Release 12.1.0.2.0 Production on Tue Sep 15 17:26:31 2020
Copyright
(c) 1982, 2014, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With
the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL>
select name from v$database;
NAME
---------
PRIME
Standby
[oracle@ranesh ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on
Tue Sep 15 17:27:18 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition
Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced
Analytics and Real Application Testing options
SQL> select name from v$database;
NAME
---------
PRIME
No comments:
Post a Comment