I got a request to configure Server file system level & Oracle Database backups. Oracle Databases are running in Cluster environment , I went through EMC Avamar 7.0 for Oracle user guide.
But Now my doubt is What are the details I need ask to Database Team & What is the best practice to proceed with configuration, I bit confused after reading the document as well.
Scheduling Oracle database backups & Backup and Restore with Oracle RMAN
We are also using Avamar v7 to backup up the Linux file systems and the Oracle databases w/the RMAN plugin. I spent a few weeks with one of our DBAs thoroughly documenting the following processes:
Backup database & logs
Restore to same instance
Restore (DUPLICATE) to another (DEV/TEST) instance.
First, on each server, you'll need to make the avtar-flags.txt file. If you are backing up large databases (> 500GB), you'll want to utilize multiple RMAN channels to speed things up. Depending on the size of your database(s) and the number of channels, set the avtar-flags.txt "--hashcachemax=" directive appropriately (see EMC/Avamar docs for details). Also, if you are targeting a Data Domain unit, set these directives in the avtar-flags.txt file:
--ddr
--ddr-index=1
Here's a copy of my avtar-flags.txt file from a Linux (RHEL 5) server; note that this is targeting a Data Domain (using dd-boost, hence the --ddr line), and the databases being backed up are around 4TB (4,000 GB) and we use 4 RMAN channels, hence the --hashcachemax=2000:
IMPORTANT: make sure that the "oracle" user that runs the RMAN process has permission to read the avtar-flags.txt file, and also can write log and cache files into the "vardir" (/var/avamar in my case).
SETTING UP YOUR ENVIRONMENT:
"su - " to the oracle user that will execute RMAN; set your environment like so: (you may need to adjust the paths depending on your install):
Get the "dbid" of the database you are going to restore; your DBA will know how to do this. Setup your environment (see previous post) and execute RMAN, connecting to target & catalog; here is an example set of scripts to recover a dropped database that we had backed up; this uses 1 RMAN channel.
The idea is to 1st restore the controlfile, then restore the database, then recover it. Here's the example for an instance called "TEST" with a fictional "dbid" of 1234:
Single channel RMAN restore; instance name TEST, dbid=1234*.
*Note: 1234 is not an actual/valid DBID
---------------------------START RMAN TEST INSTANCE RECOVER SCRIPT-------------------
# Restore controlfile:
set dbid=1234;
run{
allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so ENV=(PATH=/bin:/usr/local/avamar/bin)";
We run single instance and RAC environments and back them up without any special configurations, using the same methodology. We did NOT use the rac_config script for our RAC instances. For those, we always just backup/restore from 1 node, just like we would on a single instance host. Works fine.
For example, a 3 node RAC database consisting of node1.example.com, node2.example.com, and node3.example.com.
We install the Avamar client on all 3 servers and register them with the Avamar system for file system backups. Then on node1, we also install the AvamarRMAN plugin, and do the Oracle RMAN backups/restores from there.
Note that we schedule, initiate/control all backups/restores using RMAN on the Oracle servers; this way the DBAs control/schedule all backups & restores & and feel comfortable with this arrangement.
Vamsi_P
1 Rookie
•
52 Posts
7939
0
Posted October 17th, 2014 09:00
Oracle Database are running on Cluster environment..