Home » RDBMS Server » Backup & Recovery » location of the backups sets using RMAN
location of the backups sets using RMAN [message #194739] Mon, 25 September 2006 01:04 Go to next message
reena_ch30
Messages: 100
Registered: December 2005
Senior Member
Hi,

What is the default location of the backup sets and image copies created using RMAN in 9i?? And how can we change it?? Please respond.

Thanks
Reena
Re: location of the backups sets using RMAN [message #194788 is a reply to message #194739] Mon, 25 September 2006 05:42 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The default backup location is $ORACLE_HOME/dbs. If you want the backups to go to a different location you need to specify the location when you CONFIGURE the channel or ALLOCATE the channel:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backups/orcl/%d_%T_%U.bkp';
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT '/backups/orcl/%d_%T_%U.bkp';

or when you issue the BACKUP/COPY command:

BACKUP DATABASE FORMAT '/backups/orcl/%d_%T_%U.bkp';
COPY DATAFILE 1 TO '/backups/orcl/%d_%T_%U.bkp';





Previous Topic: ORA-01171: datafile # going offline
Next Topic: point in time recovery of a table through rman
Goto Forum:
  


Current Time: Fri Dec 09 15:24:47 CST 2016

Total time taken to generate the page: 0.33163 seconds