-
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)
-
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
-
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.