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