DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001
    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
    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.



  2. #2
    Join Date
    Sep 2001


    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.