OraFAQ Forum: Backup & Recovery » location of the backups sets using RMAN

Home » RDBMS Server » Backup & Recovery » location of the backups sets using RMAN

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

location of the backups sets using RMAN [message #194739]

Mon, 25 September 2006 01:04

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

Report message to a moderator

Re: location of the backups sets using RMAN [message #194788 is a reply to message #194739]

Mon, 25 September 2006 05:42

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';

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 30 07:54:24 CDT 2024