Database Software

Hi all,

I rolled forward a physical standby database using RMAN incremental backups as detailed in Oracle support ID **836986*.1* and it all went well until i tried to switch the standby database to copy.

I get the error RMAN-06571 datafile 24 does not have recoverable copy

Now datafile 24 is a datafile created after the scn of the standby database and there's unfortunately no documentation on how to restore this datafile from the backup piece created as part of the incremental backup created from the primary. The oracle document says

*"if any datafiles have been added to primary after scn <n> they will also have to restored to the standby host and cataloged before doing the switch"*

Unfortunately it does not say how this is to be done.

I have tried to restore datafile 24 but even that produces an

RMAN-12008 could not locate backup piece /x/y/piecename

even though the backup piece is in the location /x/y/piecename and has been cataloged via rman. The same backup piece was used to restore the datafiles that existed earlier. i.e. the other 23, successfully so i know it has the datafile i need.

My environment is a 3-node RAC (Primary & Standby). I am really at my wits end.

All help appreciated.