OraFAQ Forum: Backup & Recovery » oracle DB recovery using rman

Home » RDBMS Server » Backup & Recovery » oracle DB recovery using rman

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

oracle DB recovery using rman [message #156635]

Thu, 26 January 2006 10:38

ujumaka
Messages: 7
Registered: January 2006

Junior Member

I tried performing an oracle DB recovery using

run {
set until time to_date('25-JAN-2006 00:00:00', 'DD-MON-YYYY HH24:MI:SS');
restore database;
recover database;
}

But it gave me an error message below:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 01/25/2006 22:59:06
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "double-quoted-string, equal, single-quoted-string"
RMAN-01008: the bad identifier was: to_date
RMAN-01007: at line 2 column 16 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 01/25/2006 22:59:06
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "(": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01007: at line 2 column 23 file: standard input:

Report message to a moderator

Re: oracle DB recovery using rman [message #156642 is a reply to message #156635]

Thu, 26 January 2006 12:16

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

use

set until time "to_date('25-JAN-2006 00:00:00', 'DD-MON-YYYY HH24:MI:SS')";

Report message to a moderator

Re: oracle DB recovery using rman [message #156688 is a reply to message #156642]

Fri, 27 January 2006 01:26

ujumaka
Messages: 7
Registered: January 2006

Junior Member

thanks

Report message to a moderator

Previous Topic:	Getting error ORA-00376: file 13 cannot be read at this time
Next Topic:	duplication of db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 10:38:26 CDT 2024