copying archivelogs from ASM of praimary RAC to ASM of standby RAC
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: copying archivelogs from ASM of praimary RAC to ASM of standby RAC

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    128

    copying archivelogs from ASM of praimary RAC to ASM of standby RAC

    Hi,

    Primary database - 2 node RAC cluster on ASM

    Standby database - 2 node RAC cluster on ASM with dataguard

    Version - 11.1.0.7.0

    I have to copy some archivelogs which are on ASM to the ASM location of the standby node. can you please help.

    Here's what I have so far ...

    On primary
    ========
    logged into RMAN
    copy archivelog '+FRA_PROD/2012_10_26/thread_2_seq_6664.6373.79999999' to /u50/thread_2_seq_6664.6373.79999999' ;

    The above command copied it to a f/s on the OS level.

    then I scp'd the file to the standby node.

    on the standby node :
    i logged into rman
    cataloged the file -- catalog start with "/u050/thread2-seq_6664.6373.79999999' ; - completed successfully

    then i tried to copy the file into ASM as follows

    copy archivelog '/u050/thread2-seq_6664.6373.79999999' to '+FRA_STANDBY/2012_10_26/thread2-seq_6664.6373.79999999' '

    but got the error - ORA-01276: cannot add file +FRA+STANDBY/2012_10_26/thread2-seq_6664.6373.79999999. File has an Oracle managed Files file name.

    Please suggest if there is any other way to accompolish copying files from one ASM node to another ASM node.

    Appreciate your help.

    Regards
    Jay

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Hi

    Since you are in 11.1.0.7 you can cp command in asmcmd

    Regards

  3. #3
    Join Date
    Feb 2001
    Posts
    128
    I logged into the target server where the archives are copied over (by scp) and did the following .. still getting errors

    asmcd -p
    cp '/u50/thread_2_seq_6664.6373.79999999' '+FRA_STANDBY/2012_10_26/thread_2_seq_6664.6373.79999999'

    ASMCMD- 0816 copy source->'/u50/thread_2_seq_6664.6373.79999999' ' and target->'+FRA_STANDBY/2012_10_26/thread_2_seq_6664.6373.79999999'
    failed
    ORA-15406: ASM file name '+FRA_STANDBY/2012_10_26/thread_2_seq_6664.6373.79999999' is not in single-file creation form
    ORA-6512: at "SYS.X$DBMS_DISKGROUP", line 410
    ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

    Please suggest
    Jay

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    try cp '/u50/thread_2_seq_6664.6373.79999999' '+FRA_STANDBY/2012_10_26/ since you are using OMF

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width