DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Hot Backup

  1. #1
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94

    Hot Backup

    Hi all,
    I am doing a script to do hot backups (archive mode) every week for my database.
    I am not sure about doing things in the right steps. The steps to do things are:

    1. Switch logfiles
    2. Backup Datafiles
    3. Backup control files
    4. archive current log
    5 switch logfile

    Do I need to backup redo logs and where?
    Am I missing something

    Regrds Hamhey

  2. #2
    Join Date
    May 2001
    Posts
    736
    Why don't u use RMAN to accomplish all the tasks or u can use RMAN to execute your script.Which redo logs?.If they are archived redo logs then u need to back them from their destination directory to tape and also on the hard disk at one location for purpose of fast recovery.

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: Hot Backup

    Originally posted by hamhey
    Hi all,
    I am doing a script to do hot backups (archive mode) every week for my database.
    I am not sure about doing things in the right steps. The steps to do things are:

    1. Switch logfiles
    2. Backup Datafiles
    3. Backup control files
    4. archive current log
    5 switch logfile

    Do I need to backup redo logs and where?
    Am I missing something

    Regrds Hamhey
    If you are on version 8 or higher use RMAN.
    You can find some scripts (OS as well as RMAN) on this site.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Feb 2003
    Location
    Tehran/Iran
    Posts
    94
    what can I say. You're right.
    I've done almost the hole script and and just wondering right procedure doing hot backup by script.

    Thanks anyway

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by hamhey
    what can I say. You're right.
    I've done almost the hole script and and just wondering right procedure doing hot backup by script.

    Thanks anyway
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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