Re: rman restore from consistent backup

From: ddf <oratune_at_msn.com>
Date: Mon, 9 Feb 2009 08:02:38 -0800 (PST)
Message-ID: <edd4b90b-3489-493c-a606-173389242ef8_at_r34g2000vbp.googlegroups.com>

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 Received on Mon Feb 09 2009 - 10:02:38 CST