Re: rman restore from consistent backup
From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 10 Feb 2009 23:33:32 +1100
Message-ID: <gmrru0$pcr$1_at_news.motzarella.org>
markg22003_at_yahoo.com wrote,on my timestamp of 10/02/2009 3:04 AM:
>> 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- Hide quoted text -
>>
>> - Show quoted text -
Date: Tue, 10 Feb 2009 23:33:32 +1100
Message-ID: <gmrru0$pcr$1_at_news.motzarella.org>
markg22003_at_yahoo.com wrote,on my timestamp of 10/02/2009 3:04 AM:
> On Feb 9, 11:02 am, ddf <orat..._at_msn.com> wrote:
>> 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- Hide quoted text -
>>
>> - Show quoted text -
> > The backup script was just: > > backup as compressed backupset database include current controlfile > > Thank you.
Did you restore the backed up controlfiles before starting the restore? If not, then the current controlfiles will not like a restored database from a few days ago. Received on Tue Feb 10 2009 - 06:33:32 CST