rman 백업 전체 내용

영상은 리눅스 내용인데 그래도 생각하면서 보면 딱 맞으니 잘 확인하자.

 

 

-전체백업

# 백업

@echo off

oracle_sid=dev

D:\Oracle\Oracle19C\bin\exp system/admin file=D:\Oracle_Backup\Full_Backup\Dev\dev_PM11%date%.dmp full=y

# 복원 

imp system/Pass@ORCL file=ORCL.dmp log=ORCL.log buffer=4096000 full=y  

 

 

 

- rman 백업

# 백업 (dev_rman_backup.bat)

set oracle_sid=dev

rman target sys/jaieladmin@dev @D:\Oracle_Backup\Incremental_Backup\Dev\dev_rman_backup.sql

 

 

 

# dev_rman_backup.sql

run

{

allocate channel ch1 device type disk format 'D:\Oracle_Backup\Incremental_Backup\DEV\str_%T_full_%U';

allocate channel ch2 device type disk format 'D:\Oracle_Backup\Incremental_Backup\DEV\str_%T_full_%U';

allocate channel ch3 device type disk format 'D:\Oracle_Backup\Incremental_Backup\DEV\str_%T_full_%U';

allocate channel ch4 device type disk format 'D:\Oracle_Backup\Incremental_Backup\DEV\str_%T_full_%U';

crosscheck archivelog all;

delete noprompt archivelog all completed before 'trunc(sysdate) -1';

backup as compressed backupset database tag 'DB_FULL_BACKUP' plus archivelog tag 'ARCHIVELOG';

backup current controlfile tag 'CONTROLFILE' format 'D:\Oracle_Backup\Incremental_Backup\DEV\str_%T_cont_%U';

backup spfile tag 'SPFILE' format 'D:\Oracle_Backup\Incremental_Backup\DEV\str_%T_para_%U';

crosscheck backup;

delete noprompt backup completed before 'trunc(sysdate) -1';

release channel ch1;

release channel ch2;

release channel ch3;

release channel ch4;

}

 

 

--------영상자료-------------------

-Oracle rman 백업

https://www.youtube.com/watch?v=PA9VIjbYd4w&t=335s

 

-Oracle rman 복구

https://www.youtube.com/watch?v=BTd-wVIjZI8

- Oracle rman 테이블 복구
https://www.youtube.com/watch?v=5f8H6c1u3-w