This post is more than 5 years old
8 Posts
0
2474
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;">
MaatigAli
8 Posts
0
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.
Bebo2k
544 Posts
0
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
CarlosRojas
1.7K Posts
0
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.
MaatigAli
8 Posts
0
May 14th, 2012 01:00
still the same problem.
is there a procedure for recovery and verification?
coganb
736 Posts
0
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
Bebo2k
544 Posts
0
November 21st, 2012 01:00
Thanks for your update MaatigAli. Merci beaucoup