rman dg duplicate 系列问题更新。。
6、RMAN> restore spfile from '/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2010_10_17/o1_mf_s_732633337_6cpcsv2b_.bkp';
恢复old spfile时RMAN-06564: must use the TO clause when the instance is started with SPFILE
解决办法:指定to cluase即可
Starting restore at 18-OCT-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/18/2010 10:52:45
RMAN-06564: must use the TO clause when the instance is started with SPFILE
RMAN> restore spfile to '/u01/app/oracle/db10g/dbs/spfileorcl.ora' from '/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2010_10_17/o1_mf_s_732633337_6cpcsv2b_.bkp';
Starting restore at 18-OCT-10
using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2010_10_17/o1_mf_s_732633337_6cpcsv2b_.bkp
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/18/2010 10:54:56
ORA-32011: cannot restore SPFILE to location already being used by the instance
RMAN> restore spfile to '/u01/app/oracle/spfileorcl.ora' from '/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2010_10_17/o1_mf_s_732633337_6cpcsv2b_.bkp';
Starting restore at 18-OCT-10
using channel ORA_DISK_1
channel ORA_DISK_1: autobackup found: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2010_10_17/o1_mf_s_732633337_6cpcsv2b_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 18-OCT-10
1、
RMAN> duplicate target database to orcl;--用于复制数据库/duplicate target database for standby;--用于生成standby库
Starting Duplicate Db at 17-OCT-10
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/17/2010 11:56:34
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/system01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/orcl/redo02.log conflicts with a file used by the target database
如果在RMAN恢复时不指定 nofilenamecheck 参数
则在db_file_name_convert or log_file_name_convert中源、目的数据文件(参数值)相同是做恢复会出现RMAN-05501错误
2、
RMAN> duplicate target database to orcl;
Starting Duplicate Db at 17-OCT-10
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/17/2010 11:02:08
ORA-01405: fetched column value is NULL
解决办法: alter system switch logfile
3、
contents of Memory Script.:
{
Alter clone database open resetlogs;
}
executing Memory Script
。。不动了
解决。。给每个日志文件至少一次归档
4、
DGMGRL> add database orcl as
> connect identifier is orcl
> maintained as physical;
Error: ORA-16642: db_unique_name mismatch
主库 和备库的db_unique_name不能一样
5、dg switch to norcl后
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16649: database will open after Data Guard broker has evaluated Fast-Start
Failover status
解决:首先检查listener是否正常
cli 查看configuration中fast_start failover是否enable 都具备则不需做什么
Cause: The database is being opened while Fast-Start failover is enabled. The message indicates that the Data Guard broker will first determine if conditions are suitable for opening; that is, a Fast-Start failover did not occur while the database was unavailable.
Action: No action is normally required. The Data Guard broker will continue opening the database after determining a Fast-Start failover did not occur. If there is a chance that a Fast-Start Failover did occur, the database will remain in the mounted state and will not open. In this case, check the target standby to see if a role transition took place.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21993926/viewspace-676217/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21993926/viewspace-676217/