[ORACLE] Online backup Script example

 

1. Online backup Shell Script 예시

#! /usr/bin/sh
SID=oracle12
ORACLE_USER=oracle
ORACLE_HOME=/app/oracle/product/12/db

sqlplus / as sysdba << EOF 
                !echo "\n\t####### Switching Log File : `date | cut -c5-19`  #######\n"
                alter system switch logfile;
                !echo "\n\t####### Make DATABASE Begin Backup Script : `date | cut -c5-19`  #######\n"
		alter database begin backup;

		!cp /home/oracle/oradata/oracle12/system01.dbf /home/oracle/online_backup/
                !cp /home/oracle/oradata/oracle12/sysaux01.dbf /home/oracle/online_backup/
                !cp /home/oracle/oradata/oracle12/example01.dbf /home/oracle/online_backup/
                !cp /home/oracle/oradata/oracle12/users01.dbf /home/oracle/online_backup/
		!cp /home/oracle/oradata/oracle12/users01.dbf /home/oracle/online_backup/
		!cp /home/oracle/oradata/oracle12/TBS_IMSI01.dbf /home/oracle/online_backup/

                alter database end backup;
                alter system switch logfile;

		select * from dual;
			
		!echo "\n\t####### Controlfile  Backup Script : `date | cut -c5-19`  #######\n"  
		alter database backup controlfile to trace as '/home/oracle/online_backup/${SID}_`date +'%m%d%H%M'`.trc' reuse;
                alter database backup controlfile to '/home/oracle/online_backup/${SID}_`date +'%m%d%H%M'`.ctl' reuse;

				
             exit; 
EOF