OraFAQ Forum: Data Guard » Recover standby after losing sync

Home » Server Options » Data Guard » Recover standby after losing sync (Oracle 11.2.0.4.0, linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Recover standby after losing sync [message #680186]

Mon, 27 April 2020 03:34

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'

Report message to a moderator

Re: Recover standby after losing sync [message #680187 is a reply to message #680186]

Mon, 27 April 2020 04:25

John Watson
Messages: 8997
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.

Report message to a moderator

Previous Topic:	Unable to connect stand by
Next Topic:	Enterprise Oracle DB replication - what do you all use?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 08 18:28:58 CDT 2026