Home » RDBMS Server » Backup & Recovery » Difference between main control file and backup controlfile
Difference between main control file and backup controlfile [message #260291] Sat, 18 August 2007 02:42 Go to next message
naveenmelbourne
Messages: 15
Registered: August 2007
Junior Member
Hi Friends,
I am quite new to this forum. Please let me know the difference between the main controlfile and the backup control file. Does it vary in the contents it have. Like extra information about checkpoint and SCN. I would like to know most clear explation about this

Thank you in advance.

Naveen

Report message to a moderator

Re: Difference between main control file and backup controlfile [message #260300 is a reply to message #260291] Sat, 18 August 2007 04:05 Go to previous message
Michel Cadot
Messages: 68756
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This is that.
In backup control file there is no data about scn.
Many other things are zeroed.
You can make an experience: take a backup control file and make a diff between the 2 files.

Regards
Michel

Report message to a moderator

Previous Topic: IN HOW MANY SCENARIOS DOES WE GET SNAPSHOT ERROR
Next Topic: Backup and recovery scenario
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 14 19:08:48 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.