Database Administration (MOSC)

MOSC Banner

Rman list incarnation shows orphan ... how to remove that from rman catalog?

Oracle EE 18.14 -- primary, 2 standbys;

Recovery catalog

I removed one of my 2 standby's from my dgrmgrl configuration by;

  1. disable database standby2
  2. remove database standby2;
  3. recover managed standby database cancel (on the standby2)
  4. alter database active physical standby database (on standby2)
  5. alter database open (on standby2) -- my plan is to turn this standby2 into a test database--while primary & standby1 are my true production primary & standby dbs
  6. in my rman on primary (while connected to my recovery catalog) -- i did unregister db_unique_name of my standby2. ALL IS GOOD up to this point.
  7. then I messed up --- from my standby2 WHILE connected to my recovery catalog ...I was going to unregister it from standby2 .....BUT instead when i did show all; rman said new incarnation of database registered in recovery catalog starting full resync of recovery catalog. I SHOULD NOT HAVE DONE This...and i don't think i could have unregistered ir connected this way anyways...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center