RMAN-05001，RMAN-05500 问题解决

最新推荐文章于 2023-12-03 15:25:29 发布

cuixie2370

最新推荐文章于 2023-12-03 15:25:29 发布

阅读量1.6k

点赞数

文章标签：数据库

本文档详细记录了在创建备用数据库过程中遇到RMAN-05001和RMAN-05500错误的解决步骤。首先，在主节点上执行RMAN备份，然后在备用节点上进行相关操作。当尝试挂载备用数据库时，遇到了冲突，通过使用nofilenamecheck选项成功避免了文件冲突，最终完成了备用数据库的创建。

摘要由CSDN通过智能技术生成

On the primary node, perform. an RMAN backup of the primary database that places the backup pieces into the staging directory. For example:
[oracle@chicago_host1 stage]$ rman target /

RMAN> BACKUP DEVICE TYPE DISK FORMAT '/u01/backup/%U' DATABASE PLUS ARCHIVELOG;

RMAN> BACKUP DEVICE TYPE DISK FORMAT '/u01.backup/%U' CURRENT CONTROLFILE FOR STANDBY;

Standby要置为 SQL> startup nomount

rac01sty$cd backup/
rac01sty$ls
01l277gl_1_1 03l277i0_1_1 05l277jq_1_1 listener.ora
02l277h6_1_1 04l277i9_1_1 initORCL.ora tnsnames.ora

rac01sty$rman target sys/oracle@orcl_pri auxiliary /

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Dec 30 05:40:07 2009

connected to target database: ORCL (DBID=1234616916)
connected to auxiliary database: ORCL (not mounted)

RMAN> duplicate target database for standby ;

Starting Duplicate Db at 30-DEC-09
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=149 instance=orcl1 devtype=DISK

contents of Memory Script.:
{
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script

Starting restore at 30-DEC-09
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/05l277jq_1_1
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/u01/backup/05l277jq_1_1 tag=TAG20091230T143642
channel ORA_AUX_DISK_1: restore complete, elapsed time: