Avamar: How to create an Oracle Dataset to backup Oracle databases
Summary: This knowledge base article shows a video on how to create an Oracle dataset to backup Unix/Linux Standalone and Cluster environments..
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Instructions
NOTE: This knowledge base article assumes that Avamar Filesystem and Oracle plugin has already been installed on the Oracle box and if this is a RAC environment the rac_config tool has already been run as well.
1- Open putty/ssh to the Oracle box.
2- Identify the Oracle Databases running on the Oracle box.
3- Make sure the databases found in step 2 are all in oratab.
Example for the standalone case
NOTE:
4- Open Avamar Administrator.
5- Click on Tools and Select Manage Datasets.
6- Click on New.
7- Type a Name for the Dataset name.
8- Select Enter Explicitly and select the Plug-In Type.
9- Remove ALL defaults.
10- Click on the "..." on Select Files and/or Folders.
11- Look for the Oracle Client and select it.
12- Expand the Oracle RMAN Plug-In.
13- Select Database names.
NOTE: In a Cluster environment do NOT select the instance name, only select the database name found in step 2.
14- Go to options and complete the Dataset Creation and click OK when it is completed.
NOTE:
A workaround to step 10 is to add the database name directly by typing its name. It is important than in a cluster case the Database Name is input instead of the instance names.
1- Open putty/ssh to the Oracle box.
2- Identify the Oracle Databases running on the Oracle box.
- If this is a standalone environment run "ps -ef | grep smon" to collect all the instances already running on the Oracle box.
Example:
ps -ef | grep smon
oracle 439032 1 0 Oct19 ? 00:00:05 ora_smon_orcl21c
ps -ef | grep smon
oracle 439032 1 0 Oct19 ? 00:00:05 ora_smon_orcl21c
- If this is a RAC environment run "<path_oracle_grid_install>/srvctl config database
Example:
/u01/grid/bin/srvctl config database
orcl
/u01/grid/bin/srvctl config database
orcl
3- Make sure the databases found in step 2 are all in oratab.
Example for the standalone case
cat /etc/oratab
...
orcl21c:/oracle_install:N
Example for the cluster case
cat /etc/oratab
...
orcl:/u01/database:N
...
orcl21c:/oracle_install:N
Example for the cluster case
cat /etc/oratab
...
orcl:/u01/database:N
NOTE:
- Avamar Oracle dataset must be created with the Oracle Database name in a RAC environment so in this example orcl must be in oratab. The instance names such as orcl1 and orcl2 can be in oratab but should not be selected as part of the Avamar dataset.
- Verify all the fields in /etc/oratab with the help of the Oracle DBA.
- oratab is located in Linux environemts in /etc and on some other OS under /var/opt/oracle. Please verify and consult the DBA for the location of oratab.
4- Open Avamar Administrator.
5- Click on Tools and Select Manage Datasets.
6- Click on New.
7- Type a Name for the Dataset name.
8- Select Enter Explicitly and select the Plug-In Type.
9- Remove ALL defaults.
10- Click on the "..." on Select Files and/or Folders.
11- Look for the Oracle Client and select it.
12- Expand the Oracle RMAN Plug-In.
13- Select Database names.
NOTE: In a Cluster environment do NOT select the instance name, only select the database name found in step 2.
14- Go to options and complete the Dataset Creation and click OK when it is completed.
NOTE:
A workaround to step 10 is to add the database name directly by typing its name. It is important than in a cluster case the Database Name is input instead of the instance names.
Additional Information
Refer to this published video:
Article Properties
Article Number: 000204555
Article Type: How To
Last Modified: 17 Nov 2022
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.