Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Can file or RMAN restores continue while a catalog recovery is ongoing?

Created: 06 Nov 2013 • Updated: 12 Nov 2013 | 6 comments
This issue has been solved. See solution.

Hello all,

Does Netbackup support a simultaneous restore of files AND the catalog?

We have a DR environment that we're restoring our primary site's catalog to - on a daily basis. Once the catalog is restored in the DR environment, our DBAs run RMAN recoveries to test Oracle DB recoveries. But we have to coordinate it carefully lest the DBAs kick off an RMAN restore the same time the catalog is restoring. 

I am hoping to find out if an RMAN recovery can take place alongside an ongoing catalog restore and not mess things up.

Thank You!

Operating Systems:

Comments 6 CommentsJump to latest comment

SymTerry's picture

Hello,

If a RMAN restore is kicked off during, or before, a catalog recovery, the end result is the job will fail and you will have possible hung resources.

In a catalog restore, besides the catalog having been recovered, the jobs database from the last catalog backup will have been restored as well. The RMAN job that was running will have never existed. 

SOLUTION
Marianne's picture

Catalog recovery restores firstly the images database and then the EMM database.

Image '.f' files reside in images database and the header files (info about backups that is needed for RMAN queries) reside in EMM database.

So, only when images and EMM are restore and all daemons/processes restarted will restore be possible.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

alokjha's picture

Thank you both, Terry and Marianne.

Am I right in concluding that - RMAN recoveries can take place alongside a catalog restore as long as the environment has an images database and EMM database from a previous catalog restore AND the RMAN restore only attempts to recover images backed up via jobs that were included in the previously restored catalog (and not the one being restored simultaneously with the RMAN restore).

SymTerry's picture

There is no real gauge for when it would be OK, besides waiting for the catalog restore job to complete. Marianne mentioned the daemons/processes restarting. You could monitor them for a restart and then test a RMAN restore. 

Marianne's picture

The moment you can use 'bplist' command to list the latest backups, you should be able to start the restore.

Best to wait for catalog backups to complete.

If catalog recovery means that RTO is not met, you may want to look at catalog replication instead.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

alokjha's picture

Thank you all. Since I had a sandbox environment I could play in, I went ahead and tested the theory of simulatenous catalog recovery and RMAN restore. Some succeeded, others had errors. Individual file restores on backed up hosts (instead of RMAN restores) with a catalog restore running side-by-side succeeded 100% of the time, albeit the restore was very slow.

Takeaways from the post for me:

There is no real gauge for when it would be OK, besides waiting for the catalog restore job to complete. 

And

Best to wait for catalog backups to complete.

RTO requirements will be met with the currently employed methodology; I am hoping to be able to use NBU-AIR when it becomes available with Netbackup 7.6 for the OSTs our site is using.