RE: RMAN restore/recover problem

  • From: "Holvoet, Jo" <jo.holvoet@xxxxxxxxxxxxx>
  • To: <gleb.otochkin@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 29 Aug 2013 09:26:55 +0200

Hi Gleb,

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Gleb Otochkin
Sent: woensdag 28 augustus 2013 23:07
To: oracle-l@xxxxxxxxxxxxx
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-----
>
>

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


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2013