Anyone out there with above combination?
We are looking for HOWTO or Best Practice docs, or simply advice from someone with hands-on experience.
Our customer will be deploying NBU 8.2 for a brand new Oracle Installation.
This will be Oracle Supercluster/RAC on ASM storage with Flash (Fast) Recovery Area as part of the config.
NBU needs to backup the data from the FRA.
We have had a look in the NBU for Oracle manuals (incl new 8.2 manual) – there are a couple of references to “Fast Recovery Area” – mostly related to OIP.
So, OIP seems to be the easiest way where FRA is a simple click in the OIP Backup Selections Tab.
We know that OIP can only be used for Oracle RAC when only a single host name or client name is needed to take the backup.
OIP cannot be used when more than one client name must be used for backup.
As this is all brand new (the Supercluster still to be deployed), we don’t know yet if OIP will be possible. We need to prepare for script-based backups (just in case).
Does anyone perhaps have experience with such a setup?
Would you be willing to share your scripts and/or documentation?
(Hostnames can be replaced with generic names.)
I dont have project experience with FRA backups, but I have performed quick test and it seems that adding a command "BACKUP [FORCE] RECOVERY AREA" into a legacy based script should be enough - OIP with FRA in Backup Selection generates this command into parent Job detail.
FORCE means that a certain file from FRA is backed up again even if it has already been backup up before.
IMHO when a third-party backup solution with like NetBackup will be used for direct backups to sbt then additional backups of FRA does not make much sense (it will be just backup of backups).
Keeping this at a high level we run several large multi node RAC clusters and we haven't had any issues. I'm not in a position to share documentation but I would say you need to liase with your DBA's to get them to think about how they are going to approach protecting data with RMAN and get them to configure the RMAN scripts.
We also backup the FRA as the backup images are only kept for a short time in this area. My advice would be to stay well away from OIP as even after getting it to backup all ok (if at all possible) you can get real problems restoring. After spending all the money, time and effort on RAC I would say to try and bandaid OIP on the side is not the right approach. My personal advice would be:
It really is more of a Oracle backup strategy rather than Netbackup. In this case NetBackup will just be the bucket you pour data in and out of. RMAN and it's recovery catalogue is at the heart of the solution and not NetBackup.
Some notes from experience:
About the FRA:
Using NetBackup OIP:
Using RMAN scripts: