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
  • 15. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    I believe you are using EMC Networker..

    I did a recovery few days ago...


    Few things to note :

    If there is retention policy set in the Networker for your DB backup after the rention policy it could delete the entry in the media database of networker.

    1. You need to check with your backup admin to atleast see if the backups are available in netowrker... you should atleast see some index on those specific time from savesets.
    2. Is the backup info seen in networker?? vey important if not you have to scan the entire tape tp update the Media database of networker..Once if it is confirmed then we can move...




    i recovered from 1 month old tape.......ANother important thing you need to give the NSR_CLIENT value to the production server so that the restore will look for the backups of the PROD SERVER

    Edited by: Maran Viswarayar on Mar 12, 2013 6:20 PM Added the NSR_CLIENT info

    Edited by: Maran Viswarayar on Mar 12, 2013 6:54 PM
    Removed the sentence..I CAN HELP here.....because everyone is helping...sorry
  • 16. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Greetings to Everyone,

    Still i am facing with same issue..when i am trying with latest backup that was taken at last sunday also getting with the below same error..please suggest me from where the issue is occuring?

    *1)* export ORACLE_SID=mda1

    *2)* sqlplus "/ as sysdba"
    SQL> select status from v$instance;

    STATUS
    ------------
    STARTED

    *3)* SQL> shut immediate;
    ORA-01507: database not mounted


    ORACLE instance shut down.

    *4)* rman target / nocatalog

    *5)* RMAN> startup force nomount;

    Oracle instance started

    Total System Global Area 1603411968 bytes

    Fixed Size 2226912 bytes
    Variable Size 469763360 bytes
    Database Buffers 1124073472 bytes
    Redo Buffers 7348224 bytes

    *6)* RMAN> set dbid=1022799756

    executing command: SET DBID

    *7)* RMAN> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '/NMO_MDA_c-1022799756-20130310-00/%F';

    executing command: SET CONTROLFILE AUTOBACKUP FORMAT

    *8)* RMAN> run
    2> {
    3> ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE';
    4> SEND 'NSR_ENV=(NSR_SERVER=Dc1BkpSrvr02.cidr.gov.in, NSR_CLIENT=uidl1-rac-a16-001-vip.uidl1.dom)';SEND 'NSR_ENV=(NSR_SERVER=Dc1BkpSrvr02.cidr.gov.in, NSR_CLIENT=uidl1-rac-a16-001-vip.uidl1.dom)';
    5> RESTORE CONTROLFILE TO '/u01/NMO_c-1022799756-20130310-00.ctl' FROM '/NMO_c-1022799756-20130310-00/';
    6> RELEASE CHANNEL CH1;
    7> }

    allocated channel: CH1
    channel CH1: SID=146 instance=mda1 device type=SBT_TAPE
    channel CH1: NMO v5.0.0.0

    sent command to channel: CH1

    sent command to channel: CH1

    Starting restore at 15-MAR-13

    channel CH1: no AUTOBACKUP in 7 days found
    released channel: CH1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 03/15/2013 07:58:23
    RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


    actually i am facing this problem from last 2 weeks...EMC support(Networker team) also not able to resolve..Please guide me if anything else i need to do.

    Thanks & Regards
    Prasanthkumar Reddy.M
  • 17. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Have you set the correct NSR_CLIENT ? It should be the "production" db server so that the NSR server knows that it is restoring a production copy.


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

    Below is total save set details send by backup team on every sunday once completes full backup.So NSR_CLIENT i given correct name only see in the below client

    **uidl1−rac−a16−001−vip.uidl1.dom* {Client}*

    **RMAN:/NMO_MDA_c−1022799756−20130310−00*/ {Save Set} -->This is the name in the log seperately taken for Control file..so by using this name we can restore control file and spfile from via tape.*

    **full* {Level}*

    **browsable* {Status}*

    **LTOUltrium−5* {MediaType}*

    **UI1014L5(82.0, c)* {VolumeName}*

    **L1MDAFULLWEEKLY* {Pool}*

    **60 MB* {Size}*

    **1* {Files}*

    **24/2/13 1:21:11 PM* {SaveTime}*


    Please tell me if any thing wrong i am doing while restoring FULL DB Backup to test server via tape....?

    Thanks & Regards
    Prasanth
  • 19. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    run 
    {
         set DBID=<yourdbid>
         ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' ;
         SEND DEVICE TYPE  'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=<NETOWRKERSERVERNAME>,NSR_CLIENT=<PROD SERVERNAME>)';
         set until time "TO_DATE('2013-03-14 00:00:00','yyyy-mm-dd hh24:mi:ss')";
         restore controlfile from autobackup;
         'sql alter database mount';
    }
    also you need to add entry of the prod server in the /etc/host file--<, This is very important

    10.50.0.0 prodeserver

    Edited by: Maran Viswarayar on Mar 15, 2013 3:12 PM

    Edited by: Maran Viswarayar on Mar 15, 2013 3:13 PM
  • 20. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Hi Maran,

    I followed the below Script which you provided and added prod server in the /etc/host file, but getting with below error.

    run
    {
         SET DBID=1022799756
         ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' ;
         SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=dc1bkpsrvr02.cidr.gov.in,NSR_CLIENT=uidl1-rac-a16-001-vip.uidl1.dom)';
         set until time "TO_DATE('2013-03-17 00:00:00','yyyy-mm-dd hh24:mi:ss')";
         restore controlfile from autobackup;
         'sql alter database mount';
    }


    Output:
    ******

    RMAN> run
    2> {
    3> set DBID=1022799756
    4> ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' ;
    5> SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=dc1bkpsrvr02.cidr.gov.in,NSR_CLIENT=uidl1-rac-a1 6-001-vip.uidl1.dom)';
    6> set until time "TO_DATE('2013-03-17 00:00:00','yyyy-mm-dd hh24:mi:ss')";
    7> restore controlfile from autobackup;
    8> }

    executing command: SET DBID

    using target database control file instead of recovery catalog
    allocated channel: CH1
    channel CH1: SID=134 instance=mda1 device type=SBT_TAPE
    channel CH1: NMO v5.0.0.0

    sent command to channel: CH1

    executing command: SET until clause

    Starting restore at 19-MAR-13

    channel CH1: looking for AUTOBACKUP on day: 20130317
    channel CH1: looking for AUTOBACKUP on day: 20130316
    channel CH1: looking for AUTOBACKUP on day: 20130315
    channel CH1: looking for AUTOBACKUP on day: 20130314
    channel CH1: looking for AUTOBACKUP on day: 20130313
    channel CH1: looking for AUTOBACKUP on day: 20130312
    channel CH1: looking for AUTOBACKUP on day: 20130311
    channel CH1: no AUTOBACKUP in 7 days found
    released channel: CH1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of restore command at 03/19/2013 09:48:30
    RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece



    Note :-Prod server detials i added as production server name in test server /etc/hosts file..like below

    *10.3.96.247 uidl1-rac-a16-001.uidl1.dom uidl1-rac-a16-001*

    Thanks & Regards
    Prasanth
  • 21. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You are still stuck on the RESTORE CONTROLFILE. What could be worse is if the RESTORE DATABASE also doesn't work.

    I suggest that you take a CONTROLFILE BACKUP on disk, copy the backup to the Test Server, restore the controlfile from the backup and then try a RESTORE DATABASE from tape.


    Hemant K Chitale
  • 22. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    Whats the retention period?

    are you able to see those savesets from the networker? are they available in the tape...You backup directly to tape right?

    Do you backup the control files?? or autobackup configured?


    post your backup script.

    Missed out the another thing. THe new server User say ORacle should be a memeber Networker admin to be able to read from the device.. I forgot its Netwoekjer admin or user...and this test server has to be added to the PROD Server confgurations in the networker..There would be a tab named global indexes where you need to add the New server name

    Edited by: Maran Viswarayar on Mar 19, 2013 2:28 PM

    Edited by: Maran Viswarayar on Mar 19, 2013 2:36 PM
  • 23. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    Another important thing is to look for your SBTIO.log in the trace directory..tail the last the few lines
  • 24. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Hi Maran,

    -->Retention period for full backup is 1 year.
    -->yes i have seen the savesets from networker..backup team will send's the save set details on by every week after mda full backup completion..yes they are available in the tape...yes backup is going directly to tape only..!
    -->yes for every backup control file and spfile backup is going on..!

    My backup script is below for full backup:

    connect target /
    *RUN {*
    crosscheck archivelog all;
    SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '/NMO_MDA_%F/';
    ALLOCATE CHANNEL c1 device type 'SBT_TAPE';
    ALLOCATE CHANNEL c2 device type 'SBT_TAPE';
    ALLOCATE CHANNEL c3 device type 'SBT_TAPE';
    ALLOCATE CHANNEL c4 device type 'SBT_TAPE';
    ALLOCATE CHANNEL c5 device type 'SBT_TAPE';
    ALLOCATE CHANNEL c6 device type 'SBT_TAPE';
    SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=dc1bkpsrvr02.cidr.gov.in,NSR_CLIENT=uidl1-rac-a16-001-vip.uidl1.dom,NSR_FXBUSY_RETRIES=20,NSR_SAVESET_BROWSE=Month,NSR_SAVESET_RETENTION=Month)';
    BACKUP
    incremental level 0
    FILESPERSET 60
    FORMAT '%d_%U'
    DATABASE
    INCLUDE CURRENT CONTROLFILE
    PLUS ARCHIVELOG;
    RELEASE CHANNEL c1;
    RELEASE CHANNEL c2;
    RELEASE CHANNEL c3;
    RELEASE CHANNEL c4;
    RELEASE CHANNEL c5;
    RELEASE CHANNEL c6;
    *}*

    --> yes new server user Oracle in my test server is a member of the networker admin...my oracle user only is the admin for the backup..yes test server is added to the prod server configuration in the networker..

    --> backup team is told that they added new server name in the global indexes...!

    so where is the problem i am not able to figure out...Is it problem from my side or from backup team..?


    @Hemant:-

    Without control restoration we can't go a head for database restore rt..!

    We can do control file restoration from my production but the thing is we are testing from tape whther backup are going fine or not.

    Ok i will try once by using controlfile backup from my production disk..can you please let me know the procedure for control file and spfile backup from my produciton and restore to test server..once i tried with controlfile trace backup and restore but it doesn;t work..!


    Thanks in advance:-)


    Thanks & Regards
    Prasanth
  • 25. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Backup and restore controlfile to/from disk :
    BACKUP CURRENT CONTROLFILE FORMAT '/tmp/cntrlfile_backup.dbf';
    rcp/scp the backup to the test server
    RESTORE CONTROLFILE FROM '/tmp/cntrlfile_backup.dbf';
    If you use a controlfile trace, you need the datafiles to be present for the CREATE CONTROLFILE to work. Also, if you do a CREATE CONTROLFILE, you lose all the RMAN repository information that would have been in the controlfile ! (you have to then rely on the RMAN Catalog)


    Hemant K Chitale
  • 26. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    Hemant,

    Its worth a try but the new client is not able to pick up the backups of the PRODUCTION.i battled for few days before figuring out.

    Prasanth

    Is the tape loaded?
  • 27. Re: Restoration of full DB backup to Test server by using RMAN
    Maran Viswarayar Pro
    Currently Being Moderated
    SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=dc1bkpsrvr02.cidr.gov.in,NSR_CLIENT=uidl1-rac-a1 6-001-vip.uidl1.dom)';
    you have a typo above
    SEND DEVICE TYPE 'SBT_TAPE' 'NSR_ENV=(NSR_SERVER=dc1bkpsrvr02.cidr.gov.in,NSR_CLIENT=uidl1-rac*-a1 6*-001-vip.uidl1.dom)';
    THere is no space inbetween 1-6 in the Backup script...can you please verify that
  • 28. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Thanks for the steps Hemant..i taken control file backup from my production and restored to test server...It worked..it looks like the problem is from tape only rt..?

    @Maran

    While pasting the output by mistake its came like this uidl1-rac-a1 6*-001-vip.uidl1.dom*...actually i am tried with out space only

    Thanks & Regards
    Prasanth
  • 29. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    I know that the controlfile disk backup restore would work.

    My point is : Once you have the controlfile, see if you can RESTORE DATABASE from tape.


    Hemant K Chitale

Legend

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