RE: RMAN restore/recover problem

Like I replied to Mark, there is indeed an issue here with the undo tbs which has a checkpoint time way in the past ...

The run block I'm using is very basic :

run{
set until time "to_date('21-AUG-2013 09:00:00','DD-MON-YYYY HH24:MI:SS')";
restore database;
recover database;
sql 'alter database open resetlogs';
}

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gleb Otochkin Sent: woensdag 28 augustus 2013 23:07
To: oracle-l_at_freelists.org
Subject: Re: RMAN restore/recover problem

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


--
http://www.freelists.org/webpage/oracle-l