How to Backup and restore oracle DB?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to Backup and restore oracle DB?

  1. #1
    Join Date
    Oct 2001
    Posts
    2
    I'm a newbie, how can i backup my database? and how to restore it?

    Thank you in advance

  2. #2
    Join Date
    Oct 2001
    Location
    Toronto, Canada
    Posts
    236
    Wow!

    It is a huge question.

    Is it for home use or production?

    If it is for home use, than shutdown database and backup all the data files, control files, parameter file and password file if you have one.

    It looks like all.

    But backup of Oracle is a huge topic...

    Leo

  3. #3
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hi,

    Could you be more specific, regarding your environment..?

    that is :
    OS details, Database details, Archive Mode or Not ?
    Is it Production ?
    Is it OLTP ?

    So that we can proceed further accordingly...

    Regards
    Anandharaj
    a_anandharaj@yahoo.com

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Hi,

    As Leo has stated, backup and recovery is a huge subject. The backup/recovery strategy you employ is based on your environment and resources.

    The following link is a good starting point in understanding B&R concepts and administration. If after reading this manual, you are still unclear, you may need to book a course to truly understand Oracle SCN's and how they work in backup and recovery and how to recover from all the different types of failure you may come across, based on the affected files and the type of backup you employ.

    http://otn.oracle.com/docs/products/...a76993/toc.htm

    Feel free to ask questions relating to specific areas of B&R on this forum. You can also use the search engine to find other threads related to B&R at this site.

    Suresh


    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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