반응형
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
반응형
'Database > Oracle' 카테고리의 다른 글
[ORACLE] RMAN 명령어 (0) | 2022.06.13 |
---|---|
[ORACLE] Full Online backup & Recovery (0) | 2022.06.09 |
[ORACLE] SCN (0) | 2022.06.03 |
[ORACLE] Control file Bakcup&Recovery (0) | 2022.06.03 |
[ORACLE] Schduer job 명령어 (0) | 2022.04.28 |