TECH
QUESTION

자주하는 질문답변 입니다.

Oracle

게시글 보기
작성자 유건데이타 등록일 2015-05-13
제목 HOT BACKUP SCRIPT EXAMPLE
#############################
# HOT BACKUP SCRIPT EXAMPLE #
#############################

export ORACLE_SID=ORA8
svrmgrl connect internal
set echo on
spool backup.log
rem Starting Hot Backup
!echo 'ORACLE_SID='$ORACLE_SID
!date
archive log list

rem Backup system tablespace
alter tablespace system begin backup;
!date
!cp /mnt3/rctest80/server/ejlee/dbs/system01.dbf
/mnt3/rctest80/server/ejlee/dbs/backup/system01.dbf
alter tablespace system end backup;

rem Backup rbs tablespace
alter tablespace rbs begin backup;
!date
!cp /mnt3/rctest80/server/ejlee/dbs/rbs01.dbf
/mnt3/rctest80/server/ejlee/dbs/backup/rbs01.dbf
alter tablespace rbs end backup;

rem Backup temp tablespace
alter tablespace temp begin backup;
!date
!cp /mnt3/rctest80/server/ejlee/dbs/temp01.dbf
/mnt3/rctest80/server/ejlee/dbs/backup/temp01.dbf
alter tablespace temp end backup;
rem Backup users tablespace
alter tablespace users begin backup;
!date
!cp /mnt3/rctest80/server/ejlee/dbs/users01.dbf
/mnt3/rctest80/server/ejlee/dbs/backup/users01.dbf
alter tablespace users end backup;

rem Backup context tablespace
alter tablespace context begin backup;
!date
!cp /mnt3/rctest80/server/ejlee/dbs/context01.dbf
/mnt3/rctest80/server/ejlee/dbs/backup/context01.dbf
alter tablespace context end backup;

rem Backup archiving file with current redo log
!date
alter system switch logfile;
alter system archive log all;
!date
archive log list
!cp /mnt3/rctest80/server/ejlee/dbs/arch/*.*
/mnt3/rctest80/server/ejlee/dbs/backup/.
archive log list
rem Backup control file
alter database backup controlfile to trace;

rem End Hot Backup
!date
exit
Comment
등록된 코멘트가 없습니다.