Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
RECOVER STANDBY DATABASE FROM SERVICE

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?