OraFAQ Forum: Backup & Recovery » difference between backup control file and backing up using controlfile?

Home » RDBMS Server » Backup & Recovery » difference between backup control file and backing up using controlfile? (oracle 11.2.0.2, sun solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

difference between backup control file and backing up using controlfile? [message #599758]

Mon, 28 October 2013 12:24

lg123
Messages: 225
Registered: August 2008

Senior Member

In RMAN, is backing up the controlfile different than backing up the data using controlfile instead of using catalog database? If it does, how are they both different? what are the steps for both?

Report message to a moderator

Re: difference between backup control file and backing up using controlfile? [message #599759 is a reply to message #599758]

Mon, 28 October 2013 12:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails Read The Fine Manual YOURSELF!

http://docs.oracle.com/cd/E16655_01/backup.121/e17630/toc.htm
http://docs.oracle.com/cd/E16655_01/backup.121/e17631/toc.htm

Report message to a moderator

Re: difference between backup control file and backing up using controlfile? [message #599773 is a reply to message #599759]

Mon, 28 October 2013 16:02

Saurabhchaudhary
Messages: 3
Registered: October 2013
Location: India

Junior Member

Backup control file means your control file has been backed up. You can see a separate control file in your backup directory. Control file backup will be taken in a different file it will not be a part of the backup pieces.

Backup using control file means your control file is the repository of the backup. All the backup related information is in control file only not in catalog database.

Saurabh

Report message to a moderator

Re: difference between backup control file and backing up using controlfile? [message #600115 is a reply to message #599758]

Thu, 31 October 2013 21:45

hkchital
Messages: 128
Registered: September 2008
Location: Singapore

Senior Member

>using controlfile instead of using catalog database
Does not apply. All RMAN backups do update the control file. If you have a catalog database (schema) it is *in addition to* the control file.

You should always ensure that you take backups of the controlfile -- either with AUTOBACKUP ON or with the BACKUP CURRENT CONTROLFILE command.

Hemant K Chitale

Report message to a moderator

Previous Topic:	Backup using VSS writer 11.2.0.2.0 fails
Next Topic:	RMAN restore off autobackup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 12:07:56 CST 2025