Home » RDBMS Server » Backup & Recovery » Confusion about restoring controlfile without backup
Confusion about restoring controlfile without backup [message #477948] Tue, 05 October 2010 06:08 Go to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Hi,
After creating a controlfile manually without any backup how the database goes to a consistent state? Because the newly created controlfile does not have the scn details as well as checkpoint information that the deleted controlfile had.
Also after restoring the controlfile is it needed to open the database in resetlogs mode? If not why?

Please help me to clear these confusions.
Re: Confusion about restoring controlfile without backup [message #477950 is a reply to message #477948] Tue, 05 October 2010 06:15 Go to previous messageGo to next message
Michel Cadot
Messages: 58833
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you just try it and see what happens.
In my opinion, control file synchronisation is done at open (resetlogs).

Regards
Michel
Re: Confusion about restoring controlfile without backup [message #477958 is a reply to message #477950] Tue, 05 October 2010 06:37 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Thanks Michel. I have tried and seen that if you manually create the controlfile using the create controlfile script and then take the database in mount as well as open state subsequently you do not have to open it in resetlogs mode. That is why I am confused as to how the controlfile gets the information about the current thread checkpoints and archive log scn's.
Re: Confusion about restoring controlfile without backup [message #477980 is a reply to message #477958] Tue, 05 October 2010 08:37 Go to previous messageGo to next message
Michel Cadot
Messages: 58833
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
That is why I am confused as to how the controlfile gets the information about the current thread checkpoints and archive log scn's.

Checkpoint is taken from file headers.
SCN is taken from the last point you recover.

Regards
Michel
Re: Confusion about restoring controlfile without backup [message #477984 is a reply to message #477980] Tue, 05 October 2010 08:51 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
That means scn's are taken from the online redo log file right?
Re: Confusion about restoring controlfile without backup [message #477988 is a reply to message #477984] Tue, 05 October 2010 09:04 Go to previous messageGo to next message
Michel Cadot
Messages: 58833
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Re: Confusion about restoring controlfile without backup [message #477990 is a reply to message #477988] Tue, 05 October 2010 09:16 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
Thanks Michel.
Re: Confusion about restoring controlfile without backup [message #477998 is a reply to message #477958] Tue, 05 October 2010 10:18 Go to previous messageGo to next message
John Watson
Messages: 4474
Registered: January 2010
Location: Global Village
Senior Member
indrajit2002 wrote on Tue, 05 October 2010 06:37
I have tried and seen that if you manually create the controlfile using the create controlfile script and then take the database in mount as well as open state subsequently you do not have to open it in resetlogs mode.

Not true! I did think that following a controlfile restore or create, a resetlogs is always required - I tested it, and it is.
(I'm sure you weren't trying to deceive, but I always like to be precise)
Re: Confusion about restoring controlfile without backup [message #478105 is a reply to message #477948] Wed, 06 October 2010 05:20 Go to previous messageGo to next message
indrajit2002
Messages: 53
Registered: November 2007
Location: INDIA
Member
No I am not trying to deceive. Just try the other way out. Delete all the controlfiles from your test database and create it manually using the 'Create Controlfile script' then issue alter database open. tell me what you get.
Re: Confusion about restoring controlfile without backup [message #478117 is a reply to message #478105] Wed, 06 October 2010 07:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58833
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you post (copy and paste) the test you made? Then we can all see what you do and get.

Regards
Michel
Re: Confusion about restoring controlfile without backup [message #478118 is a reply to message #478117] Wed, 06 October 2010 07:13 Go to previous message
John Watson
Messages: 4474
Registered: January 2010
Location: Global Village
Senior Member
Just done it again, and I see that there is a dependency on the SET keyword of the CREATE DATABASE command. If I omit it, then the NORESETLOGS keyword comes into effect. Thanks, I didn't know that.
Previous Topic: Undo tablespace in hotbackup
Next Topic: About Reconnecting Oracle DB on New Machine
Goto Forum:
  


Current Time: Wed Aug 20 01:50:55 CDT 2014

Total time taken to generate the page: 0.13899 seconds