Scenarios from coldbackup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Scenarios from coldbackup

  1. #1
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    93
    Hi everybody!

    I had a problem , I would like to make an script to restore my database from a coldbackup (it includes datafiles, redo logs files and control files, and also some important .ora files like parameters file - init.ora - ).

    I have a lot of doubts...

    1) What are the steps in order to make my restore scripts?
    -Only is necesary to copy backup files to their original paths?
    - I would like to know if in some cases (scenarios) is necessary to:
    * shutdown database ( I dont know if is necesary shutdown the database before to restore the backup files ... )
    * mount the instance that I'm trying to restore, without open it. (is this necessary in some cases ? )
    * etc (Are there other aditional steps for spetial cases ?

    2) I would like to know some scenarios where restoring
    from a coldbackup is a good choice

    3) I would like to know some scearios where restoring from a coldbackup will not solve the problem


    This is my aditional info:
    I'm not working in archivelog mode.
    I'm working on oracle 8.0.6.1.0
    I'm working on HP-UX 10

    Thanks, in advance.


  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    First of all, read the documentation because even we tell you here you have to understand the concepts
    Second, if yoy are in NO archive log then there is NO special situations for you, when you have to restore you have to restore all the datafiles, control file. The parameter file is not necessary if it is not lost. Regarding redo log file, you can either restore it or open the database with resetlogs

    When you restore you obviously have to restore them to their original paths, the steps are simple just shutdown the database and restore the files once restored do

    startup mount
    alter database open resetlogs

    [Edited by pando on 09-30-2001 at 04:48 PM]

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    1.) Usualy when you need to restore database from cold backup that means that your database has suffered some kind of media failure (like disk crash or corrupted file), in which case your database will not be running. So there will be no need to shut it down . Restoring from cold backup is easy: you simply restore all the needed files to their original locations and start the database.

    Theoreticaly it is possible that before the restore your database will be in NOMOUNT or MOUNT mode (but certanly not in OPEN mode). In any case, it won't hurt of you simply perform SHUTDOWN ABORT before any cold backup restore.

    2.) If you are running in NOARCHIVELOG, then restoring from cold backup is *the only* recovery option in case of media failure. You have no other choice if you do not to want create a new database.

    3.) If your cold backup is a valid one then you can be 100% certain that you will be able to restore the database from it. But you will definitely lose all the work performed on the database after your last backup.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Oct 2000
    Posts
    467
    A small correction..you need not reset logs if you're restoring all the controlfiles, datafiles and redo logs from a cold backup.


    Cheers
    Vinit

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