Home » RDBMS Server » Backup & Recovery » How to change the default location of an RMAN backup in 10g (10g on Server 2003)
How to change the default location of an RMAN backup in 10g [message #610391] Wed, 19 March 2014 13:26 Go to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
Hello All -- I'm looking to create a manual RMAN backup of our 10g database, but have the backup save to a different location(?) than what the default is.

Scenario: Oracle 10g on a Windows 2003 R2 Server - Oracle is installed on the C:\.

I'm looking to create a backup of the 10g db by using the command "RMAN>backup archivelog all delete input;" but I want to redirect the backup to a directory on D:\ or even the root of D:\. I will then backup the results to tape. We finally got our db stable and I want to start backing up the db soon. I want to have a full backup of C:\ as well as the RMAN backup on D:\. Any information would be greatly appreciated.

I have little experience with Oracle and I'm learning as I go so please bear with me.
Re: How to change the default location of an RMAN backup in 10g [message #610397 is a reply to message #610391] Wed, 19 March 2014 13:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Have a look at "CONFIGURE CHANNEL DEVICE TYPE disk FORMAT 'D:\...\bkup_%U';" statement.

Re: How to change the default location of an RMAN backup in 10g [message #610399 is a reply to message #610397] Wed, 19 March 2014 14:09 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
Thanks for the reply -- I'm assuming that after I use the above statement that will alter the RMAN configuration? If I do a "RMAN>show all;" the new configuration will reflect the location that I've designated? Will the new configuration hold until I designate a new location?
Re: How to change the default location of an RMAN backup in 10g [message #610400 is a reply to message #610399] Wed, 19 March 2014 14:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes this is the purpose of CONFIGURE statement.
If you want to do it for just one time you can use the FORMAT clause on the ALLOCATE CHANNEL statement.

Re: How to change the default location of an RMAN backup in 10g [message #610401 is a reply to message #610400] Wed, 19 March 2014 14:33 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
Thanks for the help and your patience -- I'll try this out tomorrow and let you know how I fair.
Re: How to change the default location of an RMAN backup in 10g [message #610482 is a reply to message #610401] Thu, 20 March 2014 09:39 Go to previous messageGo to next message
papertiger
Messages: 22
Registered: March 2014
Location: MD
Junior Member
Backups seem to be running good -- we will test next week on a recovery. Thank you for your help
Re: How to change the default location of an RMAN backup in 10g [message #610489 is a reply to message #610482] Thu, 20 March 2014 11:21 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Thanks for the feedback, it is appreciated.

Previous Topic: Restore from RMAN full backup
Next Topic: Strange problem about incremental level 1 cumulative backup
Goto Forum:
  


Current Time: Thu Mar 28 08:34:10 CDT 2024