How to Copy ASM Files Across Nodes [ID 1147859.1]

来源：互联网发布：java web war包下载编辑：程序博客网时间：2024/05/01 15:27

--------------------------------------------------------------------------------

修改时间 13-DEC-2011 类型 HOWTO 状态 PUBLISHED

In this Document
Goal
Solution

--------------------------------------------------------------------------------

Applies to:
Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.2 - Release: 11.1 to 11.2
Information in this document applies to any platform.
Database - RMAN
***Checked for relevance on 14-Dec-2011***
Goal
You have a database (controlfiles, datafiles and archivelog files) on Node 1 residing on ASM and you wish to copy some of these files (or all) to another node. This second node may be using filesystem or ASM.

Solution
Oracle 11g Release 1 and Release 2 allows you to copy files across the network with the RMAN Active File Copy feature. This feature is controlled with the 'AUXILIARY FORMAT' option to the backup command.

For example, you can copy an archivelog like:

connect target SYS/...@srcinst # source system
connect auxiliary SYS/...@destinst # destination system
backup as copy reuse
archivelog like "/u01/oracle/archivelog/arc_des/arch%.arc"
auxiliary format "+RCVAREA" ;
Or copy a datafile like:

connect target SYS/...@srcinst # source system
connect auxiliary SYS/...@destinst # destination system
backup as copy reuse datafile "/u01/oracle/datafiles/system01.dbf"
auxiliary format "+DATA" ;
Oracle� Database Backup and Recovery Reference 11g Release 2 (11.2)
Part Number E10643-02:

AUXILIARY FORMAT: Copies the files on the target database to the specified location on the auxiliary instance. RMAN can only generate image copies when AUXILIARY FORMAT is specified. RMAN must be connected to both TARGET and AUXILIARY instances and have access to auxiliary channels.
You can use the BACKUP AUXILIARY FORMAT command to copy datafiles over the network between primary and standby databases. For example, if a datafile on a primary database was lost, you could CONNECT to the standby database as TARGET and the primary database as AUXILIARY, and copy an intact datafile from the standby host to the primary host.

formatSpec Specifies a pattern for naming the output image copies on an auxiliary instance. The path must be valid on the auxiliary host.

NEW Creates an image copy in the directory specified in the DB_CREATE_FILE_DEST initialization parameter of the auxiliary instance. The image copy is an Oracle-managed file.

REUSE Enables RMAN to overwrite an already existing backup or copy with the same file name as the file that BACKUP is currently creating.

See documentation for further details.