cancel
Showing results for 
Search instead for 
Did you mean: 

RMAN restore backup piece not found

mohammad_yaseen
Level 4

Dear All,

 

Kindly note our DBA team is trying to refresh the preproduction environment from the production and they are using RMAN for restore, the try to test the restore and got the error below, noting that the prodution NB client is 7.5 and pre is 7.7.1, in the attachment you can find dbclient logs and bpcd, and we are sure the backup piece is existed, and I've check all the hosts have been added on /etc/hosts

ERROR:

channel t1: starting datafile backup set restore

channel t1: restoring control file

channel t1: reading from backup piece c-37172765-20171205-01

channel t1: ORA-19870: error while restoring backup piece c-37172765-20171205-01

ORA-19507: failed to retrieve sequential file, handle="c-37172765-20171205-01", parms=""

ORA-27029: skgfrtrv: sbtrestore returned error

ORA-19511: Error received from media manager layer, error text:

   Backup file <c-37172765-20171205-01> not found in NetBackup catalog

Thanks

13 REPLIES 13

quebek
Moderator
Moderator
   VIP    Certified

Redirected restore? Looks like your rman needs to provide who's backups it should browse/restore from.

Also do not forget to create No.Restrictions file in /usr/openv/netbackup/db/altnames - in order to allow for redirected restores on master server...

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Please run this command on the Oracle client where you are attempting the restore:

bplist -t 4  -C <source-client> -R /

If there is something wrong with redirected restore permissions and/or configuration, then above command will fail (probably a permission-related error or 227).

Hi @Marianne

The command worked properly, but i forget one thing the backup user is: oracle and the restore user is : orauat3

@Marianne

The error below appeared on master server

root@mcmp:/>bplist -t 4  -C PREGERPDB -R /
EXIT STATUS 227: no entity was found

 

I think it's normal since it's the destination server


@mohammad_yaseen wrote:

Hi @Marianne

The command worked properly, but i forget one thing the backup user is: oracle and the restore user is : orauat3


many times they would say the restore should be the same as the backup user. but in our experience doesn't have to be.


@mohammad_yaseen wrote:

@Marianne

The error below appeared on master server

root@mcmp:/>bplist -t 4  -C PREGERPDB -R /
EXIT STATUS 227: no entity was found

 

I think it's normal since it's the destination server


are you issuing the restore command from the destination client? the above should show a list. are your date inclusions for the restore correct?

@manatee

Hi

I can run the bplist command from both destination and master servers properly

Hi,

 

Below you can find part of bprd logs on master server:

 

15:18:10.539 [5683.1] <2> fileslist: client = PREGERPDB
15:18:10.540 [5683.1] <2> fileslist: query.fl_peername = PREGERPDB
15:18:10.831 [5683.1] <2> bprd: /usr/openv/netbackup/bin/userreq_notify list PREGERPDB orauat3
15:18:10.859 [5691.1] <2> connected_peer: Connection from host PREGERPDB, 192.168.199.157, on non-reserved port 57414
15:18:10.878 [5691.1] <2> db_valid_master_server: PREGERPDB is not a valid server
15:18:10.880 [5691.1] <2> process_request: list request = 329199 207 orauat3 dba PREGERPDB PREGERPDB PREGERPDB *NULL* NONE 0  3 999 1496754847 1499433247 4 4 1 1 1 0 4 106 101 4 0 C C C C C 0 2 0 0 0 256
15:18:10.884 [5691.1] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1733] in failed file cache ERR=8 NAME=PREGERPDB.jt.jtgroup SVC=NULL
15:18:10.884 [5691.1] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3020] vnet_cached_getaddrinfo() failed STAT=6 RV=8 NAME2=PREGERPDB.jt.jtgroup
15:18:10.896 [5691.1] <2> fileslist: client = PREGERPDB
15:18:10.897 [5691.1] <2> fileslist: query.fl_peername = PREGERPDB
15:18:11.341 [5691.1] <2> bprd: /usr/openv/netbackup/bin/userreq_notify list PREGERPDB orauat3
15:18:11.366 [5705.1] <2> connected_peer: Connection from host PREGERPDB, 192.168.199.157, on non-reserved port 57436
15:18:11.380 [5705.1] <2> db_valid_master_server: PREGERPDB is not a valid server
15:18:11.381 [5705.1] <2> process_request: list request = 329199 207 orauat3 dba PREGERPDB PREGERPDB PREGERPDB *NULL* NONE 0  3 999 819936000 1496754847 4 4 1 1 1 0 4 106 101 4 0 C C C C C 0 2 0 0 0 256
15:18:11.384 [5705.1] <8> vnet_cached_getaddrinfo_and_update: [vnet_addrinfo.c:1733] in failed file cache ERR=8 NAME=PREGERPDB.jt.jtgroup SVC=NULL
15:18:11.384 [5705.1] <8> vnet_same_host_and_update: [vnet_addrinfo.c:3020] vnet_cached_getaddrinfo() failed STAT=6 RV=8 NAME2=PREGERPDB.jt.jtgroup
15:18:11.394 [5705.1] <2> fileslist: client = PREGERPDB
15:18:11.395 [5705.1] <2> fileslist: query.fl_peername = PREGERPDB
15:18:11.636 [5705.1] <2> bprd: /usr/openv/netbackup/bin/userreq_notify list PREGERPDB orauat3
15:18:15.087 [5730.1] <2> process_request: log_job_info request = 329199 148 11422989 dbclient 2920 300 INF - BACKUP STARTED USING Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)  Apr  2 2010 15:48:46  Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)  Batch = C:\Program Files\Veritas\NetBackup\DbExt\MsSql\sqllog.bch, Op# = 27

