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

  • 1
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值