OraFAQ Forum: Backup & Recovery » RMAN restoring archivelogs before given PIT

Home » RDBMS Server » Backup & Recovery » RMAN restoring archivelogs before given PIT (11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN restoring archivelogs before given PIT [message #632145]

Mon, 26 January 2015 08:37

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

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632147 is a reply to message #632145]

Mon, 26 January 2015 08:41

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

What is the timestamp on the control file(s) you are using?

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632148 is a reply to message #632145]

Mon, 26 January 2015 08:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Please let me know where should I start digging

You should provide the requested file.

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632156 is a reply to message #632148]

Mon, 26 January 2015 09:16

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?

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632157 is a reply to message #632156]

Mon, 26 January 2015 09:19

gazzag
Messages: 1114
Registered: November 2010
Location: Bedwas, UK

Senior Member

RMAN realises that it needs the requested file(s) to ensure your database is consistent. RMAN knows better than you Smile

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632158 is a reply to message #632156]

Mon, 26 January 2015 09:22

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632163 is a reply to message #632158]

Mon, 26 January 2015 09:36

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

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632166 is a reply to message #632163]

Mon, 26 January 2015 10:03

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

The last successful backup

Which kind of backup?
Post the complete command.

Report message to a moderator

Re: RMAN restoring archivelogs before given PIT [message #632172 is a reply to message #632163]

Mon, 26 January 2015 11:36

John Watson
Messages: 8804
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.

Report message to a moderator

Previous Topic:	password on RMAN
Next Topic:	DBMS SCHEDULER

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 04:24:33 CDT 2023