Home » Server Options » Data Guard » Recover standby after losing sync (Oracle 11.2.0.4.0, linux)
icon5.gif  Recover standby after losing sync [message #680186] Mon, 27 April 2020 03:34 Go to next message
alex.bhgbx
Messages: 1
Registered: April 2020
Junior Member
Hello. There is my problem. My standby lose synch with primary. to resolve this i tried to recover it with incremental backup from primary from current standby scn. After recover and restoring control file from this backup on step open database i have next
ORA-10458: standby database requires recovery
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/u01/oracle/oradata/stbmain/sysaux01.dbf'

When i do recover of this datafile, recover of database "broke"(it means that all tablespaces dbfs i need again rename because they're located in different folders).

Here some my actions:
rman target/
RMAN> catalog start with '/u04/oracle/oradata/backp/backp';
RMAN> recover database noredo;
SQL> shut immediate
SQL> startup nomount
RMAN> restore standby controlfile from '/u04/oracle/oradata/backp/backp/...';
SQL> shut immediate
SQL> startup
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size 2265224 bytes
Variable Size 1224740728 bytes
Database Buffers 5167382528 bytes
Redo Buffers 19292160 bytes
Database mounted.
ORA-10458: standby database requires recovery
ORA-01194: file 2 needs more recovery to be consistent
ORA-01110: data file 2: '/u01/oracle/oradata/stbmain/sysaux01.dbf'
Re: Recover standby after losing sync [message #680187 is a reply to message #680186] Mon, 27 April 2020 04:25 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

Why did you restore the standby controlfile? Having done that, you will have to recover the database again.
Previous Topic: Unable to connect stand by
Next Topic: Enterprise Oracle DB replication - what do you all use?
Goto Forum:
  


Current Time: Thu Mar 28 06:36:08 CDT 2024