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
都不能恢复过去。