How to recover (clone) DB from RAC+ASM
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to recover (clone) DB from RAC+ASM

  1. #1
    Join Date
    Dec 2008
    Posts
    2

    How to recover (clone) DB from RAC+ASM

    Hi everybody,
    i need help how to clone (recover) our prod database to another server from disk (tape). Our prod database is in RAC with ASM and I need to clone it to different server without ASM and RAC. Everything is Win2003 Srv.
    I do it this way:

    1. On prod server i make backup running this script in RMAN
    configure channel device type 'SBT_TAPE' parms'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=e:\backup)';

    RUN {
    backup device type SBT_TAPE database tag zal20081129;
    SQL 'alter system archive log current';
    backup device type SBT_TAPE archivelog ALL tag zal20081129;
    }

    2. I prepared clon instance on another server (The same Oracle version) and start it to nomount mode.

    3. I copied the backup from prod server to clon server to exactly the same path. (e:\backup)

    4. On clon server i connect to RMAN
    set ORACLE_SID=clon
    rman
    connect target /

    set DBID 3079749916 - that is DBID from our prod DB

    startup nomount;

    run {
    allocate CHANNEL CTAPE DEVICE TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=e:\backup)';
    allocate channel CDISK DEVICE TYPE DISK;
    restore controlfile from 'e:\backup\name_of_backup_file'; -this restore control file correctly
    }

    alter database mount;

    run {
    Set newname for datafile 1 to 'e:\oradata\CLON\system.272.668509367';
    Set newname for datafile 2 to 'e:\oradata\CLON\undotbs1.273.668509387';
    Set newname for datafile 3 to 'e:\oradata\CLON\sysaux.263.668509393';
    Set newname for datafile 4 to 'e:\oradata\CLON\ifsapp_archive_data.298.668509401';
    Set newname for datafile 5 to 'e:\oradata\CLON\ifsapp_archive_index.258.668509401';

    restore database;

    switch datafile all;

    recover database;
    }

    But i got this error
    .....
    ....
    filename=E:\ORADATA\AGOST\IFSAPP_INDEX.299.668510843
    datafile 16 switched to datafile copy
    input datafile copy recid=84 stamp=672939884 filename=E:\ORADATA\AGOST\IFSAPP_DATA.300.668510859
    datafile 17 switched to datafile copy
    input datafile copy recid=85 stamp=672939884 filename=E:\ORADATA\AGOST\IFSAPP_DATA.301.668510865

    Starting recover at 08-DEC-08
    using channel ORA_DISK_1
    using channel ORA_SBT_TAPE_1

    starting media recovery

    Oracle Error:
    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'E:\ORADATA\AGOST\SYSTEM.272.668509367'

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 12/08/2008 15:45:14
    RMAN-06053: unable to perform media recovery because of missing log
    RMAN-06025: no backup of log thread 1 seq 227 lowscn 800414116 found to restore


    Shall i set any SET UNTIL clause???? or what is wrong. Why Oracle doesnt recover just to the point of the backup saved in e:\backup?
    please help
    John

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    When restoring from a hot backup recovery is always needed meaning, logs generated until the end of the backup have to be available for recovery.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Dec 2008
    Posts
    2
    Thanks for you answer,
    but I do have the archived logs in my backup. The whole backup has this structure:
    filenames:
    1. 2qk18tcm_1_1 40GB = datafiles
    2. 2rk193jm_1_1 15MB = controlfiles, spfile
    3. 2sk193kn_1_1 5GB = archived logs
    so the recovery process should use the archived logs. Even log from the backup shows, that the file is in the backup.

    Part of the backup log:
    ...
    input archive log thread=1 sequence=225 recid=422 stamp=672393041
    input archive log thread=1 sequence=226 recid=424 stamp=672409469
    input archive log thread=1 sequence=227 recid=426 stamp=672431129
    input archive log thread=1 sequence=228 recid=427 stamp=672435840
    input archive log thread=1 sequence=229 recid=430 stamp=672435856
    ...

    So i dont know whats wrong?

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