DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archivelog

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Tell me one thing that when v run ur DB in archivelogmode.
    when ever a archivelog is generated. where it updates. In the control file kya.

    And in this case suppose v lose the controlfile also then how can v recover our DB. I think v h to recreate the controlfile?

    If I want to copy latest controlfile and archivelog file and with this I want to recover another database. can I do this. (o other database i hv already kept online backedup files)
    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well is suppose that you mirror your control files

    if you lose all control file then you recreate the contorl file and do

    recover database until cancel using backup controlfile

  3. #3
    Join Date
    Sep 2001
    Posts
    10
    If you don't have a backup control file (you really should mirror them) you can create a controlfile.

    In svrmgr, alter database backup controlfile to trace; will create a text file with SQL in it needed to generate a new control file.

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