rman restore from consistent backup
Date: Mon, 9 Feb 2009 07:53:41 -0800 (PST)
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:
When we tried to open database, we get:
RMAN> alter database open;
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
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