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!

control file

Deepak_DBASep 30 2008 — edited Oct 3 2008
hi all,
i'm usin oracle 9i in rhel4.. in my test env.. i have a f1eo database..i was wokin in that .. unfortunately i deleted all my control files.. but the database was workin.. i gave the following command..
alter system switch logfile;
it does not show any err..i shut the database, but when i restart the db next day it shows cntrlfile missing.. luckily the deleted cntrl files was in my recyclebin.. i just restored it and opened the database.. the db was perfect.. what abt th result of the cmd i gave before the db shut.. what happen to the cntrl file.. where the information abt logswitch have been updated...

note - i don't have any multiplixed or controlfile trace.. as it was test Db there was no issue.. but i want to know what happen really..

thnx in advance,
regards,
Deepak...
This post has been answered by jgarry on Sep 30 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2008
Added on Sep 30 2008
12 comments
839 views