Home » RDBMS Server » Backup & Recovery » RMAN backup path
RMAN backup path [message #138046] Mon, 19 September 2005 10:25 Go to next message
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
Junior Member
When I run RMAN script for backup,
at what location backup is taken ?
I have not specified any path in RMAN script,
I am using recovery catlog
Re: RMAN backup path [message #138049 is a reply to message #138046] Mon, 19 September 2005 10:40 Go to previous messageGo to next message
tarundua
Messages: 1077
Registered: June 2005
Location: India
Senior Member


I think the default location is

$ORACLE_HOME/database folder.

regards,
tarun
Re: RMAN backup path [message #138088 is a reply to message #138046] Mon, 19 September 2005 21:31 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
If you want to override the default path, run cmd below

RMAN> configure channel 1 device type disk format '/data/rman/bakdata/std_%U';
RMAN> configure channel 2 device type disk format '/data/rman/bakdata/std_%U';
Re: RMAN backup path [message #138112 is a reply to message #138088] Tue, 20 September 2005 03:19 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Below are the three link.... you can check them out and read it properly to know how backup is taken from RMAN .

http://www.orafaq.com/forum/t/51450/67993/

http://www.orafaq.com/forum/t/51126/67993/

http://www.orafaq.com/forum/t/51455/67993/

Regards
Always Friend Sunil
Re: RMAN backup path [message #138186 is a reply to message #138046] Tue, 20 September 2005 11:41 Go to previous messageGo to next message
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
Junior Member
Thanks sunil for providing useful links,

I got the answer, but still one question

does RMAN store backup path in any editable file
or database table?



Re: RMAN backup path [message #138251 is a reply to message #138186] Tue, 20 September 2005 23:52 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Important tables related to recovery catalog

1. RC_DATABASE
2. RC_DATAFILE
3. RC_REDO_LOG
4. RC_REDO_THREAD
5. RC_ARCHIVE_LOG
6. RC_CONTROLFILE_SOPY
7. RC_STORED_SCRIPT
8. RC_STORED_SCRIPT_LINE

Pls check out all this & i hope you will get your answer.

Always Friend sunil

Re: RMAN backup path [message #138788 is a reply to message #138251] Fri, 23 September 2005 11:59 Go to previous messageGo to next message
oracle_techie
Messages: 24
Registered: July 2005
Location: Munbai
Junior Member
Dear alexzeng & sunil,
I congigure the channnel to new path, But after the backup script is run I found that Backup files are created at its
old default location i.e. $ORACLE_HOME/database folder
Why it is like this? How to change the default path?

FOLLOWING IS THE OUTPUT OF THE COMMANDS I RUN:

RMAN> configure channel 1 device type disk format 'F:\database_bkp\std_%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'F:\database_bkp\std_%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> configure channel 2 device type disk format 'F:\database_bkp\std_%U';

new RMAN configuration parameters:
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT 'F:\database_bkp\std_%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> Run
2> {allocate channel ch1 type disk;
3> backup tablespace users
4> include current controlfile;}

allocated channel: ch1
channel ch1: sid=15 devtype=DISK

Starting backup at 23-SEP-05
channel ch1: starting full datafile backupset
channel ch1: specifying datafile(s) in backupset
input datafile fno=00009 name=C:\ORACLE\ORADATA\ZEN1\USERS01.DBF
including current controlfile in backupset
channel ch1: starting piece 1 at 23-SEP-05
channel ch1: finished piece 1 at 23-SEP-05
piece handle=C:\ORACLE\ORA92\DATABASE\0BGVBKJ9_1_1 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:02
Finished backup at 23-SEP-05

Starting Control File and SPFILE Autobackup at 23-SEP-05
piece handle=C:\ORACLE\ORA92\DATABASE\C-3326349592-20050923-02 comment=NONE
Finished Control File and SPFILE Autobackup at 23-SEP-05
released channel: ch1
Re: RMAN backup path [message #139480 is a reply to message #138788] Wed, 28 September 2005 04:19 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi ,

The link that i had send you earlier had answer to your question .... Smile

Please check out properly ... & tell us where you were doing mistake as your backup was created on same machine where the database is present

Regards
Always Friend Sunilkumar.
Re: RMAN backup path [message #139718 is a reply to message #139480] Thu, 29 September 2005 05:19 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Check the channel name in the command.
You are specifying this in your backup script:

2> {allocate channel ch1 type disk;


while you are configuring channel as this:

RMAN> configure channel 1 device type disk format 'F:\database_bkp\std_%U';
Re: RMAN backup path [message #607554 is a reply to message #139718] Sun, 09 February 2014 11:41 Go to previous messageGo to next message
malakaamir
Messages: 1
Registered: September 2013
Location: Dubai
Junior Member

Hey,

if you are not specifying format in RMAN run block then default location will be Flash_recovery_Area/databasename

Regards,
Aamir
Re: RMAN backup path [message #607555 is a reply to message #607554] Sun, 09 February 2014 11:46 Go to previous message
BlackSwan
Messages: 22506
Registered: January 2009
Senior Member
Welcome to this forum.

Thanks for trying to contribute, but do you think the OP has been waiting for 8.5 YEARS for your Pearls of Wisdom?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sun, 09 February 2014 11:46]

Report message to a moderator

Previous Topic: expdp impdp vs RMAN backup restore
Next Topic: RESETLOG (alter database open)
Goto Forum:
  


Current Time: Sat Jul 26 02:09:07 CDT 2014

Total time taken to generate the page: 0.13996 seconds