Cold Backup Restore & Recovery when DB Crashes!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Cold Backup Restore & Recovery when DB Crashes!

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    I have this query:

    WE are into Development stage and working on Oracle v8i with NT as OS.

    1.I take cold backups of the following DB Files by shutting down the DB:
    a).Control01.ctl,Control02.ctl,Control03.ctl Files
    b).Users01.dbf
    c).Temp01.dbf
    d).Indx01.dbf
    e).Tools01.dbf
    f).Parameter File INIT.ORA.
    g).Password File.

    The above DB files are on d:\> drive.
    Cold Backups I store on E:> drive.

    In case the DB crashes,do I have to put the Db in ArchiveLog Mode
    and recover upto a certain point in time.
    As when the Db is shutdown to take cold backups,Db goes into the default NoArchivelog Mode.

    Is it OK!

    2.How could I make my Application Developers make use and run TKPROF,AUTOTRACE utility from their client machines to tune their sql queries.

    Thanks&Regards,

    Amit.

  2. #2
    Join Date
    Sep 2001
    Posts
    120

    backup

    please do a back up a trace file which will help you in creating new control files in case of db crash.

    if db crashes you only have to give the parameter file.

    startup nomount pfile='where you saved the pfile'
    then create the new control file(if you have change the destination ie c:\ to d:\

    then make the system in archive log but be sure you have entries in init.ora file uncomented.
    Saurabh Garg
    OCP 9i

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