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
  • 45. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You could have put a RECOVER DATABASE in the same Run block.

    Now, you'd have to create a new run block with SET UNTIL SCN and RECOVER DATABASE.
    (I assume that the ArchiveLogs for the Recovery are available and that Oracle can restore them automatically from tape).


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

    I facing a issue with Diskgroup in ASM@Test server..


    ASMCMD> lsdg
    State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
    MOUNTED NORMAL N 512 4096 1048576 16730790 16730331 1520980 7604675 0 N DATADG001/
    MOUNTED NORMAL N 512 4096 1048576 162140 161950 0 80975 0 N FRA/
    MOUNTED NORMAL N 512 4096 1048576 14331 13405 310 6547 0 Y SYSTEMDG/


    Usable_file_mb space is equal to total_mb...when i am trying to restore space getting complete due to mirroring..getting with below error

    channel CH2: ORA-19870: error while restoring backup piece MDA_2ao59uuj_1_1
    ORA-19504: failed to create file "+DATADG001"
    ORA-17502: ksfdcre:4 Failed to create file +DATADG001
    ORA-15041: diskgroup "DATADG001" space exhausted


    can you please suggest me some what of urgency that how to disable mirroring for diskgroup and make equal space for both Total_MB and Usable_file_MB..!

    Thanks & Regards
    Prasanth
  • 47. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    To disable mirroring you have to DROP (which means that all files of all databases in the DG will be lost) and reCREATE the DISKGROUP with REDUNDANCY EXTERNAL.
    I presume that this is DG is used only by test environments which can afford to lose data.


    Hemant K Chitale
  • 48. Re: Restoration of full DB backup to Test server by using RMAN
    User477708-OC Journeyer
    Currently Being Moderated
    Prasanthkumar Reddy.M wrote:
    Hemanth,

    I facing a issue with Diskgroup in ASM@Test server..


    ASMCMD> lsdg
    State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
    MOUNTED NORMAL N 512 4096 1048576 16730790 16730331 1520980 7604675 0 N DATADG001/
    MOUNTED NORMAL N 512 4096 1048576 162140 161950 0 80975 0 N FRA/
    MOUNTED NORMAL N 512 4096 1048576 14331 13405 310 6547 0 Y SYSTEMDG/


    Usable_file_mb space is equal to total_mb...when i am trying to restore space getting complete due to mirroring..getting with below error

    channel CH2: ORA-19870: error while restoring backup piece MDA_2ao59uuj_1_1
    ORA-19504: failed to create file "+DATADG001"
    ORA-17502: ksfdcre:4 Failed to create file +DATADG001
    ORA-15041: diskgroup "DATADG001" space exhausted


    can you please suggest me some what of urgency that how to disable mirroring for diskgroup and make equal space for both Total_MB and Usable_file_MB..!

    Thanks & Regards
    Prasanth
    cant do it, need to move datafiles to new diskgroup with external redudancy which doesnt mirror. It assumes youre mirroring or raiding on the storage already. You cant change the redundancy of an existing group.

    Note.438580.1 - How To Move The Database To Different Diskgroup (Change Diskgroup Redundancy)
  • 49. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    Hi Hemanth,

    Restoration is completed succufully but while i am starting recover database by using until SCN getting with error

    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> RECOVER DATABASE UNTIL SCN 37967315843;
    10> RELEASE CHANNEL CH1;
    11> RELEASE CHANNEL CH2;
    12> RELEASE CHANNEL CH3;
    13> RELEASE CHANNEL CH4;
    14> RELEASE CHANNEL CH5;
    15> }


    output:-

    starting media recovery
    media recovery failed
    released channel: CH1
    released channel: CH2
    released channel: CH3
    released channel: CH4
    released channel: CH5
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 04/12/2013 09:39:02
    ORA-00283: recovery session canceled due to errors
    RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
    start until change 37967315843 using backup controlfile
    ORA-00283: recovery session canceled due to errors
    ORA-00275: media recovery has already been started

    RMAN> **end-of-file**


    thanks for all you support for entire restoration problem, in the final i am stucking with recover please help on this so that i will complete my restoration dril.

    Thanks,
    Prasanth
  • 50. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    ORA-00275: media recovery has already been started
    You have another RECOVER DATABASE session initiated.


    Hemant K Chitale
  • 51. Re: Restoration of full DB backup to Test server by using RMAN
    PrasanthkumarReddy.M Newbie
    Currently Being Moderated
    I kiilled alll rman session and started freshly again i am getting error..shall start to open the database?

    Regards
    Prasanth
  • 52. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    From the SQLPlus command prompt you could issue
    RECOVER DATABASE CANCEL

    Then issue a
    RECOVER DATABASE UNTIL CHANGE n

    for SCN based recovery

    Then, if the recovery completes successfully :
    ALTER DATABASE OPEN RESETLOGS



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

    Getting with below error when i am trying to recover again...!
    RMAN> @recover_db.sh

    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=************************)';
    9> recover database;
    10> RELEASE CHANNEL CH1;
    11> RELEASE CHANNEL CH2;
    12> RELEASE CHANNEL CH3;
    13> RELEASE CHANNEL CH4;
    14> RELEASE CHANNEL CH5;
    15> }
    using target database control file instead of recovery catalog
    allocated channel: CH1
    channel CH1: SID=407 device type=SBT_TAPE
    channel CH1: NMO v5.0.0.0

    allocated channel: CH2
    channel CH2: SID=452 device type=SBT_TAPE
    channel CH2: NMO v5.0.0.0

    allocated channel: CH3
    channel CH3: SID=497 device type=SBT_TAPE
    channel CH3: NMO v5.0.0.0

    allocated channel: CH4
    channel CH4: SID=542 device type=SBT_TAPE
    channel CH4: NMO v5.0.0.0

    allocated channel: CH5
    channel CH5: SID=587 device type=SBT_TAPE
    channel CH5: NMO v5.0.0.0

    sent command to channel: CH1
    sent command to channel: CH2
    sent command to channel: CH3
    sent command to channel: CH4
    sent command to channel: CH5

    Starting recover at 12-APR-13
    Starting implicit crosscheck backup at 12-APR-13
    Finished implicit crosscheck backup at 12-APR-13

    Starting implicit crosscheck copy at 12-APR-13
    Crosschecked 6 objects
    Finished implicit crosscheck copy at 12-APR-13

    searching for all files in the recovery area
    cataloging files...
    no files cataloged


    starting media recovery

    archived log for thread 1 with sequence 22118 is already on disk as file /u01/app/oracle/product/11.2.0/db_1/dbs/archmda_1_761845397_22118.arc
    archived log for thread 1 with sequence 22119 is already on disk as file /u01/app/oracle/product/11.2.0/db_1/dbs/archmda_1_761845397_22119.arc
    archived log for thread 2 with sequence 20277 is already on disk as file /u01/app/oracle/product/11.2.0/db_1/dbs/archmda_2_761845397_20277.arc
    archived log for thread 2 with sequence 20278 is already on disk as file /u01/app/oracle/product/11.2.0/db_1/dbs/archmda_2_761845397_20278.arc
    archived log file name=/u01/app/oracle/product/11.2.0/db_1/dbs/archmda_2_761845397_20277.arc thread=2 sequence=20277
    archived log file name=/u01/app/oracle/product/11.2.0/db_1/dbs/archmda_1_761845397_22118.arc thread=1 sequence=22118
    released channel: CH1
    released channel: CH2
    released channel: CH3
    released channel: CH4
    released channel: CH5
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of recover command at 04/12/2013 12:44:21
    ORA-00283: recovery session canceled due to errors
    RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/u01/app/oracle/product/11.2.0/db_1/dbs/archmda_1_761845397_22 118.arc'
    ORA-00283: recovery session canceled due to errors
    ORA-28365: wallet is not open

    RMAN> **end-of-file**



    Please let me know the solution for this hemanth in urgencydue getting delay from long time...

    Thanks a lot for response..!

    Regards
    Prasanth
  • 54. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You have to address the error
    ORA-28365: wallet is not open
    Apparently the database has Transparent Data Encryption on one or more tablespaces and the wallet is required to update the tablespaces.


    Hemant K Chitale
  • 55. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    ORA-28365: wallet is not open 
    Cause: The security module wallet has not been opened.
    Action: Open the wallet.
    See 3.2.1.2 Using Wallets with Automatic Login Enabled at http://docs.oracle.com/cd/E11882_01/network.112/e10746/asotrans.htm#sthref86
    3.3.1.2 Using an Auto Login Wallet at http://docs.oracle.com/cd/E11882_01/network.112/e10746/asotrans.htm#CHDCCHBH
    9.4.14 Using Auto Login at http://docs.oracle.com/cd/E11882_01/network.112/e10746/asowalet.htm#i1006873

    You need to first start with identifying the wallet file that the source database uses ! You'll need to copy it to the restored database location (the correct directory specified ... e.g. as in http://docs.oracle.com/cd/E11882_01/network.112/e10746/asoappf.htm#i634246 )

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

    DB Backup restoration is completed succefully and i opened the database in both the nodes but one issue came up when opened the database on both the nodes that is data is synced on both production and test servers and production process got stuck up..!


    What's the problem excatly happen internally between the server..is i need to remove any parameters in test servers to avoid the connectivity b/w the servers?


    Regards
    Prasanth
  • 57. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    You probably have a database link in the database that refers back to the production database. The database link is probably used by a job that updates data !

    If you have one or more database links in a database, it would be good to disable them first (e.g. by ensuring that the test database does not have the same tnsnames.ora entries for remote databases) before selectively enabling or modifying them (e.g. if a production database "A" refers to another production database "B" the test database "AT" should be modifying it's database link to point to "BT" instead of "B" !)


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

    can you let me know how can i check the database links that which jobs updating data?

    if we have any jobs running how we can diasable the jobs,

    one more thing hemanth before connectivity was not happened b/w test server and tapes so added production VIP and backup server IP in test server in to /etc/hosts file then only connection established and started restoration,so it maked any hamper after database open on both the test nodes..

    when i started the database open on test nodes immediately in prodution duplicates entiries are entred and stopped the process in prod.

    Is i need remove the entries in /etc/hosts file regarding production?

    after stopping test server imeditely production process started..


    Thanks for your kind informantion Hemanth.


    Regards
    Prasanth
  • 59. Re: Restoration of full DB backup to Test server by using RMAN
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    can you let me know how can i check the database links that which jobs updating data?

    if we have any jobs running how we can diasable the jobs,
    I can't help you there. You'd have to look at the database objects and the application code and jobs.

    Is i need remove the entries in /etc/hosts file regarding production?
    Some sites have seperate networks to as to prevent test/develpment connecting to prod. (But you'd have to see if your network restore of the database can be done).
    Most other sites would include documentation on "special steps" (e.g. changing passwords, disabling certain jobs, changing database links etc) to be executed at/during/after a clone/restore. If you don't have one, you'd have to create one specific to your site / database configuration.


    Hemant K Chitale
1 2 3 4 Previous Next

Legend

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