LoveUnix » ORACLE等数据库 » rman恢复数据库报错
让LU留住您的每

一天 让LU博客留住您的每一天
2007-12-20 15:16 jason_zhi
rman恢复数据库报错

请教一个问题:我有rman全备份数据库,保存在另外一个机器上,后来数据库机器坏掉了,现在想恢复数据库,那是如何操作呢?

我的oracle是oracle10g的。
RMAN>  restore controlfile to '/usr/oracle/oradata/lcshow/control01.ctl' from autobackup;

Starting restore at 14-NOV-06
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=146 devtype=DISK

recovery area destination: /usr/oracle/flash_recovery_area
database name (or database unique name) used for search: SUPERSMS
channel ORA_DISK_1: no autobackups found in the recovery area
channel ORA_DISK_1: looking for autobackup on day: 20061114
channel ORA_DISK_1: looking for autobackup on day: 20061113
channel ORA_DISK_1: looking for autobackup on day: 20061112
channel ORA_DISK_1: looking for autobackup on day: 20061111
channel ORA_DISK_1: looking for autobackup on day: 20061110
channel ORA_DISK_1: looking for autobackup on day: 20061109
channel ORA_DISK_1: looking for autobackup on day: 20061108
channel ORA_DISK_1: no autobackup in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/14/2006 07:40:18
RMAN-06172: no autobackup found or specified handle is not a valid copy or piec

都不能恢复过去。

2007-12-20 15:33 jiazhh
"channel ORA_DISK_1: no autobackup in 7 days found"
备份失效了,冗余策略为保存7天.

建议使用sys.dbms_backup_restore包来恢复控制文件先,然后使用旧的控制文件恢复.

2007-12-20 17:47 boypoo
restore controlfile to '/usr/oracle/oradata/lcshow/control01.ctl' from '备份文件';试试

页: [1]
查看完整版本: rman恢复数据库报错


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.