RMAN Recovery Catalog 백업

RMAN Recovery Catalog 백업

1. ORCL 데이터베이스에 대한 환경을 설정합니다.

$ . oraenv ORACLE_SID = [rcat] ? orcl

2. rcat 데이터베이스를 Target Database 로 지정하여 RMAN 에 로그인

$ rman target sys@rcat target database Password: oracle_4U <<< not displayed connected to target database: RCAT (DBID= 464959795) RMAN>

3. Recovery Catalog 데이터베이스를 Incremental 백업에 대한 Image Copy

및 기본으로 백업합니다. RMAN 을 종료합니다.

RMAN> backup as copy incremental level 0 database; Starting backup at 22-DEC-10 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=59 device type=DISK channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=/u01/app/oracle/oradata/rcat/system01.dbf output file name=/u01/app/oracle/fast_recovery_area/RCAT/datafile/o1 _mf_system_6k3w3wwc_.dbf tag=TAG20101222T123508 RECID=7 STAMP=738419763 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:06 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=/u01/app/oracle/oradata/rcat/sysaux01.dbf Copyright © 2011, Oracle. All rights reserved. 단원 5 의 연습: 백업 개념 및 전략 5 장 - 8 페이지 output file name=/u01/app/oracle/fast_recovery_area/RCAT/datafile/o1 _mf_sysaux_6k3w5ygh_.dbf tag=TAG20101222T123508 RECID=8 STAMP=738419818 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=/u01/app/oracle/oradata/rcat/undotbs01.dbf output file name=/u01/app/oracle/fast_recovery_area/RCAT/datafile/o1 _mf_undotbs1_6k3w7clj_.dbf tag=TAG20101222T123508 RECID=9 STAMP=738419823 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=+DATA/rcat/datafile/rcat01.dbf output file name=/u01/app/oracle/fast_recovery_area/RCAT/datafile/o1 _mf_rcat_6k3w7m9v_.dbf tag=TAG20101222T123508 RECID=10 STAMP=738419828 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03 channel ORA_DISK_1: starting datafile copy copying current control file output file name=/u01/app/oracle/fast_recovery_area/RCAT/controlfile /o1_mf_TAG20101222T123508_6k3w7p0m_.ctl tag=TAG20101222T123508 RECID=11 STAMP=738419830 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=/u01/app/oracle/oradata/rcat/users01.dbf output file name=/u01/app/oracle/fast_recovery_area/RCAT/datafile/o1 _mf_users_6k3w7q4l_.dbf tag=TAG20101222T123508 RECID=12 STAMP=738419831 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting incremental level 0 datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 22-DEC-10 channel ORA_DISK_1: finished piece 1 at 22-DEC-10 piece handle=/u01/app/oracle/fast_recovery_area/RCAT/backupset /2010_12_22/o1_mf_nnsn0_TAG20101222T123508_6k3w7rfc_.bkp tag=TAG20101222T123508 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 22-DEC-10 RMAN> exit Recovery Manager complete. $