Re: 9i RMAN restore to a different server with a backup from dataguard env

From: Prasad <p4cldba_at_gmail.com>
Date: Thu, 4 Oct 2007 10:19:16 -0700
Message-ID: <666b99c70710041019x6f189e3o5e24236c1be1e408@mail.gmail.com>

Hi Jerome.

Can I take a backup of a controlfile from standby db. ??? it errors out though.not sure if there is any other syntax available.

RMAN> backup current controlfile;

Starting backup at 04-OCT-07
allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=20 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/04/2007 10:16:24
ORA-00236: snapshot operation disallowed: mounted controlfile is a backup

On 10/4/07, Vitalis Jerome <vitalisman_at_gmail.com> wrote:
>
> Hi,
>
> Have you tried restoring the control file from a control file backup
> taken on the standby database?
>
> On 10/2/07, Prasad <p4cldba_at_gmail.com> wrote:
> > Hi Jerome,
> >
> > I checked again the permission of the backup piece and directory and
> looks
> > Ok. I mentioned I was able to do the controlfile restore from the
> > controlfile backuppiece. and I found that the controlfile backup doesnot
> > store the datafiles backed up on standby if it is not connected to
> catalog .
> > So I do not really know what are my options here.
> >
> > thanks
> > -Prasad
> >
> >
> >
> > On 10/2/07, Vitalis Jerome <vitalisman_at_gmail.com> wrote:
> > > On 10/1/07, Prasad <p4cldba_at_gmail.com> wrote:
> > > > Hi Jerome.
> > > >
> > > > There is no error on the output .
> > >
> > > Ah.
> > >
> > > > it just say that file not found .
> > >
> > > That's an error, isn't it?
> > >
> > > >somehow
> > > > it is not able to catch the backup piece that was done on standby
> server
> > .
> > > > any ideas.
> > >
> > > RMAN can't see those backup pieces? Have you checked the directory and
> > > file permissions?
> > >
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 04 2007 - 12:19:16 CDT