Lowell_Palecek
Level 6
Employee

I created an error like this by accident in my testing yesterday. As an Oracle / RMAN novice, I expired a backup image in NetBackup and expected RMAN to restore the previous image. RMAN thought the newer image still existed and tried to restore it.

There is advice in the NetBackup for Oracle Admin Guide regarding managing the RMAN Repository and coordinating it with the NetBackup catalog. Here is a snippet from the 8.0 version of the guide:

Because NetBackup can expire images independently from Oracle, the RMAN repository
can contain outdated information. Run an RMAN crosscheck to ensure that data in the
recovery catalog or control file is in sync with data in the backup image catalog. The
crosscheck queries NetBackup for the existence of each backup piece and then marks it
as available or expired in the RMAN repository.

I don't know whether this applies to your situation. As I said, I'm a novice in this area.

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello Mohammad,

i am confused from your answers. Once you say bplist is working, once you show us 227 error. Once you are talking about destination, once about source client.

What about these commands, launched on the Master, do they show any rows (backups) or give 227 error?

bplist -t 4 -C <source client> -R \

or

bplist -t 4 -C <source client> -R c-37172765-20171205-01

or maybe:

bplist -t 4 -C <source client> -R c-37172765-20171205-01:\

Regards

Michal

Hi @Michal_Mikulik1

The results from the master server are as below:

bplist -t 4 -C <source client> -R / --> Successfully run and return data

bplist -t 4 -C <source client> -R c-37172765-20171205-01 --> failed with error "EXIT STATUS 227: no entity was found"

bplist -t 4 -C GERPDB -R c-37172765-20171205-01:/ --> failed with error "EXIT STATUS 227: no entity was found"

Thanks

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@mohammad_yaseen

I echo @Michal_Mikulik1's confusion.

Which machine is PREGERPDB?
The destination machine?
If so, it means that no backups exist for PREGERPDB and that will explain the status 227.

You have also showed us a snippet of bprd log that does not contain any error(s). That does not help at all. We need all the entries that represents a list or restore request from the destination client for Oracle backup on source client.

We need you to run this on the destination client (PREGERPDB ?): 

bplist -t 4  -C <source-client>  -R /

About the different username on destination client :
See this section in NBU Admin Guide for Oracle:  

BKUP_IMAGE_PERM
Lets you set the permissions on a backup image at backup time.
Possible values are the following:
USER - set the permissions to 600. Only the original user who backed up the data has access to the backup images.
GROUP - set the permissions to 660. Anyone from the same group as the original user who backed up the data has access to the backup images.
ANY - set the permissions to 664. Anyone has access to the backup images.
If this keyword is not specified, the permissions default to 660.
To specify this keyword, use the send command to set the variable.
For example: SEND 'BKUP_IMAGE_PERM=ANY';
Note: The BKUP_IMAGE_PERM option does not affect the permissions for the physical files that are included in an RMAN Proxy copy backup.
Ensure the physical file owner, group, and permissions are set correctly before the backup.

 

Sujay24
Level 4
Employee

Browse the Oracle backups by running below command on destination machine:-

/usr/openv/netbackup/bin/bplist -C <Oracle source client name> -t 4 -l -R /

Below is the technote of alternate client restore:-

https://www.veritas.com/support/en_US/article.000065979