Home » RDBMS Server » Backup & Recovery » question about recover until restore point
question about recover until restore point [message #247068] Sat, 23 June 2007 09:49 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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 ./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
Re: question about recover until restore point [message #247094 is a reply to message #247068] Sat, 23 June 2007 17:47 Go to previous messageGo to next message
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,
Re: question about recover until restore point [message #247097 is a reply to message #247094] Sun, 24 June 2007 00:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
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

Re: question about recover until restore point [message #247148 is a reply to message #247068] Sun, 24 June 2007 12:59 Go to previous messageGo to next message
prince973
Messages: 37
Registered: November 2006
Member
michel do u think i am posting a fake question??
Re: question about recover until restore point [message #247151 is a reply to message #247148] Sun, 24 June 2007 13:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I should not have to ask me this question.
You should just copy and paste your screen.

Regards
Michel
Re: question about recover until restore point [message #247170 is a reply to message #247094] Sun, 24 June 2007 22:57 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

prince973 wrote on Sun, 24 June 2007 04:47

i think i am asking expert people who knows the real problem not a typing mistake,



Your language is not better to appreciate the experts...

Re: question about recover until restore point [message #247270 is a reply to message #247068] Mon, 25 June 2007 05:50 Go to previous message
prince973
Messages: 37
Registered: November 2006
Member
thanks Arju
Previous Topic: Incremental Backup of updated and new records/tables
Next Topic: RMAN-06403 ORA-01034 When registering database in RMAN
Goto Forum:
  


Current Time: Sat Dec 03 20:09:59 CST 2016

Total time taken to generate the page: 0.10308 seconds