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