RMAN 백업 장치 구성

RMAN 백업 장치 구성

1. SID 변수가 orcl 로 설정되었는지 확인합니다.

$ . oraenv ORACLE_SID = [orcl] ? orcl

2. orcl 에 Target Database 로 연결하여 RMAN 을 시작합니다.

$ rman target / connected to target database: ORCL (DBID=1264977510) RMAN>

3. 모든 구성 설정을 표시하고 정의된 테이프 장치가 있는지 확인합니다.

RMAN> show all; RMAN configuration parameters for database with db_unique_name ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET; CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl .f'; # default RMAN>

*SBT_TAPE 테이프 장치가 Oracle Secure Backup Installation 의 일부분으로 구성되었습니다.

4. 테스트 인터페이스를 사용하는 테이프 장치에 대한 채널을 정의합니다. 그러면 /backup/tape 디렉토리의 디스크에 실제로 기됩니다.

RMAN> configure channel device type sbt 2> parms='SBT_LIBRARY=oracle.disksbt,ENV=BACKUP_DIR=/backu p/tape)'; new RMAN configuration parameters: CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/ backup/tape)'; new RMAN configuration parameters are successfully stored RMAN>

5. 테이프 장치로 백업을 수행하여 작동하는지 확인합니다. USERS테이블스페이스를 백업합니다. 

그런 다음 RMAN 을 종료합니다.

RMAN> shutdown immediate; database closed database dismounted Oracle instance shut down RMAN> startup mount; Connected to target database (not started) Oracle instance started database mounted Total System Global Area 560791552 bytes Fixed Size 1345488 bytes Variable Size 239077424 bytes Database Buffers 314572800 bytes Redo Buffers 5795840 bytes RMAN> backup device type sbt tablespace users; Starting backup at 2011-01-05:07:45:55 allocated channel: ORA_SBT_TAPE_1 channel ORA_SBT_TAPE_1: SID=23 device type=SBT_TAPE channel ORA_SBT_TAPE_1: WARNING: Oracle Test Disk API channel ORA_SBT_TAPE_1: starting full datafile backup set channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set input datafile file number=00004 name=+DATA/orcl/datafile/users.259.737196673 channel ORA_SBT_TAPE_1: starting piece 1 at 2011-01-05:07:45:56 channel ORA_SBT_TAPE_1: finished piece 1 at 2011-01-05:07:45:57 piece handle=06m1b59k_1_1 tag=TAG20110105T074555 comment=API Version 2.0,MMS Version 8.1.3.0 channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01 Finished backup at 2011-01-05:07:45:57 Starting Control File and SPFILE Autobackup at 2011-01-05:07:45:57 piece handle=c-1264977510-20110105-01 comment=API Version 2.0,MMS Version 8.1.3.0 Finished Control File and SPFILE Autobackup at 2011-01-05:07:46:00 RMAN> alter database open; database opened RMAN> exit

*RMAN 에서 ORA_SBT_TAPE_1 이라는 채널을 사용하여 백업을 수행합니다.