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

1. Create a database for housing the Recovery Catalog. Oracle suggests the following disk

space requirements:

• System tablespace: 100 MB

• Temp tablespace: 5 MB

• Rollback segment: 5 MB

• Online redo log: 1 MB (each)

• Recovery Catalog: 10 MB

2. Create a tablespace for the Recovery Catalog 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

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:

$ 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>;

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:

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

RMAN> create catalog tablespace <cat_tbs>;

5. Configure TNS services for the Recovery Catalog database by adding an entry in the

$ORACLE_HOME/network/admin/listener.ora file on the database server and backup

server as follows:

<catdb> =

(description =

(address = (protocol = TCP) (host = <cat_host>) (port = 1521))

(connect_data = (server = dedicated) (service_name = <catdb>))

)

where <cat_host> is the host name of the host where the catalog is created.

Setting Up NetBackup Policies for Oracle RMAN Backup 43

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 193 194

Sem comentários

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