Databases Reference
In-Depth Information
Type Redund Striped Time Sys Name
BACKUPSET MIRROR COARSE AUG 18 13:00:00 N 0oniv1g8_1_1.rmb => +DG1/ASM/
BACKUPSET/0oniv1g8_1_1.rmb.256.791643731
The file was an alias to +DG1/ASM/BACKUPSET/0oniv1g8_1_1.rmb.256.791643731,
as an OMF file is supposed to be.
6.
If you want to copy a file to a file system from ASM, you can do that, too:
ASMCMD> cp 0pniv1go_1_1.rmb /tmp/a.dbf
copying +dg1/rman/0pniv1go_1_1.rmb -> /tmp/a.dbf
DBMS File Copy Approach
If the ASMCMD command line tool is not available, or you are on a version prior to Oracle Database 10.2, you can use
a package dbms_file_transfer to copy files. Here is an example:
1.
First, create the directory object on each of the source and destination ASM disk groups:
SQL> create directory rman as '+DG1/RMAN';
Directory created.
SQL> create directory rmanbackup as '+DG1/RMANBACKUP';
Directory created.
2.
Now use the following PL/SQL block to copy the file to a new name:
1 begin
2 dbms_file_transfer.copy_file (
3 SOURCE_DIRECTORY_OBJECT => 'RMAN',
4 SOURCE_FILE_NAME => '0oniv1g8_1_1.rmb',
5 DESTINATION_DIRECTORY_OBJECT => 'RMANBACKUP',
6 DESTINATION_FILE_NAME => '0oniv1g8_1_1.new.rmb'
7 );
8 end;
DBMS file transfer utility allows you to copy files between the operating system and ASM in versions prior to
Oracle Database 10.2.
■
Using either of these approaches—aSMCMd and dBMS file transfer—merely allows you to copy the files to
new destinations. the target files are not placed in the data dictionary and therefore are not recognized by rMaN,
unless you explicitly catalog them in rMaN.
Caution
