Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Backup and Recovery Issue

789902Aug 6 2010 — edited Aug 13 2010
Hi all,


I created a scenario like, when database is up and running i moved all the controlfiles to some other location. But still database is running smoothly. Then i create a table and inserted some values and commit. Now the question is what happens to scn status even when controlfile is not available??? What is the significance of the control file??? log switch and checkpoint is happening but where this is being updated???? Also, when i moved control files back to the database it's working fine ireespective of all the system changes not updated in these controlfiles!!!!


Reply appreciated a lot, thanks in advance.



Regards,

KT
This post has been answered by Shivananda Rao on Aug 12 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2010
Added on Aug 6 2010
16 comments
2,017 views