About control file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: About control file

  1. #1
    Join Date
    Mar 2001
    Posts
    16
    hi guys
    I issued the command "alter database backup controlfile to trace" and genrated trace file which contains create command
    .could you please tell me all the steps to create the controlfile.
    thanks in advance!!!!!!!!!

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    See the command "alter database backup controlfile to trace" will create a script that u can use in case all ur controlfile gets corrupted or lost.Alternatively u can also backup the controlfile with the command "alter database backup controlfile to '/disk1/data/control.bak"
    "Alter database backup controlfile to trace" will create a trace file containing the syntx to recreate the trace file.U edit the trace file to remove the comments and save the file as .sql file.If all ur controlfile are lost shutdown the database,open the database in nomount stage and run the sql script to recreate the controlfile.
    Recreating the controlfile is basically not advised since u should keep atleast 2 copies of controlfiles mirrored.
    In case of any help please be free to write to me at rohitsn@altavista.com


    Regards,
    Rohit Nirkhe,Oracle DBA,OCP

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