ASM 2 ASM backup copy for RMAN duplicate
- From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 May 2013 21:08:09 +0000
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@xxxxxxxxxxxxxxxxxxxxxxxxxxx.+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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
