DB스토리

Archive log mode 확인

select log_mode from v$database;

full backup 본 있을 것.

rman target /

list backup of database;

rman 관련.

 RMAN> show all;

using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK 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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.2.0/db_1/dbs/snapcf_orcl.f'; # default

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO tape;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'TAPE';
new RMAN configuration parameters are successfully stored

RMAN> run { 

allocate channel x device type disk;
backup tablespace example;
}

allocated channel: x
channel x: sid=129 devtype=DISK

Starting backup at 17-JUN-09
channel x: starting full datafile backupset
channel x: specifying datafile(s) in backupset
input datafile fno=00005 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_53crz7h5_.db
channel x: starting piece 1 at 17-JUN-09
channel x: finished piece 1 at 17-JUN-09
piece handle=/u01/app/oracle/flash_recovery_area/ORCL/backupset/2009_06_17/o1_mf_nnndf_TAG20091349_53k2dywf_.bkp tag=TAG20090617T151349 comment=NONE
channel x: backup set complete, elapsed time: 00:00:07
Finished backup at 17-JUN-09
released channel: x

셋팅값에 영향을 받지 않고 해당 셋팅값을 지정해서 실행 가능.

원래 대로 돌리기.

 RMAN> CONFIGURE DEFAULT DEVICE TYPE clear;

--FRA 청소 하기.   <-- full 난 경우.

 [oracle@orcl backup]$ df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda2              9621880   9017052    116052  99% /
/dev/sda1               101086     12168     83699  13% /boot
none                    301864         0    301864   0% /dev/shm
/dev/sdb1              2063504     49708   1908976   3% /disk2
.host:/              176875616  37252372 139623244  22% /mnt/hgfs

다른곳에 백업

RMAN> backup as compressed backupset format '/disk2/backup/orcl_%d_%s_%p.bus' database;

%d   => sid

%s   => backupset num

%p   => piece

RMAN> show retention policy;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

(delete obsolete시 마지막 한개만 남기고 backupset 과 관련 archive 파일 지우겠다는 뜻)

RMAN> delete obsolete;

해도 제대로 지워 지지 않을 경우

RMAN> crosscheck backupset;

 후 다시 delete obsolete

 일반적 rman 질의

 [oracle@orcl ~]$ vi b.rcv

backup datafile 4;

list backup datafile 4;

[oracle@orcl ~]$ rman target / cmdfile=b.rcv log=a.log append

[oracle@orcl ~]$ rman target / cmdfile=showall.rcv log=c1.log

  차후 누가 설정값을 바꾸었을 경우. diff 명령어를 사용하여서 비교 가능.

[oracle@orcl ~]$ rman target / cmdfile=showall.rcv log=c1.log
RMAN> 2> 3> [oracle@orcl ~]$

      EM 에서 값 변경후

[oracle@orcl ~]$ rman target / cmdfile=showall.rcv log=c2.log
RMAN> 2> 3> [oracle@orcl ~]$
[oracle@orcl ~]$
[oracle@orcl ~]$ diff c1.log c2.log
2c2
< Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 17 16:19:51 2009
---
> Recovery Manager: Release 10.2.0.1.0 - Production on Wed Jun 17 16:24:19 2009
18c18
< CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
---
> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;