Setting RMAN's backup directory

[KenEwald]

How do you set RMAN's backup directory? The default is $ORACLE_HOME/dbs.

[marist89]

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

[KenEwald]

Thank you!

[KenEwald]

Jeff,

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

[marist89]

Hmm. Works for me on 8.1.7.4 and 9.2.0.2... What version?

[KenEwald]

9.2.0.4

I'm digging through the docs. I'll figure it out. Thanks for pointing me in the right direction. I'll keep you posted...

[marist89]

http://download-west.oracle.com/docs...rma.htm#439428

http://download-west.oracle.com/docs...nsyn2.htm#8514

I think you can also do it like:

run { 
     allocate channel t1 type disk;
     backup 
       filesperset=20 
       format='d%U' 
       database;
}

[KenEwald]

Thanks for your help.

RMAN rocks. This was a ton more work the way we were doing it.

run {
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;

backup database;

sql "alter system archive log current";

backup archivelog all delete input;

}
===========================================