重庆思庄Oracle、Redhat认证学习论坛

标题: 怎么处理这个？RMAN> alter database open resetlogs ; [打印本页]

作者: admin 时间: 2013-2-20 10:25
标题: 怎么处理这个？RMAN> alter database open resetlogs ;

A、

怎么处理这个？
RMAN> alter database open resetlogs ;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 02/20/2013 09:46:49
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/opt/app/oracle/oradata/orcl/system01.dbf'

B、

重新恢复data file 1

A、

这前我执行了这个。
run {startup mount;
set until time = "to_date('19-02-13 16:08:00','dd-mm-yy hh24:mi:ss')";
restore database;
recover database;
alter database open resetlogs;}

B、

ORA-01152: file 1 was not restored from a sufficiently old backup
这里报错说没充分恢复datafile 1，你单独恢复1后再试试

A、

恢复到哪点时间点？

B、

你脚本那个时间点

重新恢复data file 1

A、

在这种情况下，其它的数据文件恢复了吗？

B、

ORA-01152: file string was not restored from a sufficiently old backup
Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the database consistent. This file is still in the future of the last log applied. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.
Action: Either apply more logs until the database is consistent or restore the database file from an older backup and repeat recovery.

你的备份是什么时候做的

restore datafile 1恢复单个文件,就只是恢复文件1,其他文件不会恢复

A、

对的，郑老师，应该是你说的问题。我看可以备份生成时间是16：45。
而我et until time = "to_date('19-02-13 16:08:00','dd-mm-yy hh24:mi:ss')";

B、

那肯定不行啥
你不能跑到备份的前面去了

作者: admin 时间: 2013-2-20 10:28

A、

starting media recovery

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/20/2013 10:24:42
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 95 lowscn 3144295 found to restore

B、

RMAN-06025: no backup of log thread 1 seq 95 lowscn 3144295 found to restore

没有找到归档日志文件的备份

先restore归档日志看看

[此贴子已经被作者于2013-2-20 10:29:40编辑过]

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)