-
quick RMAN question
Hi all;
If I already set the parameter for the instance I want to backup as follow:
RMAN> configure channel device type disk format 'Z:\RMANTEST\%d_DB_%u_%s_%p';
question: how can I undo that parameter, the reason is I want to split the backup to 3,4 different channel.
thanks
-
Originally Posted by hannah00
Hi all;
If I already set the parameter for the instance I want to backup as follow:
RMAN> configure channel device type disk format 'Z:\RMANTEST\%d_DB_%u_%s_%p';
question: how can I undo that parameter, the reason is I want to split the backup to 3,4 different channel.
thanks
You have to use more than one channel.
Code:
allocate channel c1 type disk format 'Z:\oraback\';
allocate channel c2 type disk format 'Y:\oraback\';
allocate channel c3 type disk format 'X:\oraback\';
backup database;
release channel c1;
release channel c2;
release channel c3;
Jeff Hunter
-
thanks Jeff as usual.
when I did what you recommended, I got the below error:
RMAN> allocate channel c1 type disk format 'z:\rmantest';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "for"
RMAN-01008: the bad identifier was: c1
RMAN-01007: at line 1 column 18 file: standard input
RMAN>
-
The exact syntax would be
allocate channel c1 type disk format 'Z:\oraback\%d_DB_%u_%s_%p';
Jeff Hunter
-
Jeff,
could you please tell me what happened here ????
Code:
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'C:\BACKUP\BACKUP_%U';
old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'C:\RMANTEST\BACKUP_%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT 'C:\BACKUP\BACKUP_%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
released channel: ORA_DISK_1
RMAN> run {
2> backup database plus archivelog;
3> delete noprompt obsolete;
4> }
Starting backup at 21-JUL-05
current log archived
configuration for DISK channel 2 is ignored
configuration for DISK channel 3 is ignored
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=331 recid=1 stamp=564232485
input archive log thread=1 sequence=332 recid=2 stamp=564232486
input archive log thread=1 sequence=333 recid=3 stamp=564232487
input archive log thread=1 sequence=334 recid=4 stamp=564232489
input archive log thread=1 sequence=335 recid=5 stamp=564232567
input archive log thread=1 sequence=336 recid=6 stamp=564232643
input archive log thread=1 sequence=337 recid=7 stamp=564232723
input archive log thread=1 sequence=338 recid=8 stamp=564233762
input archive log thread=1 sequence=339 recid=9 stamp=564233762
input archive log thread=1 sequence=340 recid=10 stamp=564233768
input archive log thread=1 sequence=341 recid=11 stamp=564233768
input archive log thread=1 sequence=342 recid=12 stamp=564233774
input archive log thread=1 sequence=343 recid=13 stamp=564235162
input archive log thread=1 sequence=344 recid=14 stamp=564238641
input archive log thread=1 sequence=345 recid=15 stamp=564239093
input archive log thread=1 sequence=346 recid=16 stamp=564239187
input archive log thread=1 sequence=347 recid=17 stamp=564239268
input archive log thread=1 sequence=348 recid=18 stamp=564239361
input archive log thread=1 sequence=349 recid=19 stamp=564239412
input archive log thread=1 sequence=350 recid=20 stamp=564239604
channel ORA_DISK_1: starting piece 1 at 21-JUL-05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/21/2005 13:13:28
ORA-19504: failed to create file "C:\BACKUP\BACKUP_0dgq377l_1_1"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
RMAN>
there is a folder backup under c drive
-
jEFF,
I got it. the backup location has to be local as the database server.
the next question is "HOW CAN WE BACKUP THE DATABASE TO SOME OTHER SERVER ON THE NETWORK (WE DON'T HAVE ANY STORAGE SYSTEM AT THE MOMMENT).
-
Originally Posted by hannah00
the next question is "HOW CAN WE BACKUP THE DATABASE TO SOME OTHER SERVER ON THE NETWORK (WE DON'T HAVE ANY STORAGE SYSTEM AT THE MOMMENT).
hmm, dunno. I don't do windoz. I know with NFS this works like a charm because I backup about 2TB every night with it.
Jeff Hunter
-
1)You can undo the parameter in the following 2 ways
a)Use the following command to configure the RMAN parameters
RMAN>configure channel device type disk;
Dont give the format and the destination.
b)In the RMAN script, forcibly use the following command to overwrite the RMAN configuration done.
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup database format 'Z:\RMANTEST\%d_DB_%u_%s_%p';
.
.
.
}
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|