Target DB Name : ORCL (Server : linux3)
Target DB Version : 11gR2
Catalog DB Name : RCAT (Server : linux4)
Catalog DB Version : 11g2
1. Create the default tablespace for the recovery catalog owner.
SQL> SET SQLPROMPT '_connect_identifier SQL>'
RCAT SQL>
RCAT SQL>CREATE TABLESPACE RMANTS DATAFILE '/u01/app/oracle/oradata/RCAT/datafile/RMANTS_01.dbf' SIZE 512M AUTOEXTEND ON;
Tablespace created.
RCAT SQL>
2. Create a recovery catalog owner in the Recovery Catalog Database
RCAT SQL>CREATE USER RMAN IDENTIFIED BY rman
DEFAULT TABLESPACE RMANTS
QUOTA UNLIMITED ON RMANTS; 2 3
User created.
RCAT SQL>
3. Grant necessary privilege to the recovery catalog owner
RCAT SQL>GRANT RECOVERY_CATALOG_OWNER TO RMAN;
Grant succeeded.
RCAT SQL>
4. Create the Recovery Catalog
** Make Sure that the catalog db name is added to the tnsnames.ora file.
[oracle@linux4 admin]$ rman catalog rman/rman@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 12 07:25:59 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to recovery catalog database
RMAN> CREATE CATALOG;
recovery catalog created
RMAN>
5. Make Sure that the catalog db name is added to the tnsnames.ora file on the target DB Server.
[oracle@linux3 ~]$ echo $ORACLE_SID
ORCL
[oracle@linux3 ~]$ tnsping RCAT
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 12-JUL-2015 07:31:54
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=linux4)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=RCAT)))
OK (20 msec)
6. Register the target database
[oracle@linux3 ~]$ rman target / catalog rman/rman@rcat
Recovery Manager: Release 11.2.0.1.0 - Production on Sun Jul 12 07:32:21 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1407538528)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> report schema;
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 680 SYSTEM YES /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_brg81t9h_.dbf
2 480 SYSAUX NO /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_brg81tch_.dbf
3 75 UNDOTBS1 YES /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_brg82r2j_.dbf
4 5 USERS NO /home/oracle/users.dbf
5 100 USER1 NO /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user1_brg81tcv_.dbf
6 100 USER2 NO /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user2_brg81thh_.dbf
7 100 USER3 NO /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user3_brg81tj3_.dbf
8 100 USER4 NO /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user4_brg81tl5_.dbf
9 100 USER5 NO /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user5_brg81tmy_.dbf
10 100 USER6 NO /u01/app/oracle/oradata/ORCL/datafile/o1_mf_user6_brg81toq_.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 29 TEMP 32767 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_temp_bobtojsg_.tmp
No comments:
Post a Comment