Friday, September 24, 2021

ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 : after rac database restore



When Performing a RAC 2 node Production Database Restore with disk based backup, by duplicating to a single instance database, Restoration went successful.
Once Restore has completed, i have tried to open the database with RESETLOGS option. But end with the below error, So thought of sharing this little information.


##########################
#   Errors 
##########################
RESETLOGS after incomplete recovery UNTIL CHANGE 13115861554203
ORA-38856 signalled during: alter database open resetlogs…
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

##########################
#   Command Used  
##########################
Alter Database open ResetLogs;


##########################
#   Informations  
##########################
This seems to be Bug 4355382 and its expected while doing RAC Restore/Recovery.



##########################
#  Solution 
##########################
  ADD _no_recovery_through_resetlogs Parameter and set it to TRUE. 

I have added _no_recovery_through_resetlogs=TRUE parameter to our PFILE and brought up the database to Mount Stage.
Now opened the database with RESETLOGS options and it worked.
This parameter tells oracle not to do any recovery while doing this resetlogs operation.
After Opening the database, the parameter can be removed from the pfile.

No comments:

Post a Comment