Setting RMAN's backup directory
How do you set RMAN's backup directory? The default is $ORACLE_HOME/dbs.
In your allocate command:
ALLOCATE CHANNEL d1 TYPE DISK FORMAT '/u01/oraback/mysid/d1%U';
ALLOCATE CHANNEL d2 TYPE DISK FORMAT '/u02/oraback/mysid/d2%U';
I'm getting an error when I execute the example:
RMAN> allocate channel d1 type disk format '/home/oracle/backup/BANG/d1%U';
RMAN error message stack...
error encountered while parsing input commands
syntax error: found "identifier": expecting one of: "for"
the bad identifier was:d1
at line 1 column 18 file: standard input
Hmm. Works for me on 220.127.116.11 and 18.104.22.168... What version?
I'm digging through the docs. I'll figure it out. Thanks for pointing me in the right direction. I'll keep you posted...
I think you can also do it like:
allocate channel t1 type disk;
Thanks for your help.
RMAN rocks. This was a ton more work the way we were doing it.
allocate channel fs1 type disk format='/home/oracle/backup/BANG/%u.bak';
allocate channel fs2 type disk format='/home/oracle/backup/BANG/%u.bak';
allocate channel fs3 type disk format='/home/oracle/backup/BANG/%u.bak';
allocate channel fs4 type disk format='/home/oracle/backup/BANG/%u.bak';
set limit channel fs1 kbytes=2000000; #limit file size to 2Gb
set limit channel fs2 kbytes=2000000;
set limit channel fs3 kbytes=2000000;
set limit channel fs4 kbytes=2000000;
sql "alter system archive log current";
backup archivelog all delete input;
Click Here to Expand Forum to Full Width