hot backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: hot backup

  1. #1
    Join Date
    Feb 2001
    Posts
    53

    Cool

    Hello all,

    Does anyone here have a step-by-step process for doing a hot backup for Oracle8i on Unix?

    I saw it somewhere on line once, but because of my crapping internet connection, I lost the link before I was able to print out the doc.

    appreciated,

    keep on truckin

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    So many threads available on this forum. Search for Hot Backup
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I can outline the procedure, If you want including the syntax etc., I have to do that tomorrow from my desk:

    1) bkup_begin.sql ( main script calls 2 script)

    Setup the environment, meaning ORACLE_SID and ORACLE_HOME and call cr_tslistbegin.sql

    2)cr_tslistbegin.sql (calls 3 script)

    Use SQL to build SQL commnd 'ALTER tablespace xyz BEGIN BACKUP' from DBA_TABLESPACES view and spool it to tslistbegin.sql

    3)tslistbegin.sql (Which contains striped out ALTER TABLESPACE Bacup BEGIN commands)

    3a)tslistend.sql (Which contains striped out ALTER TABLESPACE Backup END commands)

    2a)cr_tslistend.sql (calls 3a script)

    Use SQL to build SQL commnad 'ALTER tablespace xyz END BACKUP ONLINE' using DBA_TABLESPACES view and spool it to tslistend.sql

    1a)bkup_end.sql ( main end script calls 2a script)

    Setup the environment, meaning ORACLE_SID and ORACLE_HOME and call cr_tslistend.sql

    In simple terms:
    1:Set environment
    2,3: tablespace for backup and back it up
    2a,3a:END backup.

    Finally dump controlfile to trace using:
    ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

    I know the syntax what I typed in z wrong. Check for syntax.

    Thanks for correcting me.




    [Edited by sreddy on 02-07-2001 at 03:35 PM]

  4. #4
    Join Date
    Feb 2001
    Posts
    53

    Wink

    sreddy,

    that woud be great. Its exactly what I need, a procedure.

    I'll check back later on tonight.


    thanks

  5. #5
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    The above procedure for hot backup is fine except onething. The tablespaces need not be taken offline to take a hot backup.

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Why not try looking into that of using RMAN, that would avoid the necessity of taking the table space offline. It would also be easier at the time of recovery.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width