-
Can you use a binary backup of controlfile to recover a db without reset logs?
Here is the steps:
alter database backup controlfile to '/export/home/u03/oradata/mnki/bkpctl';
On the OS level, remove the control file.
alter system checkpoint; ==> the db will crash
Now, on the OS level, cp bkpctl control01.ctl.
Then:
SQL> startup mount;
ORACLE instance started.
Total System Global Area 24297632 bytes
Fixed Size 73888 bytes
Variable Size 7266304 bytes
Database Buffers 16777216 bytes
Redo Buffers 180224 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> recover database;
Then the db will keep asking archived log even ALL archived logs have been supplied.
What could went wrong?
-
you have to use recover database using backup controlfile
however I wonder how you can recover still because you should get ora-01207 straoght away, are you sure you have tried this?
-
Yes, I tested. I could not use the binary backup to recover the db. But I could use the backup trace (SQL) to recreate the new control file and then open the db.
-
well in your first post you are saying you used binary copy, that is different ok....
-
Right. I have no problem using the trace file.
My question is "Can you use a binary backup of controlfile to recover a db without reset logs?"
-
My question is "Can you use a binary backup of controlfile to recover a db without reset logs?"
-
Using binary copy, you have to reset the logs.
Reseting the logs is the mechanism oracle uses to synchronize controlfile with datafiles
-
Originally posted by Sharma
Using binary copy, you have to reset the logs.
Is this true? Why?
-
When you use the binary copy backup of controlfile, it will be outofsync with Datafile and redologs.
-
This doesn't necessarily require resetlogs. As long as you have all archived logs, you should be able to synch the database. So, why shuold I resetlogs?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|