Oracle Intelligent Policy restore failure

[Mahmoud_Moussa]

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 

[Nicolai · Accepted solution]

You are requesting a IMAGE not found in the Netbackup catalog 

Backup file <c-1454518342-20110713-01> not found in NetBackup catalog

• Ensure you specify the right client name
• Ensure the oracle backup you request actual exist (typos ??).

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

[Mahmoud_Moussa]

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

[Nicolai]

check with bplist command - see my previous post.

[Marianne]

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 

[Mahmoud_Moussa]

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

[Mahmoud_Moussa]

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

[Mahmoud_Moussa]

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

[Nicolai]

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.

[Mahmoud_Moussa]

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

[Nicolai]

See my previous post.

Plese do not attach bulk text, all youre post are being held back by Connect anti spam system.

[Mahmoud_Moussa]

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