4.0 init.ora on test_us01ap17
—————————–

The “init.ora”, e.g., C:\oracle\admin92\CRM\pfile\initCRM.ora needs to be made available on test_us01ap17. Any location specific parameters must be ammended. For example,
- ifile
- *_dump_dest
- log_archive_dest*
- control_files

5.0 SQL*Net configuration
————————-

If running rman from us01ap17:

a. connectivity to the catalog remains unchanged
b. configure tnsnames.ora on us01ap17 to connect to duplicated database on test_us01ap17 configure listener.ora on test_us01ap17 to accept connections for duplicated database

If running rman from test_us01ap17:

a. configure tnsnames.ora on test_us01ap17 to connect to catalog
listener.ora on catalog host remains unchanged

b. configure tnsnames.ora on test_us01ap17 to connect to duplicated db on test_us01ap17 configure listener.ora on test_us01ap17 to accept connections for duplicated database

If running rman from test_us01ap19 (ie, neither us01ap17 or test_us01ap17):

a. connectivity to the catalog remains unchanged
b. configure tnsnames.ora on test_us01ap19 to connect to duplicated db on test_us01ap17
configure listener.ora on test_us01ap17 to accept connections for duplicated database

In this example, RMAN catalog database is installed on test_us01ap19 on test_us01ap17, the tnsnames.ora has the following lines for RMAN

RMAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = test_us01ap19)(Port = 1521))
)
(CONNECT_DATA =
(SID = rman)
(SERVER = DEDICATED)
)
)

5.1 Create RMAN catalog schema.
Run this script to create a new RMAN catalog schema

sqlplus /nolog
connect sys/change_on_install@rman as sysdba
rem create tablespace rmancatalog datafile ‘P:\Rman\oradata\rmancatalog.dbf’ size 50m;
drop user rmanunan cascade;
create user rmanunan identified by rman4CRM
temporary tablespace temp
default tablespace rmancatalog
quota unlimited on rmancatalog;
grant recovery_catalog_owner, connect, resource to rmanunan;
exit;

Popularity: 20%

Bookmark This

Hide Sites

Pages: 1 2 3 4 5