Re: Need a lesson in RMAN for RAC

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: sacrophyte@xxxxxxxxx
  • Date: Fri, 7 Sep 2007 13:02:51 -0700

On 9/7/07, Charles Schultz <sacrophyte@xxxxxxxxx> wrote:
> archive log filename=+DATA/lumqa/1_38_629052887.dbf thread=1 sequence=38
> archive log filename=+DATA/lumqa/2_2_629052887.dbf thread=2 sequence=2
> ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> below
> ORA-01152: file 1 was not restored from a sufficiently old backup
> ORA-01110: data file 1: '+DATA/lumqa/datafile/system.314.629052819'

Was the SYSTEM file actually restored, or is it a file from a pre-existing

If pre-existing, you may need to apply the online logs, which may or may not
be available to you.  If this is a database being restored to a different
server, you
may need to get later archive logs and apply them.

That was occasionally required in the hot backup days when someone forget
to take the tablespaces out of backup mode and archiving the latest log.

Failure to do that step would result in the ORA-1110 error  (IIRC).

The fix was to apply the online redo logs if you had them.

The same thing can happen if you restore all but the SYSTEM file and try
to do a recovery.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: