我用oracle 10g 作了备份恢复测试例子,例子在
http://www.cndw.com/tech/data/2006051166816.asp
数据库中有一些数据和表,
备份数据库后,试图恢复
RMAN>startup
配置RMAN
RMAN> configure channel device type disk format 'F:\backup\%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'F:\backup\%U';
new RMAN configuration parameters are successfully stored
RMAN>startup nomount
RMAN>restore controlfile to 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADB\CONTROL01.CTL 'from autobackup;
restore controlfile to 'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADB\CONTROL01.CTL ' from autobackup;
出错,
RMAN-03002: failure of restore command at 07/15/2007 08:58:49
ORA-19607: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORADB\CONTROL01.CTL is an active con
trolfile
请问应该怎么处理呀?
我在运行startup nomount时出现
database is already started信息
是否要shutdown immediate 后再startup nomount
再运行restore controlfile to 语句?