Assume that -
my target database name ==> PROD (@TPROD is
TNSNAME)
my Catalog database name==> TEST
(@TTEST is TNSNAME)
$export ORACLE_SID=TEST (here i want to
create catalog in this TEST database)
$ sqlplus / as sysdba
Create a user which will be owner of the recovery catalog;
======================================================
SQL> create user rmanuser identified by rmanuser;
- Grant necessary roles, privileges to user "rmanuser"
SQL> grant connect, resource ,recovery_catalog_owner to rmanuser;
Connect to Catalog database(TEST) as a rmanuser and Create Recovery Catalog
- Grant necessary roles, privileges to user "rmanuser"
SQL> grant connect, resource ,recovery_catalog_owner to rmanuser;
Connect to Catalog database(TEST) as a rmanuser and Create Recovery Catalog
=================================================================
RMAN> connect catalog rmanuser/rmanuser@TTEST
connected to recovery catalog database
Connect to target database now.
=================================================================
RMAN> connect target sys /syspassword@TPROD
connected to target database: PROD (DBID=314074644)
Create catalog and register target database in to catalog.
=================================================================
RMAN> create catalog;
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
Verify that the registration was successful by running REPORT SCHEMA
=============================================================
RMAN> report schema;
Report of database schema for database with db_unique_name PROD
List of Permanent Datafiles
===========================
File Size(MB)
Tablespace RB segs
Datafile Name
---- -------- -------------------- ------- ------------------------
1 680
SYSTEM
YES /u01/app/oracle/oradata/PROD/system01.dbf
2 480
SYSAUX
NO /u01/app/oracle/oradata/PROD/sysaux01.dbf
3 40
UNDOTBS1
YES /u01/app/oracle/oradata/PROD/undotbs01.dbf
4 5
USERS
NO /u01/app/oracle/oradata/PROD/users01.dbf
5 100
EXAMPLE
NO /u01/app/oracle/oradata/PROD/example01.dbf
6 100
USERS
NO /u01/app/oracle/oradata/PROD/users02.dbf
List of Temporary Files
=======================
File Size(MB)
Tablespace
Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20
TEMP
32767
/u01/app/oracle/oradata/PROD/temp01.dbf
RMAN>exit
Do you like this post? Please share this article.
HTML Link Code:
Post a Comment