ASM 2 ASM backup copy for RMAN duplicate

From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Thu, 9 May 2013 21:08:09 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C6F6ADE78_at_COPDCEXMB08.cable.comcast.com>

I am trying to do an RMAN duplication. I can't active duplicate, so I need to put all the backup files on the ASM instance in another RAC, but am having problems with the copies. I am on 11.2.0.3.5 on both RACs (RedHat 6.2) When I copy I can't get the files into a matching directory structure with matching names. Here are my notes. Does anyone have any ideas how to do this? (It just occurred to me I could probably put the backups on a local file system and use BACKUP LOCATION to read them from local disk rather than ASM? - that would assume you have enough local disk)

• copy file from source to target ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > ls +FRA/VODWPRD/backupset/2013_04_18/annnf0_TAG20130418T010116_0.311.813027677 annnf0_TAG20130418T010116_0.311.813027677 ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > ls -ls +FRA/VODWPRD/backupset/2013_04_18/annnf0_TAG20130418T010116_0.311.813027677 Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name BACKUPSET UNPROT COARSE APR 18 18:00:00 Y 512 957543 490262016 491782144 annnf0_TAG20130418T010116_0.311.813027677 ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > cp +FRA/VODWPRD/backupset/2013_04_18/annnf0_TAG20130418T010116_0.311.813027677 sys_at_kdb-ch2-a1s.sys.comcast.net.+ASM1:+FRA/VODWPRD/backupset/2013_04_18/annnf0_TAG20130418T010116_0 Enter password: ********* copying +FRA/VODWPRD/backupset/2013_04_18/annnf0_TAG20130418T010116_0.311.813027677 -> kdb-ch2-a1s.sys.comcast.net:+FRA/VODWPRD/backupset/2013_04_18/annnf0_TAG20130418T010116_0
• check for file on target ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > ls -ls +FRA/ASM/BACKUPSET/annnf0_TAG20130418T010116_0.1116.813090013 Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name BACKUPSET UNPROT COARSE APR 18 18:00:00 Y 512 957543 490262016 491782144 annnf0_TAG20130418T010116_0.1116.813090013

it appears to be there although created as an alias to the file copy that is itself in another location.

• Let us make an alias with the correct filename ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > mkalias +FRA/ASM/BACKUPSET/annnf0_TAG20130418T010116_0.1116.813090013 annnf0_TAG20130418T010116_0.1116.813090013 ORA-15032: not all alterations performed ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

doesn't let me. Well, there is already an alias (per docs you can only have one)

• Let us remove the existing alias (can only have one per docs) and create one with the correct filename ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > rmalias annnf0_TAG20130418T010116_0 ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > mkalias +FRA/ASM/BACKUPSET/annnf0_TAG20130418T010116_0.1116.813090013 annnf0_TAG20130418T010116_0.1116.813090013 ORA-15032: not all alterations performed ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

still doesn't let me.

• Can I copy the file into the correct directory with the correct name? ASMCMD [+FRA/VODWPRD/BACKUPSET/2013_04_18] > cp +FRA/ASM/BACKUPSET/annnf0_TAG20130418T010116_0.1116.813090013 annnf0_TAG20130418T010116_0.1116.813090013 copying +FRA/ASM/BACKUPSET/annnf0_TAG20130418T010116_0.1116.813090013 -> +FRA/VODWPRD/BACKUPSET/2013_04_18/annnf0_TAG20130418T010116_0.1116.813090013 ASMCMD-8016: copy source->'+FRA/ASM/BACKUPSET/annnf0_TAG20130418T010116_0.1116.813090013' and target->'+FRA/VODWPRD/BACKUPSET/2013_04_18/annnf0_TAG20130418T010116_0.1116.813090013' failed ORA-15056: additional error message ORA-15046: ASM file name '+FRA/VODWPRD/BACKUPSET/2013_04_18/annnf0_TAG20130418T010116_0.1116.813090013' is not in single-file creation form ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 413 ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

Jed

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 09 2013 - 23:08:09 CEST