Home » RDBMS Server » Backup & Recovery » RMAN restoring archivelogs before given PIT (11.2.0.3)
RMAN restoring archivelogs before given PIT [message #632145] Mon, 26 January 2015 08:37 Go to next message
sahadba
Messages: 59
Registered: September 2009
Location: Pune
Member

Hi Team,

I am running a PIT clone from A to B. Here even though the PIT given was

set until time "to_date('24.01.2015-01:35:29','dd.mm.yyyy-hh24:mi:ss')";


RMAN is restoring Archive logs from tape as old as 20th Jan

channel c4: piece handle=3lpt8321_1_1 tag=ARCHIVELOG-20.01.15-23:30:19


I even restarted the clone after doing a catalog resync. Please let me know where should I start digging

Thank You
Sahadevan
Re: RMAN restoring archivelogs before given PIT [message #632147 is a reply to message #632145] Mon, 26 January 2015 08:41 Go to previous messageGo to next message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
What is the timestamp on the control file(s) you are using?
Re: RMAN restoring archivelogs before given PIT [message #632148 is a reply to message #632145] Mon, 26 January 2015 08:42 Go to previous messageGo to next message
BlackSwan
Messages: 25797
Registered: January 2009
Location: SoCal
Senior Member
>Please let me know where should I start digging

You should provide the requested file.
Re: RMAN restoring archivelogs before given PIT [message #632156 is a reply to message #632148] Mon, 26 January 2015 09:16 Go to previous messageGo to next message
sahadba
Messages: 59
Registered: September 2009
Location: Pune
Member

I am providing those files. Want to know why does RMAN require those files in the first place?
Re: RMAN restoring archivelogs before given PIT [message #632157 is a reply to message #632156] Mon, 26 January 2015 09:19 Go to previous messageGo to next message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
RMAN realises that it needs the requested file(s) to ensure your database is consistent. RMAN knows better than you Smile
Re: RMAN restoring archivelogs before given PIT [message #632158 is a reply to message #632156] Mon, 26 January 2015 09:22 Go to previous messageGo to next message
BlackSwan
Messages: 25797
Registered: January 2009
Location: SoCal
Senior Member
We only know what you post (assuming what you post is actually true).
We have no idea what specifically you did prior to your post with regards to either the backup or restore operation.
I believe that Oracle to smart enough to only ask for REDO files that it KNOWS are needed to produce a consistent database.
Successful results do not depend upon you knowing why.
Just out of curiosity, when was the most recent successful FULL backup of this database?
Re: RMAN restoring archivelogs before given PIT [message #632163 is a reply to message #632158] Mon, 26 January 2015 09:36 Go to previous messageGo to next message
sahadba
Messages: 59
Registered: September 2009
Location: Pune
Member

The last successful backup was on 23rd, below is the log with start time , end time

Quote:
23.01.15-23:30:03 24.01.15-01:33:29 LVV ONFU OK 159919-159926 ONFU-23.01.15-23:30:03


Now, the PIT we gave was 2 mins after the backup completion.

I know RMAN knows better, I just want to understand why. Smile
Re: RMAN restoring archivelogs before given PIT [message #632166 is a reply to message #632163] Mon, 26 January 2015 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
The last successful backup


Which kind of backup?
Post the complete command.

Re: RMAN restoring archivelogs before given PIT [message #632172 is a reply to message #632163] Mon, 26 January 2015 11:36 Go to previous message
John Watson
Messages: 7220
Registered: January 2010
Location: Global Village
Senior Member
Do you have any read-only tablespaces and have you set backup optimization on? This could cause any one backup to be incomplete.
Previous Topic: password on RMAN
Next Topic: DBMS SCHEDULER
Goto Forum:
  


Current Time: Tue Jan 23 05:06:13 CST 2018

Total time taken to generate the page: 0.01611 seconds