Re: rman restore from consistent backup

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Mon, 9 Feb 2009 08:19:06 -0800 (PST)
Message-ID: <e8306682-d2d9-40d3-b913-d75e5d133275_at_x6g2000pre.googlegroups.com>



On Feb 9, 10: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.

If you are running in noarchivelog mode the only way to use rman is to take a backup when the database is shutdown ( not open ).

Think about buying Robert Freeman's most recent ( 10g ) RMAN book. Received on Mon Feb 09 2009 - 10:19:06 CST

Original text of this message