Forum Stats

  • 3,769,805 Users
  • 2,253,023 Discussions
  • 7,875,211 Comments

Discussions

RECOVER STANDBY DATABASE FROM SERVICE

cptkirksh
cptkirksh Member Posts: 83 Red Ribbon

We are running oracle 18c and i have a standby that got way behind so i decided to run the command RECOVER STANDBY DATABASE FROM SERVICE to bring it current.  It seems a tablesapce go created while it was behind.

Here are my steps.

1. got new controlfile

alter database create standby controlfile as '/mylocation';

2. applied new controlfile

restore standby controlfile to '+DATA' from '/mylocation';

3.  logged on via command line

rman TARGET "c##backup/[email protected] as sysbackup" CATALOG cat/[email protected];

4.  then resync with primary

resync catalog from db_unique_name myprim;

5.  then ran this command to recover.

RECOVER STANDBY DATABASE FROM SERVICE myprim;

i then got this..

Starting recover at 09-JUN-20

ORA-20079: full resync from primary database is not done

starting resync from primary

resyncing from database with DB_UNIQUE_NAME myprim

resync from primary complete

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/09/2020 17:02:06

RMAN-03014: implicit resync of recovery catalog failed

RMAN-03009: failure of partial resync command on default channel at 06/09/2020 17:02:06

RMAN-20999: internal error

ok what gives and where did i go wrong?