Hp 3PAR Application Software Suite for Oracle Manual do Utilizador descarregar pdf (Página 76)

4.26

Setting Up NetBackup Policies for Oracle RMAN Backup

Recovery Manager 3.0.3/3.0.4 for Oracle User’s Guide

2 Create a tablespace for the Recovery Catalog as follows:

where:

◆ <catdb> is the Oracle Instance ID of the Recovery Catalog.

◆ <cat_tbs> is the Recovery Catalog tablespace name.

◆ <path/filename> is the file path where the datafile is created.

3 Create a user for the Recovery Catalog as follows:

where:

◆ <tbs_name> is the tablespace name of the Recovery Catalog.

◆ <rman_user> is the user name to be granted access permission to the Recovery

Catalog.

◆ <rman_password> is the password for the <rman_user>.

4 Create the RMAN Recovery Catalog tables as follows:

$ export ORACLE_SID=<catdb>

$ export ORACLE_HOME=<oracle_home>

$ sqlplus "/as sysdba"

SQL> create tablespace <cat_tbs> datafile '<path/filename>' size 10M;

SQL> exit

$ sqlplus "/as sysdba"

SQL> create user <rman_user> identified by <rman_password>

temporary tablespace temp

default tablespace <cat_tbs>

quota unlimited on <cat_tbs>;

SQL> grant connect, resource, recovery_catalog_owner to <rman_user>;

$ rman catalog <rman_user>/<rman_password>@<catdb>

RMAN> create catalog tablespace <cat_tbs>;

1 2 ... 71 72 73 74 75 76 77 78 79 80 81 ... 195 196

Sem comentários

Hp 3PAR Application Software Suite for Oracle Manual do Utilizador Página 76