cancel
Showing results for 
Search instead for 
Did you mean: 

Ocale8i with Netbackup

paulbronander
Level 3
I installed NetBackup for Oracle8i, and as a part of it I had to run $ORACLE_HOME/rdbms/admin/catrman.sql
but I don't have it.
Do you know anything about it?

1 ACCEPTED SOLUTION

Accepted Solutions

andre_m_alves
Level 3
In oracle 8i catrman.sql is replaced with the command create catalog.
catrman.sql creates all the catalog tables for RMAN and now the create catalog command replaces it.

To set up the recovery catalog schema:

Start SQL*Plus and then connect with administrator privileges to the database containing the recovery catalog. For example, enter:

SQL> CONNECT sys/change_on_install@rcat

Create a user and schema for the recovery catalog:

SQL> CREATE USER rman IDENTIFIED BY rman
2> TEMPORARY TABLESPACE temp
3> DEFAULT TABLESPACE cattbs
4> QUOTA UNLIMITED ON cattbs;

Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with privileges to maintain and query the recovery catalog.

SQL> GRANT recovery_catalog_owner TO rman;

Grant other desired privileges to the RMAN user.

SQL> GRANT connect, resource TO rman;

To create the recovery catalog:

Connect to the database that will contain the catalog as the catalog owner. For example, from the operating system command line enter:

% rman catalog rman/rman@rcat

You can also connect from the RMAN prompt:

% rman
RMAN> connect catalog rman/rman@rcat

Issue the create catalog command to create the catalog, specifying the CATTBS tablespace:

RMAN> create catalog tablespace cattbs;

Also read Oracle's documentation in:
Oracle8i Recovery Manager User's Guide and Reference.

View solution in original post

3 REPLIES 3

paulbronander
Level 3
...

andre_m_alves
Level 3
In oracle 8i catrman.sql is replaced with the command create catalog.
catrman.sql creates all the catalog tables for RMAN and now the create catalog command replaces it.

To set up the recovery catalog schema:

Start SQL*Plus and then connect with administrator privileges to the database containing the recovery catalog. For example, enter:

SQL> CONNECT sys/change_on_install@rcat

Create a user and schema for the recovery catalog:

SQL> CREATE USER rman IDENTIFIED BY rman
2> TEMPORARY TABLESPACE temp
3> DEFAULT TABLESPACE cattbs
4> QUOTA UNLIMITED ON cattbs;

Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with privileges to maintain and query the recovery catalog.

SQL> GRANT recovery_catalog_owner TO rman;

Grant other desired privileges to the RMAN user.

SQL> GRANT connect, resource TO rman;

To create the recovery catalog:

Connect to the database that will contain the catalog as the catalog owner. For example, from the operating system command line enter:

% rman catalog rman/rman@rcat

You can also connect from the RMAN prompt:

% rman
RMAN> connect catalog rman/rman@rcat

Issue the create catalog command to create the catalog, specifying the CATTBS tablespace:

RMAN> create catalog tablespace cattbs;

Also read Oracle's documentation in:
Oracle8i Recovery Manager User's Guide and Reference.

andre_m_alves
Level 3
In oracle 8i catrman.sql is replaced with the command create catalog.
catrman.sql creates all the catalog tables for RMAN and now the create catalog command replaces it.

To set up the recovery catalog schema:

Start SQL*Plus and then connect with administrator privileges to the database containing the recovery catalog. For example, enter:

SQL> CONNECT sys/change_on_install@rcat

Create a user and schema for the recovery catalog:

SQL> CREATE USER rman IDENTIFIED BY rman
2> TEMPORARY TABLESPACE temp
3> DEFAULT TABLESPACE cattbs
4> QUOTA UNLIMITED ON cattbs;

Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with privileges to maintain and query the recovery catalog.

SQL> GRANT recovery_catalog_owner TO rman;

Grant other desired privileges to the RMAN user.

SQL> GRANT connect, resource TO rman;

To create the recovery catalog:

Connect to the database that will contain the catalog as the catalog owner. For example, from the operating system command line enter:

% rman catalog rman/rman@rcat

You can also connect from the RMAN prompt:

% rman
RMAN> connect catalog rman/rman@rcat

Issue the create catalog command to create the catalog, specifying the CATTBS tablespace:

RMAN> create catalog tablespace cattbs;

Also read Oracle's documentation in:
Oracle8i Recovery Manager User's Guide and Reference.