OraFAQ Forum: Backup & Recovery » question about recover until restore point

Home » RDBMS Server » Backup & Recovery » question about recover until restore point

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

question about recover until restore point [message #247068]

Sat, 23 June 2007 09:49

prince973
Messages: 37
Registered: November 2006

Member

Dear all,
i have a question regarding point in time recovery,
i created a restore point at 16:55:00 pm ,
create restore point point1655;

when i try to recover database until this point ,

RMAN>recover database until restore point point1655;

i am getting this error:

datafile must be restored from backup older than scn ...

but when i use recover until time
run{
allocate channel c1 device type disk;
set until time="to_date('23/06/2007 16:55:00','dd/mm/yyyy hh24:mi:ss')";
restore database;
recover database;
};

things go fine without errors ,
any body has an idea about this, i know that the two ways should be same, but there must be something wrong,
please advise;

[Updated on: Sat, 23 June 2007 17:49]

Report message to a moderator

Re: question about recover until restore point [message #247073 is a reply to message #247068]

Sat, 23 June 2007 10:31

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

Senior Member
Account Moderator

I don't trust you, I get:

RMAN> recover database until resorte point point1655;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "logseq, restore, scn, sequence, time"
RMAN-01008: the bad identifier was: resorte
RMAN-01007: at line 1 column 24 file: standard input

Post what you really did and not /forum/fa/1597/0/

The whole rman session from start to exit.

Please read and follow How to format your posts.
Break your lines to max 80-100 characters when you format.
Please always post your Oracle version (4 decimals).

Regards
Michel

Report message to a moderator

Re: question about recover until restore point [message #247094 is a reply to message #247068]

Sat, 23 June 2007 17:47

prince973
Messages: 37
Registered: November 2006

Member

i am sorry , mistakenly i wrote it here resort but what if u type it restore
i think i am asking expert people who knows the real problem not a typing mistake,

Report message to a moderator

Re: question about recover until restore point [message #247097 is a reply to message #247094]

Sun, 24 June 2007 00:42

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

Senior Member
Account Moderator

I am asking people to post real question and not faking one.
Copying and pasting here a session is not more difficult than typing and it prevents from writing wrong things.

Regards
Michel

[Updated on: Sun, 24 June 2007 00:43]

Report message to a moderator