| |
A. noarchive mod 백업
1. OFFBACKUP 디렉토리 생성
2. parameter 파일 백업
3. password 파일 백업
4. oradata 디렉토리 all 백업
5. network 디렉토리 all 백업
B. database archived mod로 전환
1. 정상 종료 (shutdown immediate)
2. parameter file 첨가
log_archive_start = true
log_archive_dest_1 = "location=/opt/oracle/arch/log MANDATORY"
log_archive_dest_2 = "location=/opt/oracle/arch/log2 OPTIONAL"
log_archive_dest_3 = "location=/opt/oracle/arch/log3 OPTIONAL"
log_archive_format = "%s.ARC"
log_archive_min_succeed_dest=2
3. 디렉토리 생성(ARCH , ONBACKUP)
4. startup mount
alter database archivelog;
alter database open;
4. 백업
1) datafile들 online백업(system,undotbs,indx,temp,nanune01,nestar01,
nanunetemp,nestartemp)
alter tablespace system begin backup;
! cp $HOME/oradata/ORA9/system01.dbf $HOME/ONBACKUP/
alter tablespace system end backup;
alter system switch logfile;
alter tablespace users begin backup;
!cp $HOME/oradata/ORA9/users01.dbf $HOME/ONBACKUP/
alter tablespace users end backup;
alter system switch logfile;
alter tablespace undotbs1 begin backup;
!cp $HOME/oradata/ORA9/undotbs01.dbf $HOME/ONBACKUP/
alter tablespace undotbs1 end backup;
alter system switch logfile;
alter tablespace nanune01 begin backup;
!cp $HOME/oradata/ORA9/nanune01.dbs $HOME/ONBACKUP/
alter tablespace nanune01 end backup;
alter system switch logfile;
alter tablespace nestar01 begin backup;
!cp $HOME/oradata/ORA9/nestar01.dbf $HOME/ONBACKUP/
alter tablespace nestar01 end backup;
alter system switch logfile;
alter tablespace drsys begin backup;
!cp $HOME/oradata/ORA9/drsys01.dbf $HOME/ONBACKUP/
alter tablespace drsys end backup;
alter system switch logfile;
alter tablespace tools begin backup;
!cp $HOME/oradata/ORA9/tools01.dbf $HOME/ONBACKUP/
alter tablespace tools end backup;
alter system switch logfile;
alter tablespace xdb begin backup;
!cp $HOME/oradata/ORA9/xdb01.dbf $HOME/ONBACKUP/
alter tablespace xdb end backup;
alter system switch logfile;
alter tablespace indx begin backup;
!cp $HOME/oradata/ORA9/indx01.dbf $HOME/ONBACKUP/
alter tablespace indx end backup;
alter system switch logfile;
!cp $HOME/oradata/ORA9/temp01.dbf $HOME/ONBACKUP/
!cp $HOME/oradata/ORA9/nanunetemp.dbs $HOME/ONBACKUP/
!cp $HOME/oradata/ORA9/nestartemp.dbs $HOME/ONBACKUP/
alter database backup controlfile to '$HOME/ONBACKUP/controlfile.bak' reuse;
2) controlfile trace text 백업
alter database backup controlfile to trace;
3) network 백업
5. parameter file(initSID.ora), password파일도 백업
|