Re: RMAN and two LOG_ARCHIVE_DEST_<n>

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:6gukuukp0e51iujgbq5dal73m3hl65sqqm_at_4ax.com...
> 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?

Yup. Maybe I should have aded the proviso "properly".

> If I read the manual you should simply
> a) make sure you include the thread identifier in the
> log_archive_format parameter
>

Not entirely sure what that's got to do with RMAN working or not working, but yes, you should do this.

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

OK, so you have to establish two connections, one to each node. Now do an RMAN backup of a 32-node cluster....

> backup filesperset 1
> (tablespace system, rbs, data1, data2
> channel node_1)
> (tablespace temp, reccat, data3, data4
> channel node_2);

So you have to manually divvy up the database amongst the available connections....

> 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);
> }
>

Ditto. For a two-node cluster, it's certainly do-able. But you can't simply say 'backup database'. With 9i RMAN, you can. No explicitly specified per-instance connections required.

Oh... and it's not 100% reliable.

Apart from that, yup... I guess it works. Sort of.

Regards
HJR
> also to make multiple copies the OP simply has to read
>
>

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/rman sy43.htm#48531
>
> to use set duplex 2
>
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Mon Dec 02 2002 - 01:48:05 CST