RMAN Recovery Issue in RAC to single node
Setup:
We have a 2 node RAC (11g R2 on OEL 64 bit 5.4)) setup which uses ASM. We also have a full DB and archive log backup along with control file and sp file. RAC Node has crashed and we are trying to recover the RAC node as a stand alone node. We are following Metalink Article 415579.1. Restore and recovery will be ASM Filesystem to NON-ASM filesystem one.
Issue:
I can very well restore PFILE using SPFILE backup and disable the CLUSTER settings in PFILE. I could also restore controlfile. And I have successfully cataloged the full DB backup I have. Issue arises when I am trying to restore the database backup. it does not pick up the available DB backup. When I use LIST BACKUP OF DATABASe, it displays the backup in available state.There was an old backup in flashback recovery area where someone had performed the recovery earlier. RMAN picks that backup to restore rather than the backup I cataloged recently.
We have a 2 node RAC (11g R2 on OEL 64 bit 5.4)) setup which uses ASM. We also have a full DB and archive log backup along with control file and sp file. RAC Node has crashed and we are trying to recover the RAC node as a stand alone node. We are following Metalink Article 415579.1. Restore and recovery will be ASM Filesystem to NON-ASM filesystem one.
Issue:
I can very well restore PFILE using SPFILE backup and disable the CLUSTER settings in PFILE. I could also restore controlfile. And I have successfully cataloged the full DB backup I have. Issue arises when I am trying to restore the database backup. it does not pick up the available DB backup. When I use LIST BACKUP OF DATABASe, it displays the backup in available state.There was an old backup in flashback recovery area where someone had performed the recovery earlier. RMAN picks that backup to restore rather than the backup I cataloged recently.
0