Home » Non-English Forums » French » Problème restauration Oracle via Networker (HP UX)
Problème restauration Oracle via Networker [message #552255] Tue, 24 April 2012 10:23 Go to next message
alimaatig
Messages: 1
Registered: April 2012
Location: Tunisie
Junior Member
j'ai lancée la restauration d'une base oracle vers un nouveau Node en utilisant Networker.

la restauration de fichier de controle est OK par contre la restauration de la base de données, des erreurs sont apparus.

le script de restauration de la base est :

--------------------------------
RMAN> Run{
allocate channel t1 type 'SBT_TAPE'
send 'NSR_ENV=(NSR_SERVER="PRS1DL24",NSR_CLIENT="PR-S1-RX01P2-BCK")';
restore database ;
recover databse;
}

----------------


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

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

freeing unused errinfo with msgid 23761
freeing unused errinfo with msgid 23761
39078 1335193442 0 0 2 1 17357 0 pprx1-prd (pid17357) 14 %s error: %s%s 3 0 3 RAP 49 42 0 2 %s 1 11 27 308:Operation not supported 0 23 (severity 5, number 1)
freeing unused errinfo with msgid 23761
0 1335193442 2 0 0 1 17357 0 pprx1-prd (pid17357) 22 lgto_auth falling back 0
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

Re: Problème restauration Oracle via Networker [message #552338 is a reply to message #552255] Wed, 25 April 2012 03:22 Go to previous message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Il faut faire un copier/coller de la session et non retaper les commandes et poster une partie de la session. Le script posté n'est pas valide et on ne comprend pas ce qui fait, dans quel ordre...
2/ L'erreur indiquée est une, ou plutôt sont des erreurs networker pas RMAN, il vaudrait mieux poster la question sur un forum Networker.

Cordialement,
Michel
Previous Topic: Exemple de récupération de données d'une page Web via SQL
Next Topic: Gateway installation on same machine as Oracle Database
Goto Forum:
  


Current Time: Mon Sep 01 19:05:26 CDT 2014

Total time taken to generate the page: 0.08766 seconds