Home » RDBMS Server » Backup & Recovery » Backing up Control File and SPFILE (Oracle 10g on Windows)
Backing up Control File and SPFILE [message #558842] Tue, 26 June 2012 19:41 Go to next message
SpaceBolt
Messages: 12
Registered: October 2011
Junior Member
I've pasted some of the results of an RMAN backup that I ran. It says that it's backing up both the Control File and the SPFILE, but it appears that only one file is being created. Is this correct? How does this work? Are both files combined into the C-3843121877-20120619-00 file?

Starting Control File and SPFILE Autobackup at 19-JUN-12
piece handle=C:\ORACLE\PRODUCT\10.2.0\DATABASE\C-3843121877-20120619-00 comment=NONE
Finished Control File and SPFILE Autobackup at 19-JUN-12


Also, regarding the below configuration of RMAN - I can change this directory to whatever I want, correct? In other words, is it just the directory where I am putting the backup?

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\10.2.0\DATABASE\SNCFPLDG.ORA'; # default


Thanks so much.
Re: Backing up Control File and SPFILE [message #558883 is a reply to message #558842] Wed, 27 June 2012 02:16 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Hello. Have you read any of the Backup and Recovery documentation yet? Here
http://www.oracle.com/pls/db102/portal.portal_db?selected=3
Re: Backing up Control File and SPFILE [message #558926 is a reply to message #558883] Wed, 27 June 2012 07:49 Go to previous message
SpaceBolt
Messages: 12
Registered: October 2011
Junior Member
Yes.
Previous Topic: Backup
Next Topic: how to restore in a new host
Goto Forum:
  


Current Time: Thu Mar 28 05:04:50 CDT 2024