How to Copy ASM Files Across Nodes [ID 1147859.1]
--------------------------------------------------------------------------------
修改时间 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.
相关内容
--------------------------------------------------------------------------------
产品
--------------------------------------------------------------------------------•Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
--------------------------------------------------------------------------------
ASM; AUXILIARY; COPY FILING; DATAFILES; DB_CREATE_FILE_DEST; FILES; FILESYSTEM; ORACLE DATABASE; ORACLE-MANAGED FILES
How to Copy ASM Files Across Nodes [ID 1147859.1]
原创wuweilong 博主文章分类:Metalink转载备注 ©著作权
文章标签 database oracle image documentation initialization 文章分类 jQuery 前端开发
-
How to map asm files with online database files
<br /> <br /> One of the features of ASM is databases consolida
database file query branch path -
How to Convert a Single-Instance ASM to Cluster ASM [ID 452758.1]
<br /> Applies to: <br />Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11
oracle application database disk file -
How to move ASM database files from one diskgroup to another
<br /> <br /> <br /> The preferred way of doing the file movement amoung A
database file filenames system sql -
How to copy a datafile from ASM to a file system not using RMAN
<br /> <br /> How to move a datafile from a file system to ASM<br />
file system oracle object database -
How to Change ASM Home on a Node in RAC [ID 558508.1]
<br /> <br />How to Change ASM Home on a Node in RAC <br /> <br />步骤如下:<b
command oracle windows database 聊天 -
ASM 11g New Features - How ASM Disk Resync Works. [ID 466326.1]
<br /> <br />一. ASM Fast Disk Resync Overview<br /> 1) When we take a disk o
disk features allocation oracle database -
How to configure XDB for using ftp and http protocols with ASM [ID 357714.1]
<br /> <br /> Configuration of XDB(XML Database) to be able to use ftp an
protocols service system database session