Re: RMAN and two LOG_ARCHIVE_DEST_<n>

On Mon, 2 Dec 2002 05:51:00 +1100, "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote:

>To put it bluntly: RMAN doesn't work in a Parallel Server environment.
>
>Full stop. Period.

Are you sure about that?
If I read the manual you should simply
a) make sure you include the thread identifier in the log_archive_format parameter

and you state this script from the 8.1.7 docs doesn't work

Backing Up in a Parallel Server Environment The following script distributes datafile and archived redo log backups across two nodes in a parallel server environment:

run {

     allocate channel node_1 type disk connect 'sys/sys_pwd_at_node_1'; 
     allocate channel node_2 type disk connect 'sys/sys_pwd_at_node_2'; 
        backup filesperset 1  
          (tablespace system, rbs, data1, data2 
           channel node_1)
          (tablespace temp, reccat, data3, data4 
           channel node_2); 
        backup filesperset 20 
          (archivelog  
           until time 'SYSDATE'  
           like "/node1/arc/%" 
           delete input 
           channel node_1); 
          (archivelog  
           until time 'SYSDATE' 
           like "/node2/arc/%"
           delete input 
           channel node_2); 

also to make multiple copies the OP simply has to read

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rmansy43.htm#48531

to use set duplex 2

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Dec 01 2002 - 15:16:09 CST