Re: RMAN restore/recover problem
From: Gleb Otochkin <gleb.otochkin_at_gmail.com>
Date: Wed, 28 Aug 2013 17:07:17 -0400
Message-ID: <521E6685.3040501_at_gmail.com>
Maybe it makes sense to check v$datafile_header for resetlogs scn and compare it with controlfile.
Is it possible you opened a database once with resetlogs and leave any files (like archivelogs) in FRA?
I would start from sql like "select file#,status,resetlogs_change# from v$datafile_header;"
Also it can help if you provide command (run block) used for rman to restore/recover database.
Date: Wed, 28 Aug 2013 17:07:17 -0400
Message-ID: <521E6685.3040501_at_gmail.com>
Maybe it makes sense to check v$datafile_header for resetlogs scn and compare it with controlfile.
Is it possible you opened a database once with resetlogs and leave any files (like archivelogs) in FRA?
I would start from sql like "select file#,status,resetlogs_change# from v$datafile_header;"
Also it can help if you provide command (run block) used for rman to restore/recover database.
Regards,
Gleb
On 28/08/2013 4:26 PM, Holvoet, Jo wrote:
> Hi Rajendra,
>
> That is precisely my problem ... the unix team did not include the
> autobackup files in their backups to tape so all my available
> controlfile backups are newer than the point-in-time I need ...
>
> Mvg/regards
> Jo
>
> -----Original Message-----
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 28 2013 - 23:07:17 CEST