rman restore from consistent backup

From: <markg22003_at_yahoo.com>
Date: Mon, 9 Feb 2009 07:53:41 -0800 (PST)
Message-ID: <9c6764d8-501c-48a0-a0cc-16f20cede60b_at_d36g2000prf.googlegroups.com>



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. Received on Mon Feb 09 2009 - 09:53:41 CST

Original text of this message