Re: rman restore from consistent backup

From: <markg22003_at_yahoo.com>
Date: Tue, 10 Feb 2009 09:42:35 -0800 (PST)
Message-ID: <d758535b-4636-4c18-a7b7-b0ddd6207e67_at_p36g2000prp.googlegroups.com>

On Feb 10, 7:33 am, Noons <wizofo..._at_yahoo.com.au> wrote:
> markg22..._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.- Hide quoted text -
>
> - Show quoted text -

Thank you.

Restoring controlfile worked.

Thanks again. Received on Tue Feb 10 2009 - 11:42:35 CST