07-02-2015 02:55 AM
I have configured an Oracle Intelligent policy whose backups were successful but when I try to restore it gives me the following error
ORA-19870: error while restoring backup piece bk_dTEST_u1bq7olp7
ORA-19507: failed to retrieve sequential file, handle="bk_dTEST_u1bq7olp7", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <c-1454518342-20110713-01> not found in NetBackup catalog
Kindly be informed that I have the master server and the client which runs the database are the same server
Kindly find the dbclient logs in the attachments
Solved! Go to Solution.
07-02-2015 03:12 AM
You are requesting a IMAGE not found in the Netbackup catalog
Backup file <c-1454518342-20110713-01> not found in NetBackup catalog
Verift with the bplist command what backup you have of the Oracle client
bplist -B -C {CLIENT_NAME} -R -l -t 4 -s 01/01/2015 /
Depending on naming format in OIP, command will return somthing like
-rw-rw---- oracle dba 262144 May 22 15:28 /bck_10159_1_880385331
-rw-rw---- oracle dba 786432 May 22 15:28 /bck_10156_1_880385316
-rw-rw---- oracle dba 262144 May 22 15:28 /bck_10158_1_880385316
-rw-rw---- oracle dba 262144 May 22 15:28 /bck_10157_1_880385316
-rw-rw---- oracle dba 1048576 May 22 15:28 /bck_10154_1_880385299
-rw-rw---- oracle dba 524288 May 22 15:28 /bck_10153_1_880385299
-rw-rw---- oracle dba 786432 May 22 15:28 /bck_10155_1_880385299
-rw-rw---- oracle dba 14155776 May 22 15:28 /arc01_8633_1_880385280
-rw-rw---- oracle dba 13631488 May 22 15:28 /arc01_7481_1_880385280
-rw-rw---- oracle dba 262144 May 22 15:27 /t8q7j77u_1_1
-rw-rw---- oracle dba 786432 May 22 15:27 /t7q7j77f_1_1
-rw-rw---- oracle dba 524288 May 22 15:27 /t6q7j77f_1_1
-rw-rw---- oracle dba 786432 May 22 15:27 /t5q7j77f_1_1
07-02-2015 03:12 AM
You are requesting a IMAGE not found in the Netbackup catalog
Backup file <c-1454518342-20110713-01> not found in NetBackup catalog
Verift with the bplist command what backup you have of the Oracle client
bplist -B -C {CLIENT_NAME} -R -l -t 4 -s 01/01/2015 /
Depending on naming format in OIP, command will return somthing like
-rw-rw---- oracle dba 262144 May 22 15:28 /bck_10159_1_880385331
-rw-rw---- oracle dba 786432 May 22 15:28 /bck_10156_1_880385316
-rw-rw---- oracle dba 262144 May 22 15:28 /bck_10158_1_880385316
-rw-rw---- oracle dba 262144 May 22 15:28 /bck_10157_1_880385316
-rw-rw---- oracle dba 1048576 May 22 15:28 /bck_10154_1_880385299
-rw-rw---- oracle dba 524288 May 22 15:28 /bck_10153_1_880385299
-rw-rw---- oracle dba 786432 May 22 15:28 /bck_10155_1_880385299
-rw-rw---- oracle dba 14155776 May 22 15:28 /arc01_8633_1_880385280
-rw-rw---- oracle dba 13631488 May 22 15:28 /arc01_7481_1_880385280
-rw-rw---- oracle dba 262144 May 22 15:27 /t8q7j77u_1_1
-rw-rw---- oracle dba 786432 May 22 15:27 /t7q7j77f_1_1
-rw-rw---- oracle dba 524288 May 22 15:27 /t6q7j77f_1_1
-rw-rw---- oracle dba 786432 May 22 15:27 /t5q7j77f_1_1
07-02-2015 03:17 AM
Sorry there is a mistake here
the backup file is bk_dTEST_u1bq7olp7 not as what is written above
Please let me know how I can check this backup images ? What commands to use?
Thanks
07-02-2015 03:19 AM
check with bplist command - see my previous post.
07-02-2015 03:45 AM
We need to check on the master server which CLIENT_NAME was used for the Oracle backups.
If you go to Host Properties -> Applications -> Oracle -> Instances, what do you see in Host column?
oratest.senyoritaag.com or oratest ?
Which username was used to register the instance?
oratest? oracle? Another oracle user?
How was restore initiated?
And how was backup image names determined in restore request?
PS :
You stopped responding over here? Restore from Oracle Intelligent Backup
07-02-2015 04:54 AM
Thanks Marianne for mentioning the other post
This issue has been solved
I'm sorry I totally forget about it
About what you're asking me I will gather this information and reply with it here
Thanks
07-02-2015 05:13 AM
Please find below the output of the bplist command
I really can't find this backup file in the list below
Why does it try to use this backup file if it's not there ?
Can I specify a cretain backup file one of the files below
# /usr/openv/netbackup/bin/bplist -B -C oratest.senyoritaag.com -R -l -t 4 -s 01/01/2015 /
-rw-rw---- oratest dba 42729472 Jun 27 13:19 /c-2119252968-20150627-02
-rw-rw---- oratest dba 42729472 Jun 27 13:19 /ctrl_dTEST_u3uqaht6n_s126_p1_t883487959
-rw-rw---- oratest dba 42729472 Jun 27 13:14 /c-2119252968-20150627-01
-rw-rw---- oratest dba 50993408K Jun 27 12:55 /arch_dTEST_u3sqahrpc_s124_p1_t883486508
-rw-rw---- oratest dba 54718464K Jun 27 12:45 /arch_dTEST_u3rqahr6f_s123_p1_t883485903
-rw-rw---- oratest dba 55555328K Jun 27 12:34 /arch_dTEST_u3qqahqj7_s122_p1_t883485287
-rw-rw---- oratest dba 55564032K Jun 27 12:24 /arch_dTEST_u3pqahq0k_s121_p1_t883484692
-rw-rw---- oratest dba 55582208K Jun 27 12:12 /arch_dTEST_u3oqahp9a_s120_p1_t883483946
-rw-rw---- oratest dba 55586560K Jun 27 12:12 /arch_dTEST_u3nqahp9a_s119_p1_t883483946
-rw-rw---- oratest dba 42729472 Jun 27 12:11 /c-2119252968-20150627-00
-rw-rw---- oratest dba 110502400K Jun 27 11:51 /bk_dTEST_u3lqaho1q_s117_p1_t883482682
-rw-rw---- oratest dba 107290880K Jun 27 11:31 /bk_dTEST_u3kqahmsn_s116_p1_t883481495
-rw-rw---- oratest dba 105237248K Jun 26 05:10 /bk_dTEST_u3jqaec6h_s115_p1_t883372241
-rw-rw---- oratest dba 42729472 Jun 15 17:51 /c-2119252968-20150615-03
-rw-rw---- oratest dba 42729472 Jun 15 17:51 /ctrl_dTEST_u36q9iol2_s102_p1_t882467490
-rw-rw---- oratest dba 42729472 Jun 15 17:46 /c-2119252968-20150615-02
-rw-rw---- oratest dba 58587904K Jun 15 17:24 /arch_dTEST_u34q9in2m_s100_p1_t882465878
-rw-rw---- oratest dba 60749824K Jun 15 17:13 /arch_dTEST_u33q9imdj_s99_p1_t882465203
-rw-rw---- oratest dba 61650176K Jun 15 16:59 /arch_dTEST_u32q9ilj5_s98_p1_t882464357
-rw-rw---- oratest dba 61673472K Jun 15 16:59 /arch_dTEST_u31q9ilj5_s97_p1_t882464357
-rw-rw---- oratest dba 42467328 Jun 15 16:55 /c-2119252968-20150615-01
-rw-rw---- oratest dba 110424576K Jun 15 16:35 /bk_dTEST_u2vq9ik7e_s95_p1_t882462958
-rw-rw---- oratest dba 107290880K Jun 15 16:11 /bk_dTEST_u2uq9iiq8_s94_p1_t882461512
-rw-rw---- oratest dba 105236992K Jun 15 15:50 /bk_dTEST_u2tq9ihho_s93_p1_t882460216
-rw-rw---- oratest dba 42467328 Jun 15 15:07 /c-2119252968-20150615-00
-rw-rw---- oratest dba 110424320K Jun 15 14:47 /bk_dTEST_u2rq9idrm_s91_p1_t882456438
-rw-rw---- oratest dba 107290880K Jun 15 14:27 /bk_dTEST_u2qq9icn7_s90_p1_t882455271
-rw-rw---- oratest dba 105236992K Jun 15 14:06 /bk_dTEST_u2pq9ibf1_s89_p1_t882453985
07-02-2015 05:15 AM
Please find below the output of bplist command
I really can;t find the backup file it's using
Why doesn't it choose one of those files ?
How can I specify it to use one of the already existing backup files
# /usr/openv/netbackup/bin/bplist -B -C oratest.senyoritaag.com -R -l -t 4 -s 01/01/2015 /
-rw-rw---- oratest dba 42729472 Jun 27 13:19 /c-2119252968-20150627-02
-rw-rw---- oratest dba 42729472 Jun 27 13:19 /ctrl_dTEST_u3uqaht6n_s126_p1_t883487959
-rw-rw---- oratest dba 42729472 Jun 27 13:14 /c-2119252968-20150627-01
-rw-rw---- oratest dba 50993408K Jun 27 12:55 /arch_dTEST_u3sqahrpc_s124_p1_t883486508
-rw-rw---- oratest dba 54718464K Jun 27 12:45 /arch_dTEST_u3rqahr6f_s123_p1_t883485903
-rw-rw---- oratest dba 55555328K Jun 27 12:34 /arch_dTEST_u3qqahqj7_s122_p1_t883485287
-rw-rw---- oratest dba 55564032K Jun 27 12:24 /arch_dTEST_u3pqahq0k_s121_p1_t883484692
-rw-rw---- oratest dba 55582208K Jun 27 12:12 /arch_dTEST_u3oqahp9a_s120_p1_t883483946
-rw-rw---- oratest dba 55586560K Jun 27 12:12 /arch_dTEST_u3nqahp9a_s119_p1_t883483946
-rw-rw---- oratest dba 42729472 Jun 27 12:11 /c-2119252968-20150627-00
-rw-rw---- oratest dba 110502400K Jun 27 11:51 /bk_dTEST_u3lqaho1q_s117_p1_t883482682
-rw-rw---- oratest dba 107290880K Jun 27 11:31 /bk_dTEST_u3kqahmsn_s116_p1_t883481495
-rw-rw---- oratest dba 105237248K Jun 26 05:10 /bk_dTEST_u3jqaec6h_s115_p1_t883372241
-rw-rw---- oratest dba 42729472 Jun 15 17:51 /c-2119252968-20150615-03
-rw-rw---- oratest dba 42729472 Jun 15 17:51 /ctrl_dTEST_u36q9iol2_s102_p1_t882467490
-rw-rw---- oratest dba 42729472 Jun 15 17:46 /c-2119252968-20150615-02
-rw-rw---- oratest dba 58587904K Jun 15 17:24 /arch_dTEST_u34q9in2m_s100_p1_t882465878
-rw-rw---- oratest dba 60749824K Jun 15 17:13 /arch_dTEST_u33q9imdj_s99_p1_t882465203
-rw-rw---- oratest dba 61650176K Jun 15 16:59 /arch_dTEST_u32q9ilj5_s98_p1_t882464357
-rw-rw---- oratest dba 61673472K Jun 15 16:59 /arch_dTEST_u31q9ilj5_s97_p1_t882464357
-rw-rw---- oratest dba 42467328 Jun 15 16:55 /c-2119252968-20150615-01
-rw-rw---- oratest dba 110424576K Jun 15 16:35 /bk_dTEST_u2vq9ik7e_s95_p1_t882462958
-rw-rw---- oratest dba 107290880K Jun 15 16:11 /bk_dTEST_u2uq9iiq8_s94_p1_t882461512
-rw-rw---- oratest dba 105236992K Jun 15 15:50 /bk_dTEST_u2tq9ihho_s93_p1_t882460216
-rw-rw---- oratest dba 42467328 Jun 15 15:07 /c-2119252968-20150615-00
-rw-rw---- oratest dba 110424320K Jun 15 14:47 /bk_dTEST_u2rq9idrm_s91_p1_t882456438
-rw-rw---- oratest dba 107290880K Jun 15 14:27 /bk_dTEST_u2qq9icn7_s90_p1_t882455271
-rw-rw---- oratest dba 105236992K Jun 15 14:06 /bk_dTEST_u2pq9ibf1_s89_p1_t882453985
07-02-2015 05:27 AM
Do not post bulk data like this. Attach as a file to a post please.
If its not in the list, it does not exists and that why you are seeing a error.
In order for RMAN to work correctly it need to be synchronized with Netbackup. You do that with the RMAN
as follows from http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint002.htm
RUN { ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt; CROSSCHECK BACKUP; }
As you can see this we are moving away from Netbackup and into the DBA world. If possible team up with a DBA.
07-02-2015 05:33 AM
client name is
oratest.senyoritaag.com
I used a username (bkp) which has the same sys previliges
About the restore initiation I just use the default options
Please find below the output of bplist command
I really can;t find the backup file it's using
Why doesn't it choose one of those files ?
How can I specify it to use one of the already existing backup files
# /usr/openv/netbackup/bin/bplist -B -C oratest.senyoritaag.com -R -l -t 4 -s 01/01/2015 /
-rw-rw---- oratest dba 42729472 Jun 27 13:19 /c-2119252968-20150627-02
-rw-rw---- oratest dba 42729472 Jun 27 13:19 /ctrl_dTEST_u3uqaht6n_s126_p1_t883487959
-rw-rw---- oratest dba 42729472 Jun 27 13:14 /c-2119252968-20150627-01
-rw-rw---- oratest dba 50993408K Jun 27 12:55 /arch_dTEST_u3sqahrpc_s124_p1_t883486508
-rw-rw---- oratest dba 54718464K Jun 27 12:45 /arch_dTEST_u3rqahr6f_s123_p1_t883485903
-rw-rw---- oratest dba 55555328K Jun 27 12:34 /arch_dTEST_u3qqahqj7_s122_p1_t883485287
-rw-rw---- oratest dba 55564032K Jun 27 12:24 /arch_dTEST_u3pqahq0k_s121_p1_t883484692
-rw-rw---- oratest dba 55582208K Jun 27 12:12 /arch_dTEST_u3oqahp9a_s120_p1_t883483946
-rw-rw---- oratest dba 55586560K Jun 27 12:12 /arch_dTEST_u3nqahp9a_s119_p1_t883483946
-rw-rw---- oratest dba 42729472 Jun 27 12:11 /c-2119252968-20150627-00
-rw-rw---- oratest dba 110502400K Jun 27 11:51 /bk_dTEST_u3lqaho1q_s117_p1_t883482682
-rw-rw---- oratest dba 107290880K Jun 27 11:31 /bk_dTEST_u3kqahmsn_s116_p1_t883481495
-rw-rw---- oratest dba 105237248K Jun 26 05:10 /bk_dTEST_u3jqaec6h_s115_p1_t883372241
-rw-rw---- oratest dba 42729472 Jun 15 17:51 /c-2119252968-20150615-03
-rw-rw---- oratest dba 42729472 Jun 15 17:51 /ctrl_dTEST_u36q9iol2_s102_p1_t882467490
-rw-rw---- oratest dba 42729472 Jun 15 17:46 /c-2119252968-20150615-02
-rw-rw---- oratest dba 58587904K Jun 15 17:24 /arch_dTEST_u34q9in2m_s100_p1_t882465878
-rw-rw---- oratest dba 60749824K Jun 15 17:13 /arch_dTEST_u33q9imdj_s99_p1_t882465203
-rw-rw---- oratest dba 61650176K Jun 15 16:59 /arch_dTEST_u32q9ilj5_s98_p1_t882464357
-rw-rw---- oratest dba 61673472K Jun 15 16:59 /arch_dTEST_u31q9ilj5_s97_p1_t882464357
-rw-rw---- oratest dba 42467328 Jun 15 16:55 /c-2119252968-20150615-01
-rw-rw---- oratest dba 110424576K Jun 15 16:35 /bk_dTEST_u2vq9ik7e_s95_p1_t882462958
-rw-rw---- oratest dba 107290880K Jun 15 16:11 /bk_dTEST_u2uq9iiq8_s94_p1_t882461512
-rw-rw---- oratest dba 105236992K Jun 15 15:50 /bk_dTEST_u2tq9ihho_s93_p1_t882460216
-rw-rw---- oratest dba 42467328 Jun 15 15:07 /c-2119252968-20150615-00
-rw-rw---- oratest dba 110424320K Jun 15 14:47 /bk_dTEST_u2rq9idrm_s91_p1_t882456438
-rw-rw---- oratest dba 107290880K Jun 15 14:27 /bk_dTEST_u2qq9icn7_s90_p1_t882455271
-rw-rw---- oratest dba 105236992K Jun 15 14:06 /bk_dTEST_u2pq9ibf1_s89_p1_t882453985
07-02-2015 05:37 AM
Plese do not attach bulk text, all youre post are being held back by Connect anti spam system.
07-17-2015 05:12 PM
Thanks Nicolai for your answer which guided me to the solution of this problem I have
I found that backups in the netbackup catalog weren't found in the RMAN Catalog
so I checked with the database engineer who helped me to catalog the backup pieces I found using the command given by Nicolai and added them to the rman catalog and remove all the old backup pieces and restarted the restore operation
I need to clarify why that happened
Obviously the customer wanted to test the restore scenario so he deleted all the database including even the control file , the archive logs , the redo logs,the datafiles
everything and I knew from the DBA that the backup pieces is recorded in the control file so when everything was deleted the rman catalog and everything was affected
Then the customer used an old manual backup to restore from which had an old control file which contained record of old RMAN backups
This will make me further on to always have a cold offline backup to always have a copy of the control file and SPFiles somewhere else on the tape
I will not only take hot database backup
Thanks for all your efforts and replies which guided me to find the solution