Highlighted
MaatigAli
1 Nickel

Restauration base Oracle dans un autre serveur

Jump to solution

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

<br style="color: #000000; font-family: Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif; text-align: -webkit-auto; background-color: #f4f4f4;" 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

<span style="color: #000000; font-family: Verdana, Geneva, Lucida, 'Lucida Grande', Arial, Helvetica, sans-serif; text-align: -webkit-auto; background-color: #f4f4f4;" 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.

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

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
MaatigAli
1 Nickel

Re: Restauration base Oracle dans un autre serveur

Jump to solution

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.

0 Kudos
6 Replies
Bebo2k
3 Silver

Re: Restauration base Oracle dans un autre serveur

Jump to solution

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

0 Kudos
MaatigAli
1 Nickel

Re: Restauration base Oracle dans un autre serveur

Jump to solution

still the same problem.

is there a procedure for recovery and verification?


0 Kudos
CarlosRojas
4 Tellurium

Re: Restauration base Oracle dans un autre serveur

Jump to solution

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.

0 Kudos
coganb
3 Argentium

Re: Restauration base Oracle dans un autre serveur

Jump to solution

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

0 Kudos
MaatigAli
1 Nickel

Re: Restauration base Oracle dans un autre serveur

Jump to solution

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.

0 Kudos
Bebo2k
3 Silver

Re: Restauration base Oracle dans un autre serveur

Jump to solution

Thanks for your update MaatigAli. Merci beaucoup

0 Kudos