Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

2474

April 25th, 2012 01:00

Restauration base Oracle dans un autre serveur

j'ai lance la restauration d'une base oracle en utilisant l'agent NMDA1.0.

#rman target /

RMAN> run{

               allocate channel t1 type 'SBT_TAPE'

              send 'NSR_ENV=(NSR_SERVER="PRS1DL24",NSR_CLIENT="PR-S1-RX01P2-BCK")';

               restore databse;

               recover database,

               }

l'erreur suivant est apparu :

ORA-19507: failed to retrieve sequential file, handle="BSCSPROD_8276_20120416", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

There is already a NW session opened by this thread. (0:3:11)

failover to previous backup


mcestyle="color: #000000; font-family: Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif; text-align: -webkit-auto; background-color: #f4f4f4;">

channel t1: starting datafile backupset restore

channel t1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /cpvabf/PPBSCS/system.dbf

restoring datafile 00002 to /cpvabf/PPBSCS/undo.dbf

restoring datafile 00003 to /cpvabf/PPBSCS/sysaux.dbf

restoring datafile 00004 to /cpvabf/PPBSCS/data01.dbf

restoring datafile 00005 to /cpvabf/PPBSCS/data02.dbf

restoring datafile 00006 to /cpvabf/PPBSCS/contract01.dbf

restoring datafile 00007 to /cpvabf/PPBSCS/contract02.dbf

restoring datafile 00008 to /cpvabf/PPBSCS/dirnum_contr01.dbf

restoring datafile 00009 to /cpvabf/PPBSCS/dirnum_contr02.dbf

restoring datafile 00010 to /cpvabf/PPBSCS/pr_services01.dbf

restoring datafile 00011 to /cpvabf/PPBSCS/pr_services02.dbf

restoring datafile 00012 to /cpvabf/PPBSCS/pr_services_hist01.dbf

restoring datafile 00013 to /cpvabf/PPBSCS/pr_services_hist02.dbf

restoring datafile 00014 to /cpvabf/PPBSCS/customer01.dbf

restoring datafile 00015 to /cpvabf/PPBSCS/customer02.dbf

restoring datafile 00016 to /cpvabf/PPBSCS/tickler01.dbf

restoring datafile 00017 to /cpvabf/PPBSCS/tickler02.dbf

restoring datafile 00018 to /cpvabf/PPBSCS/turnover01.dbf

restoring datafile 00019 to /cpvabf/PPBSCS/turnover02.dbf

restoring datafile 00020 to /cpvabf/PPBSCS/request01.dbf

restoring datafile 00021 to /cpvabf/PPBSCS/request02.dbf

restoring datafile 00022 to /cpvabf/PPBSCS/bi_account01.dbf

restoring datafile 00023 to /cpvabf/PPBSCS/bi_account02.dbf

restoring datafile 00024 to /cpvabf/PPBSCS/orderh01.dbf

restoring datafile 00025 to /cpvabf/PPBSCS/orderh02.dbf

restoring datafile 00026 to /cpvabf/PPBSCS/cash01.dbf

restoring datafile 00027 to /cpvabf/PPBSCS/cash02.dbf

restoring datafile 00028 to /cpvabf/PPBSCS/i_data01.dbf

restoring datafile 00029 to /cpvabf/PPBSCS/i_data02.dbf

restoring datafile 00030 to /cpvabf/PPBSCS/i_contract01.dbf

restoring datafile 00031 to /cpvabf/PPBSCS/i_contract02.dbf

restoring datafile 00032 to /cpvabf/PPBSCS/i_dirnum_contr01.dbf

restoring datafile 00033 to /cpvabf/PPBSCS/i_dirnum_contr02.dbf

restoring datafile 00034 to /cpvabf/PPBSCS/i_pr_services01.dbf

restoring datafile 00035 to /cpvabf/PPBSCS/i_pr_services02.dbf

restoring datafile 00036 to /cpvabf/PPBSCS/i_customer01.dbf

restoring datafile 00037 to /cpvabf/PPBSCS/i_customer02.dbf

restoring datafile 00038 to /cpvabf/PPBSCS/i_tickler01.dbf

restoring datafile 00039 to /cpvabf/PPBSCS/i_tickler02.dbf

restoring datafile 00040 to /cpvabf/PPBSCS/i_bill_account01.dbf

restoring datafile 00041 to /cpvabf/PPBSCS/i_bill_account02.dbf

