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
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'
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