Tuesday, 31 December 2013

RMAN incomplete recovery until time

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>cd\

C:\>rman target /

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: IACM (DBID=1202915429)

RMAN> shutdown;

using target database controlfile instead of recovery catalog
database closed
database dismounted
Oracle instance shut down

RMAN> startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> run {
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> set until time ='2010-01-08 23:02:38';
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }

allocated channel: c1
channel c1: sid=13 devtype=DISK

allocated channel: c2
channel c2: sid=14 devtype=DISK

executing command: SET until clause
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 01/08/2010 23:08:39
ORA-01861: literal does not match format string

RMAN>

No comments:

Post a Comment