Recover database until time format

ORACLE_RMAN_until time format

Proble Desc:

RMAN> recover database until time '02/28/2011 16:06:23';

Starting recover at 28-FEB-11

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 02/28/2011 16:52:17

ORA-01843: not a valid month

 

Solution:

RMAN> recover database until time "to_date('2011-02-28 16:06:23','YYYY-MM-DD HH24:MI:SS')";

Starting recover at 28-FEB-11

using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 1 is already on disk as file/opt/oracle/oradata/hw181/redo03.log

archive log thread 1 sequence 2 is already on disk as file/opt/oracle/oradata/hw181/redo04.log

archive log thread 1 sequence 3 is already on disk as file/opt/oracle/oradata/hw181/redo02.log

archive log filename=/opt/oracle/oradata/hw181/redo03.log thread=1sequence=1

archive log filename=/opt/oracle/oradata/hw181/redo04.log thread=1sequence=2

archive log filename=/opt/oracle/oradata/hw181/redo02.log thread=1sequence=3

media recovery complete

Finished recover at 28-FEB-11

RMAN> alter database open resetlogs;

database opened

RMAN>

 

Time：2011-02-28 16:06:23

bash-3.00$ ls -l

total 8150

drwxr-xr-x   2 oracle   dba         512 Feb 28 16:07 arch

-rw-r-----   1 oracle   dba     1916928 Feb 28 16:06 c-1826176847-20110228-09

bash-3.00$ tail -300 alert_hw*

Mon Feb 28 16:06:23 2011

Starting control autobackup

Control autobackup written to DISK device

        handle'/opt/oracle/hw181/dbs/c-1826176847-20110228-09'

Mon Feb 28 16:27:52 2011