| RMAN backup path [message #138046] |
Mon, 19 September 2005 10:25  |
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 #138088 is a reply to message #138046] |
Mon, 19 September 2005 21:31  |
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 #138186 is a reply to message #138046] |
Tue, 20 September 2005 11:41 |
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 |
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 |
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 #139718 is a reply to message #139480] |
Thu, 29 September 2005 05:19 |
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';
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
