online backup / offline backup (¾÷¹«)
ÀÛ¼ºÀÚ °ü¸®ÀÚ ÀÛ¼º½Ã°£ 2003-06-12 17:41:50
 

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


¸ñ·Ï | ÀÔ·Â | ¼öÁ¤ | ´äº¯ | »èÁ¦