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

Thread: Backup steps

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Hi,
    I am trying to take the hot backup of the oracle 8.0.5 . All the documentary reference gives a very laborous steps in doing so(They give a batch program to do so).
    Before making a batch program, I would like to execute each steps manually(For the understanding purpose)

    Would someone help me in taking a step by step -hot backup. This is my
    init parameters
    DB name : oracle
    Directory : d:\orant\database
    Archiver log : Enabled and Archiving is in progres.

    Badrinath

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Copy Init.ora file.
    SVMRGL> Alter system switch logfile
    SVMGRL> alter database backup controlfile to trace;
    SVRGRL> alter tablespace tablespace name begin backup
    copy all the files of that TABLESPACE to disk by OS command.
    SVRMGRL> Alter tablespace end backup
    Repeat the steps until you complete all Tablespaces
    SVRMGRL> alter system switch logfile
    Copy the all log files and copy all Archive Logfiles generated from Begning the backup to Ending the backup

    I hope it is clear now.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    Thanks Kishore for giving the steps in taking the hot backup.
    However, How do I know the number of arch files and the redolog files created while the db was in backup mode.

    So which are the logfiles and redolog files I have to copy?
    Thanks

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Redo logfiles are not created separately at backup mode. And Archive logs are the once which gets created. So note down the time when the backup is started and when it is stoped. And copy those Archive Logfiles to the backup directory. Ingenral you need to copy only ONE ARCHIVE LOG FILE. But it depends if there is any transaction in between which is big enough to fill up the Logfile then only the Archive will be created. At time it could be more than one.
    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    before the start of backup issue "archive log list" command in svrmgr. This will give you the current log number. At the end of the backup issue this command again to get the log number.

    You have to backup all these logs in order to do a successful recovery.

    Baliga

  6. #6
    Join Date
    Nov 2000
    Posts
    29
    Could you answer can i make this procedure to do hot backup on another server?

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