|
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ÆÄÀϵµ ¹é¾÷
|