Search This Blog

Friday, February 17, 2012

RMAN Catalog Creation.

Target Database:
Name:orcl
IP Address:192.168.1.55

Catalog Database:
Name:recovery
IP Address:192.168.1.200

On Catalog Database.

SQL>  create tablespace test datafile'/u01/app/oracle/oradata/recovery/test01' size 100m
     autoextend on
     extent management local
     segment space management auto;



SQL> create user rman identified by cat
  2  temporary tablespace temp
  3  default tablespace test
  4  quota unlimited on test;


SQL> grant connect,resource,recovery_catalog_owner to rman;

Grant succeeded.


SQL> exit


Listener entries.

# listener.ora Network Configuration File: /u01/app/oracle/product/
#  11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = RECOVERY)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = recovery)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521))
  )

ADR_BASE_LISTENER = /u01/app/oracle


TNSNAMES.ORA Entries

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/
#  11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

RECO =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.200)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = recovery)
    )
  )

LISTENER_RECOVERY =
  (ADDRESS = (PROTOCOL = TCP)(HOST = canada)(PORT = 1521))


ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.55)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )



[oracle@london ~]$ rman catalog rman/cat@reco

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 18:20:10 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog

recovery catalog created

RMAN> exit

[oracle@london ~]$ rman target= sys/sys@orcl catalog rman/cat@reco

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 18:31:55 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1297669608)
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    670      SYSTEM               YES     /u01/app/oracle/oradata/orcl/system01.dbf
2    480      SYSAUX               NO      /u01/app/oracle/oradata/orcl/sysaux01.dbf
3    60       UNDOTBS1             YES     /u01/app/oracle/oradata/orcl/undotbs01.dbf
4    5        USERS                NO      /u01/app/oracle/oradata/orcl/users01.dbf
5    100      EXAMPLE              NO      /u01/app/oracle/oradata/orcl/example01.dbf

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    20       TEMP                 32767       /u01/app/oracle/oradata/orcl/temp01.dbf



Cataloging Older Files in the Recovery Catalog.

Cataloging older backups that have aged out of the control file lets RMAN use older backups.

Example:

RMAN> catalog start with '/u01/backup/';

or

RMAN> catalog backuppiece '/u01/backup/backup_567.bkp';
RMAN> catalog archivelog '/u01/backup/archives/arc_76.dbf';

To check for backup piece information run the following
as recovery catalog owner.

select START_TIME,COMPLETION_TIME,DB_ID,HANDLE,DEVICE_TYPE,STATUS from rc_backup_piece;

START_TIM COMPLETIO      DB_ID
--------- --------- ----------
HANDLE
---------------------------------------------------------------------------------------------------
DEVICE_TYPE
---------------------------------------------------------------------------------------------------
S
-
23-MAY-13 23-MAY-13 3764293269
/u01/app/oracle/flash_recovery_area/DELL/backupset/2013_05_23/o1_mf_annnn_TAG20130523T130527_8svkoz
dw_.bkp
DISK
A

23-MAY-13 23-MAY-13 3764293269
/u01/app/oracle/flash_recovery_area/DELL/backupset/2013_05_23/o1_mf_nnndf_TAG20130523T130528_8svkp3
tr_.bkp
DISK
A

23-MAY-13 23-MAY-13 3764293269
/u01/app/oracle/flash_recovery_area/DELL/backupset/2013_05_23/o1_mf_annnn_TAG20130523T130728_8svksr
cf_.bkp
DISK
A

23-MAY-13 23-MAY-13 3764293269
/u01/app/oracle/flash_recovery_area/DELL/autobackup/2013_05_23/o1_mf_s_816181650_8svksw4c_.bkp
DISK
A

For more recovery catalog views:

http://docs.oracle.com/cd/E18283_01/backup.112/e10643/rcviews001.htm#

0 comments:

Post a Comment