This discussion is archived
1 2 3 4 Previous Next 59 Replies Latest reply: Apr 18, 2013 11:36 PM by Hemant K Chitale Go to original post RSS
  • 30. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    The RESTORE CONTROFILE from disk would work.

    My point is : Once you have the controlfile, see if you can RESTORE DATABASE from tape. The controlfile does contain the rman repository for all recent database backups.


    Hemant K Chitale
  • 31. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    The thing is the new client is not able to read the backups of Production. You have to check with EMC.
  • 32. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Hi Hemant,

    First of all i am not able to restore control file from tape..it will not possible to restore database rt..!

    @Maran

    My backup team is already raised an sev 1 case with EMC.. twice i had a webex with EMC..they are also not able to figure out the issue...they are taking too much time..till now they didn't come up with the solution..!

    Thanks & Regards
    Prasanth
  • 33. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    There would be sbtio.log file in the trace folder. Can you post the output? that will provide some information on what exactly is happeneing

    One more thing you need to consider.

    Dont restore with the same catalog database. Restore the catalog to another database and connect the Test Server to connect to the new catalog databaase. This will make sure you dont mess up the catalog DB.

    It took long time for me as well

    1.Add the PROD IP to the testserver
    2. Add the testservet to the Networker global index
    3. Add the test server Oracle user to the networker users.
  • 34. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Hi Maran,

    Please find the below log which i captured from the adump (location is /u01/app/oracle/admin/mda/adump)...is it correct?

    *************************************************************
    Audit file /u01/app/oracle/admin/mda/adump/test1_ora_32700_1.aud
    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
    System name:     Linux
    Node name:     test1-oratest-01
    Release:     2.6.18-194.el5
    Version:     #1 SMP Tue Mar 16 21:52:39 EDT 2010
    Machine:     x86_64
    Instance name: TEST1
    Redo thread mounted by this instance: 0 <none>
    Oracle process number: 31
    Unix process pid: 32700, image: oracle@Test1-oratest-01 (TNS V1-V3)

    Wed Mar 20 09:51:13 2013 +05:30
    LENGTH : '149'
    ACTION :[7] 'CONNECT'
    DATABASE USER:[1] '/'
    PRIVILEGE :[6] 'SYSDBA'
    CLIENT USER:[6] 'oracle'
    CLIENT TERMINAL:[5] 'pts/0'
    STATUS:[1] '0'
    DBID:[0] ''
    *************************************************************

    Regarding catalog database restoration i didn't get what exactly..can you explain what in brief


    Thanks & Regards
    Prasanth
  • 35. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    There is a difference between

    RESTORE CONTROLFILE FROM '/expectedbakuppiecename'

    and

    RESTORE DATABASE


    In the former case, you are always explicitly providing a name which doesn't work. In the latter case, Oracle provides the names to the media management layer.




    Hemant K Chitale
  • 36. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Hi Maran/Hemant,

    Now i am able to restore spfile and control file to test server..EMC people did some modification server and changed in script..that worked...

    Please let me know futher steps for restoring whole the database..i restored spfile to tmp. From tmp i copied to dbs location with name of initdbname.ora.

    and i modified to cluster_database=false and exported with the database name and i tried to startup nomount but came with the below error..

    SQL> startup nomount;
    ORA-01078: failure in processing system parameters
    LRM-00123: invalid character 0 found in the input file


    Please help me in further steps to complete the restoration activity..

    Thanks in advance.

    Thanks & Regards
    Prasanth
  • 37. Re: Restoration of full DB backup to Test server by using RMAN
    Levi-Pereira Guru
    Currently Being Moderated
    Did you edited spfile with text editor? If yes...this is the problem..
    Spfile is not a text file, but a binary file...if you edit it you will corrupt this file.

    You need: create pfile from spfile...then edit pfile..and recreate spfile from pfile... and start database with nomount option.
  • 38. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    EMC people did some modification server and changed in script..that worked...
    I hope that you had documented these changes.

    An spfile should not be edited directly. You should create a PFILE and edit the PFILE.


    Hemant K Chitale
  • 39. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Hi Levi/Hemant,

    I alredy created pfile from spfile from my production server and i did some changes in pfile like instance name with TEST1 instead of actuall production instance name and kept in dbs location in test server and

    export ORACLE_SID=TEST1

    so i am able to go to nomount state by using pfile..and tried to restore to control file from tape it's worked and that control file is directly copied to both the diskgroup's--DATADG001 and FRA diskgroup,and updated with new control file name in pfile and tried to keep database in mount stage it worked.


    After mount i started resotoration but getting with the below:-

    ***********************************************
    ORA-19504: failed to create file "+DATADG001"
    ORA-17502: ksfdcre:4 Failed to create file +DATADG001
    ORA-15041: diskgroup "DATADG001" space exhausted

    failover to previous backup
    ***********************************************


    Note : My DATADG001 diskgroup total size is 16TB and backup size is 15.5TB ,i think with this its fine..but with out completly restore diskgroup got fulled and continously coming with above error.


    Below script i used for restoration after controlfile restore..

    RMAN> RUN
    2> {
    3> ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
    4> ALLOCATE CHANNEL CH2 TYPE 'SBT_TAPE';
    5> ALLOCATE CHANNEL CH3 TYPE 'SBT_TAPE';
    6> ALLOCATE CHANNEL CH4 TYPE 'SBT_TAPE';
    7> ALLOCATE CHANNEL CH5 TYPE 'SBT_TAPE';
    8> SEND'NSR_ENV=(NSR_SERVER=*********************,NSR_CLIENT=**********************.dom)';
    9> RESTORE DATABASE;
    10> RELEASE CHANNEL CH1;
    11> RELEASE CHANNEL CH2;
    12> RELEASE CHANNEL CH3;
    13> RELEASE CHANNEL CH4;
    14> RELEASE CHANNEL CH5;
    15> }

    its looks like it checking for all all weeks of backup's and trying to restore rt?if yes please tell me how to restore by using latest backup name by using Rman script.


    @Hemanth: EMC person did nothig just he added (backup server name&IP) and (target client name&IP) in the /etc/hosts file and route added the backup server IP to test server.that's all it worked.


    Thanks & Regards
    Prasanth
  • 40. Re: Restoration of full DB backup to Test server by using RMAN
    Levi-Pereira Guru
    Currently Being Moderated
    Hi,

    There is 16TB of data (i.e files) on +DATADG001 (maybe from previous attempts of restore)
    After mount i started resotoration but getting with the below:-
    
    ***********************************************
    ORA-19504: failed to create file "+DATADG001"
    ORA-17502: ksfdcre:4 Failed to create file +DATADG001
    ORA-15041: diskgroup "DATADG001" space exhausted
    If this DISKGROUP is exclusive from DATABASE restored and you have sure that files on it are obsolete you can DROP DATADG001 and Recreate it (because it change only header of ASMDISK and take seconds) that is more fast than delete all files (with rm command) which suffer I/O operation (can take hours).

    If DISKGROUP is not exclusive then you must manually delete all files that are obsolete or from previous attempts of restore.


    You can use ASMCMD to make you life easy.
    export ORACLE_HOME=<grid_home>
    export ORACLE_SID=+ASM
    export PATH=$ORACLE_HOME/bin;$PATH
    
    $ORACLE_HOME/bin/asmcmd lsdg DATADG001
    
    List all Luns of DISKGROUP to recreate it after
    $ORACLE_HOME/bin/asmcmd lsdsk -G DATADG001
    
    
    $ asmcmd
    # and use ls command to list the files 
    ASMCMD >  cd <DG_NAME>
    ASMCMD > ls
  • 41. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Your DATADG001 diskgroup has datafiles present (whether active or not) and occuping space.


    Hemant K Chitale
  • 42. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    HI levi/Hemant,

    I delete all file from DATADG001 diskgroup, now my diskgroup size is 15.95 TB that will be enough for restoring my last sunday backup but i listed the controlfile it's show from last 27th Mar onwards..

    so it's may trying to restore from 27th mar onwards..how to delete old control file in list and only to keep for last sunday i.e 7th April 2013.

    please help me on this becoz it's very urgent for me.

    Thanks & Regards
    Prasanth
  • 43. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Oracle will restore the file required to satisfy the SET UNTIL time that you specify --- it will not needlessly restore older files.
    So, if your SET UNTIL TIME clause specifies '07-APR-13', it would restore the 06-Apr controlfile and database files but not the 05-Apr and older files.
    (If there was no backup on 06-Apr, it would restore the newest backup on or before 06-Apr and not any older backups).



    Hemant K Chitale
  • 44. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Thanks Hemant for your quick reply..

    I used below script for restore database after controlfile restoration...is this works? given latest SCN( for 7th April 2013) in the script..!

    RUN
    {
    SET UNTIL SCN 37967315843;
    ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
    ALLOCATE CHANNEL CH2 TYPE 'SBT_TAPE';
    ALLOCATE CHANNEL CH3 TYPE 'SBT_TAPE';
    ALLOCATE CHANNEL CH4 TYPE 'SBT_TAPE';
    ALLOCATE CHANNEL CH5 TYPE 'SBT_TAPE';
    SEND'NSR_ENV=(NSR_SERVER=*****************,NSR_CLIENT=*********************)';
    RESTORE DATABASE;
    RELEASE CHANNEL CH1;
    RELEASE CHANNEL CH2;
    RELEASE CHANNEL CH3;
    RELEASE CHANNEL CH4;
    RELEASE CHANNEL CH5;
    }

    Right now restoration under process..!

    Is i need to do any changes?

    Thanks & Regards
    Prasanth

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points