Home » RDBMS Server » Backup & Recovery » recovering db from incrementally updated disk image (10.2.0.1 on OLE Linux)
recovering db from incrementally updated disk image [message #322198] Thu, 22 May 2008 14:20 Go to next message
lvoorhee
Messages: 2
Registered: May 2008
Junior Member
Hi,
I am testing an rman restore from an incrementally updated disk image backup. I'm running the code below, but it fails with an ORA-00907. Looking at my code, it looks like all my i's are dotted and t's crossed.
Has anyone else encountered?

RMAN> RUN
2> {
3> SET UNTIL TIME "TO_DATE('2008-04-29:13:32:00','yyyy-dd-mm:hh24:mi:ss')";
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESETLOGS;
7> }

executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 04/29/2008 16:17:01
ORA-00907: missing right parenthesis

RMAN>
Re: recovering db from incrementally updated disk image [message #322225 is a reply to message #322198] Thu, 22 May 2008 17:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
'2008-04-29:13:32:00',
'yyyy-dd-mm:hh24:mi:ss')"

mm=29?
Re: recovering db from incrementally updated disk image [message #322230 is a reply to message #322225] Thu, 22 May 2008 19:10 Go to previous message
lvoorhee
Messages: 2
Registered: May 2008
Junior Member
Yes, after looking at this for I don't know how long, support pointed out the same.
Thank you!
Previous Topic: RMAN - FRA or/and MML?
Next Topic: recovery from datafiles only in noarchivelog mode
Goto Forum:
  


Current Time: Sun May 12 01:42:53 CDT 2024