Avamar: How to create an Oracle Dataset to backup Oracle databases
Resumen: This knowledge base article shows a video on how to create an Oracle dataset to backup Unix/Linux Standalone and Cluster environments..
Este artículo se aplica a
Este artículo no se aplica a
Este artículo no está vinculado a ningún producto específico.
No se identifican todas las versiones del producto en este artículo.
Instrucciones
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.
Información adicional
Refer to this published video:
Propiedades del artículo
Número del artículo: 000204555
Tipo de artículo: How To
Última modificación: 17 nov 2022
Versión: 3
Encuentre respuestas a sus preguntas de otros usuarios de Dell
Servicios de soporte
Compruebe si el dispositivo está cubierto por los servicios de soporte.