Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Wink Unanswered: Duplicate database with RMAN

    I am trying to duplicate source database with ASM to non-ASM database on the same host. I tried to use following statements but they fail with not able to find the datafile. The details are as below:

    rman target sys/can_it@qbprod2.premline.int AUXILIARY sys/can_it


    Run {

    allocate auxiliary channel d1 type disk ;
    set newname for datafile 1 TO '/ora00/RMAN10/system_01.dbf';
    set newname for datafile 2 TO '/ora_undo00/RMAN10/undo01_01.udo';
    set newname for datafile 3 TO '/ora00/RMAN10/sysaux_01.dbf';
    set newname for datafile 4 TO '/ora01/RMAN10/medslg01.dbf';
    set newname for datafile 5 TO '/ora02/RMAN10/medslg_indx01.dbf';
    set newname for datafile 6 TO '/ora03/RMAN10/medssm01.dbf';
    set newname for datafile 7 TO '/ora04/RMAN10/medssm_indx01.dbf';
    set newname for datafile 8 TO '/ora04/RMAN10/fdb01.dbf';
    set newname for datafile 9 TO '/ora00/RMAN10/fdb_indx01.dbf';
    set newname for datafile 10 TO '/ora00/RMAN10/users_01.dbf';
    set newname for datafile 11 TO '/ora00/RMAN10/tools_01.dbf';
    set newname for datafile 12 TO '/ora00/RMAN10/logmnr_01.dbf';
    set newname for datafile 13 TO '/ora00/RMAN10/adx01d_01.dbf';
    set newname for datafile 14 TO '/ora00/RMAN10/adx01x_01.dbf';

    set until time "to_date('04-NOV-2009 01:40:00','DD-MON-YYYY HH24:MIS')";
    duplicate target database to RMAN10
    NOFILENAMECHECK

    LOGFILE
    GROUP 1 (
    '/ora00/RMAN10/redo1a.rdo',
    '/ora01/RMAN10/redo1b.rdo'
    ) SIZE 120M reuse,
    GROUP 2 (
    '/ora02/RMAN10/redo2a.rdo',
    '/ora03/RMAN10/redo2b.rdo'
    ) SIZE 120M reuse;
    }

    The command executes and error out as:
    set newname for datafile 11 to
    "/ora00/RMAN10/tools_01.dbf";
    set newname for datafile 12 to
    "/ora00/RMAN10/logmnr_01.dbf";
    set newname for datafile 13 to
    "/ora00/RMAN10/adx01d_01.dbf";
    set newname for datafile 14 to
    "/ora00/RMAN10/adx01x_01.dbf";
    restore
    check readonly
    clone database
    ;
    }
    executing script: Memory Script

    executing command: SET until clause

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    Starting restore at 11-NOV-09

    released channel: d1
    RMAN-00571: ================================================== ======
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ============
    RMAN-00571: ================================================== ======
    RMAN-03002: failure of Duplicate Db command at 11/11/2009 13:12:35
    RMAN-03015: error occurred in stored script Memory Script
    RMAN-06026: some targets not found - aborting restore
    RMAN-06023: no backup or copy of datafile 14 found to restore
    RMAN-06023: no backup or copy of datafile 13 found to restore
    RMAN-06023: no backup or copy of datafile 12 found to restore
    RMAN-06023: no backup or copy of datafile 11 found to restore
    RMAN-06023: no backup or copy of datafile 10 found to restore
    RMAN-06023: no backup or copy of datafile 9 found to restore
    RMAN-06023: no backup or copy of datafile 8 found to restore
    RMAN-06023: no backup or copy of datafile 7 found to restore
    RMAN-06023: no backup or copy of datafile 6 found to restore
    RMAN-06023: no backup or copy of datafile 5 found to restore
    RMAN-06023: no backup or copy of datafile 4 found to restore
    RMAN-06023: no backup or copy of datafile 3 found to restore
    RMAN-06023: no backup or copy of datafile 2 found to restore
    RMAN-06023: no backup or copy of datafile 1 found to restore

    RMAN>

    How do I fix this error? I know the target database is in ASM with +DGROUP1 and auxiliary database files need to be in different file systems such as /ora00, /ora01 etc.. Can someone suggest me a solution please?

    Vinnie

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool List backupset

    The RMAN-06026 error indicates it is not finding an RMAN backup, do a "LIST BACKUPSET" on the target database to find out the available backups.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Thanks for the reply but I have the additional info

    I want to make sure that the
    set newname for datafile 1 TO '/ora00/RMAN10/system_01.dbf'; that TO need to be file path for duplicate database which is non-ASM.

    I tried to list backupset and got the BS Key as 1050 that has full database backups files in +DGROUP1. I am trying to transfer source ASM files to a non-ASM file system for my duplication but unable to because of skipping to write as already backedup as below. Any suggestions are welcome.


    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1050 Full 4.96G DISK 00:05:45 11-NOV-09
    BP Key: 1050 Status: AVAILABLE Compressed: NO Tag: TAG20091111T07560
    6
    Piece Name: +DGROUP1/mmqa/backupset/2009_11_11/nnndf0_tag20091111t075606
    _0.2699.702633371
    List of Datafiles in backup set 1050
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 210636820 11-NOV-09 +DGROUP1/mmqa/system_01.dbf
    2 Full 210636820 11-NOV-09 +DGROUP1/mmqa/undo01_01.udo
    3 Full 210636820 11-NOV-09 +DGROUP1/mmqa/sysaux_01.dbf
    4 Full 210636820 11-NOV-09 +DGROUP1/mmqa/medslg01.dbf
    5 Full 210636820 11-NOV-09 +DGROUP1/mmqa/medslg_indx01.dbf
    6 Full 210636820 11-NOV-09 +DGROUP1/mmqa/medssm01.dbf
    7 Full 210636820 11-NOV-09 +DGROUP1/mmqa/medssm_indx01.dbf
    8 Full 210636820 11-NOV-09 +DGROUP1/mmqa/fdb01.dbf
    9 Full 210636820 11-NOV-09 +DGROUP1/mmqa/fdb_indx01.dbf
    10 Full 210636820 11-NOV-09 +DGROUP1/mmqa/users_01.dbf
    11 Full 210636820 11-NOV-09 +DGROUP1/mmqa/tools_01.dbf
    12 Full 210636820 11-NOV-09 +DGROUP1/mmqa/logmnr_01.dbf
    13 Full 210636820 11-NOV-09 +DGROUP1/mmqa/datafile/adf_01_d.282.64777949
    1
    14 Full 210636820 11-NOV-09 +DGROUP1/mmqa/datafile/adf_01_x.284.64777949

    _00:20_Thu_full

    List of Archived Logs in backup set 1055
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- --------- ---------- ---------
    1 2978 210657405 12-NOV-09 210657474 12-NOV-09

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    1056 Full 10.42M DISK 00:00:01 12-NOV-09
    BP Key: 1056 Status: AVAILABLE Compressed: NO Tag: TAG20091112T00240
    9
    Piece Name: /ora_backup/prev_0/mmqa/control/MMQA_controlfile_autobackup_
    c-969575723-20091112-00
    Control File Included: Ckp SCN: 210657481 Ckp time: 12-NOV-09

    RMAN> backup backupset 1050 format '/ora_backup/vinnie/%U';

    Starting backup at 12-NOV-09
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=620 devtype=DISK
    skipping backupset key 1050; already backed up 1 time(s)
    Finished backup at 12-NOV-09

    RMAN>

Posting Permissions

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