restoring datafile 00042 to /cpvabf/PPBSCS/i_turnover01.dbf

restoring datafile 00043 to /cpvabf/PPBSCS/i_turnover02.dbf

restoring datafile 00044 to /cpvabf/PPBSCS/i_request01.dbf

restoring datafile 00045 to /cpvabf/PPBSCS/i_request02.dbf

restoring datafile 00046 to /cpvabf/PPBSCS/i_orderh01.dbf

restoring datafile 00047 to /cpvabf/PPBSCS/i_orderh02.dbf

restoring datafile 00048 to /cpvabf/PPBSCS/i_cash01.dbf

restoring datafile 00049 to /cpvabf/PPBSCS/i_cash02.dbf

restoring datafile 00050 to /cpvabf/PPBSCS/i_pr_services_hist01.dbf

restoring datafile 00051 to /cpvabf/PPBSCS/i_pr_services_hist02.dbf

restoring datafile 00052 to /cpvabf/PPBSCS/ordertrl01.dbf

restoring datafile 00053 to /cpvabf/PPBSCS/ordertrl02.dbf

restoring datafile 00054 to /cpvabf/PPBSCS/i_ordertrl01.dbf

restoring datafile 00055 to /cpvabf/PPBSCS/i_ordertrl02.dbf

restoring datafile 00056 to /cpvabf/PPBSCS/data03.dbf

restoring datafile 00057 to /cpvabf/PPBSCS/data04.dbf

restoring datafile 00058 to /cpvabf/PPBSCS/users_01.dbf

restoring datafile 00059 to /cpvabf/PPBSCS/undo2.dbf

restoring datafile 00060 to /cpvabf/PPBSCS/data05.dbf

restoring datafile 00061 to /cpvabf/PPBSCS/i_users01.dbf

restoring datafile 00062 to /cpvabf/PPBSCS/data06.dbf

restoring datafile 00063 to /cpvabf/PPBSCS/data07.dbf

channel t1: reading from backup piece BSCSPROD_8264_20120413

freeing unused errinfo with msgid 23761

freeing unused errinfo with msgid 23761

freeing unused errinfo with msgid 23761

ORA-19870: error reading backup piece BSCSPROD_8264_20120413

ORA-19507: failed to retrieve sequential file, handle="BSCSPROD_8264_20120413", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

The function nsr_bind_recov_mm() failed with the error: Remote system error (1:5:238)

failover to previous backup

mcestyle="color: #000000; font-family: Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif; text-align: -webkit-auto; background-color: #f4f4f4;">merci d'avancer pour votre aide.

mcestyle="color: #000000; font-family: Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif; text-align: -webkit-auto; background-color: #f4f4f4;">

8 Posts

November 21st, 2012 00:00

le problème est résolu.

c'est un problème de flux réseau entre le serveur d'origine et le serveur de restauration.

544 Posts

April 26th, 2012 18:00

Hi MaatigAli,

Have you checked the remote access on the source and target?

Please check the following Powerlink articles and that community thread as well:

https://community.emc.com/thread/136112

https://solutions.emc.com/emcsolutionview.asp?id=esg83533

https://solutions.emc.com/emcsolutionview.asp?id=esg117358

Hope this helps you.

Thanks,

Ahmed Bahaa

1.7K Posts

May 14th, 2012 01:00

Hi,

Did you change the script as suggested earlier?:

run{

   

        allocate channel t1 type 'SBT_TAPE' parms

                'ENV=(NSR_SERVER=server,NSR_CLIENT=client,NSR_DPRINTF=TRUE,

        NSR_DEBUG_FILE=/nsr/applogs/t1.log,NSR_DEBUG_LEVEL=2)' ;

        release channel t1;

        }

Did you check the status of savesets as described in:

https://solutions.emc.com/emcsolutionview.asp?id=esg83533

If you did both, are you getting the exact same error message?

Thank you.

Carlos.

8 Posts

May 14th, 2012 01:00

still the same problem.

is there a procedure for recovery and verification?


736 Posts

May 14th, 2012 06:00

Hi,

It looks to me like you might have some typing mistakes in your script:

"

restore databse;

recover database,

"

Also, you can check out the NMDA Admin Guide section 'Oracle Data restore and recovery' which should help you through this process.

-Bobby

544 Posts

November 21st, 2012 01:00

Thanks for your update MaatigAli. Merci beaucoup

No Events found!

Top