RAC backup questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emdproduction@hotmail.com - 30 Jan 2008 00:06 GMT

Group,

We just installed Oracle RAC(10.2) on linux.

We would like to backup the database for ASM disk and local disks at
the same time, so that every nodes can have access to the backup and
legato can have access to the file as well.

How could I ask RMAN to backup to two places at the same time?
One is to +ASMBAK, one is to /legato/rman?

Thanks

Reply to this Message

Bob Jones - 30 Jan 2008 03:08 GMT

> Group,
>
[quoted text clipped - 8 lines]
>
> Thanks

You can start 2 backup jobs, one for ASM and the other for Legato. I don't
see an issue here.

Reply to this Message

sybrandb - 30 Jan 2008 09:13 GMT

> <emdproduct...@hotmail.com> wrote in message
>
[quoted text clipped - 15 lines]
> You can start 2 backup jobs, one for ASM and the other for Legato. I don't
> see an issue here.

I do. The answer is blatantly incorrect. Please read the RMAN
documentation.

--
Sybrand Bakker
Senior Oracle DBA

Reply to this Message

Steve Howard - 30 Jan 2008 11:48 GMT

> <emdproduct...@hotmail.com> wrote in message
>
[quoted text clipped - 15 lines]
> You can start 2 backup jobs, one for ASM and the other for Legato. I don't
> see an issue here.

Hi,

Try the following link...

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1003.htm#s
thref186

HTH,

Steve

Reply to this Message

Bob Jones - 31 Jan 2008 01:36 GMT

>> <emdproduct...@hotmail.com> wrote in message
>>
[quoted text clipped - 26 lines]
>
> Steve

You are correct. That's the proper way to do it. OP can ignore my previous
comment.

Reply to this Message

DA Morgan - 31 Jan 2008 02:49 GMT

>> <emdproduct...@hotmail.com> wrote in message
>>
[quoted text clipped - 20 lines]
>
> Steve

One of the most important considerations is "where" to run the backup.

You don't want to run on every node ... and you have no guarantee that
any specific node will be up at 2:00am.

Executing the job from DBMS_SCHEDULER solves the problem.

Signature

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Reply to this Message

sybrandb - 30 Jan 2008 09:12 GMT

On Jan 30, 1:06 am, emdproduct...@hotmail.com wrote:

> Group,
>
[quoted text clipped - 8 lines]
>
> Thanks

Please read the documentation.
The procedure is described in full.
Please do not ask people to abstract the documentation for free.

--
Sybrand Bakker
Senior Oracle DBA

Reply to this Message