Re: rman restore from consistent backup

From: <markg22003_at_yahoo.com>
Date: Mon, 9 Feb 2009 08:04:52 -0800 (PST)
Message-ID: <fa718537-0b05-4948-8f6f-7e40f38dc0f2_at_z27g2000prd.googlegroups.com>

On Feb 9, 11:02 am, ddf <orat..._at_msn.com> wrote:
> On Feb 9, 9:53 am, markg22..._at_yahoo.com wrote:
>
>
>
>
>
> > SUN SOLARIS 10
>
> > Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit
> > Production
>
> > Could someone help me please.
>
> > We are starting to use RMAN.
>
> > We have a test database running in noarchivelog mode.
>
> > We took a consistent backup (mount)  on Feb 5  20:55
> > (backup as compressed backupset database include current controlfile),
> > and another consistent backup on Feb 6 11:05.
>
> > There was some database activity since then.
>
> > This morning, Feb 9, we restored database:
> > (restore database).
>
> > When we tried to open database, we get:
>
> > RMAN> alter database open;
>
> > RMAN-00571:
> > ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> > ===============
> > RMAN-00571:
> > ===========================================================
> > RMAN-03002: failure of alter db command at 02/09/2009 10:32:06
> > ORA-01113: file 1 needs media recovery
> > ORA-01110: data file 1: '/u08/oradata/tst/system01.dbf'
>
> > We thought that you could open a consistent backup, without recovery.
>
> > Is that incorrect  ?
> > Is there any way to do that  ?
>
> > Thank you.
>
> Without seeing what you used as a backup command to RMAN for this
> database it's difficult to say what, exactly, has gone awry.  Post
> your backup script and someone may possibly be able to assist you
> further.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

The backup script was just:

backup as compressed backupset database include current controlfile

Thank you. Received on Mon Feb 09 2009 - 10:04:52 CST