Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › ORA-1547 & ORA-1194 ORA-01110

40 积分	0 好友	14 主题

发消息

[物理/逻辑坏块] ORA-1547 & ORA-1194 ORA-01110

1^#

发表于 2013-1-18 11:24:03 | 查看: 4632| 回复: 9

executing command: SET until clause

Starting recover at 25-NOV-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1082 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1085 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1086 devtype=DISK

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 3 needs more recovery to be consistent
ORA-01110: data file 3: '+DATA/oradata/fdcd/sysaux.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/25/2008 19:53:15
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 1861 lowscn 2061909090 found to restore

分享0

收藏0 回复只看该作者道具举报

lunar

2^#

发表于 2013-1-18 11:26:53

没有前因后果，无法回答

回复只看该作者道具举报

yixin0358

3^#

发表于 2013-1-18 11:29:07

看似找不到archive log，检查archive log是否存在

回复只看该作者道具举报

taoy_2008

4^#

发表于 2013-1-18 11:29:37

lunar 发表于 2013-1-18 11:26
没有前因后果，无法回答

从rac 环境做了一个全备份. 恢复到单机数据库.
备份是成功的.
数据库3T.
生成了2个控制文件,一个是20121230,一个是20121231的.这两个都是备份生成的.
用20121231的控制文件恢复的时候提示上面的错误,

回复只看该作者道具举报

lunar

5^#

发表于 2013-1-18 11:31:26

在详细的说下，把备份脚本提出来，恢复步骤贴出来

回复只看该作者道具举报

taoy_2008

6^#

发表于 2013-1-18 11:37:12

rac备份脚本.
run {
allocate channel ch1 device type disk;
sql 'alter system archive log current';
backup database format '/u01/backup/rman_rkxxk_full_%s_%T_%p.bak';
release channel ch1;
}

备库mount后,恢复脚本:
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
restore database;
recover database;
}

}

回复只看该作者道具举报