11-22-2016 06:11 AM
Hi Friends,
While restoring the rman database flat file backup from one server to another server the backup gets failed with error code 2850.
Please help me what would be the reason ?
Kindly find the logs.
11/22/2016 19:09:06 - begin Restore
11/22/2016 19:09:07 - Info bprd (pid=17855) Found (57,961) files in (4) images for Restore Job ID 63539.xxx
11/22/2016 19:09:07 - number of images required: 2
11/22/2016 19:09:07 - media needed: 0011
11/22/2016 19:09:07 - media needed: 0012
11/22/2016 19:09:37 - restoring from image Sourceclientname_1479324803
11/22/2016 19:09:38 - Info bpbrm (pid=17903) Destinationclinetnameis the host to restore to
11/22/2016 19:09:38 - Info bpbrm (pid=17903) telling media manager to start restore on client
11/22/2016 19:09:38 - Info bpbrm (pid=17903) spawning a brm child process
11/22/2016 19:09:38 - Info bpbrm (pid=17903) child pid: 17913
11/22/2016 19:09:38 - connecting
11/22/2016 19:09:38 - Info bptm (pid=17905) Waiting for mount of media id 0011 (copy 1) on server Master server.
11/22/2016 19:09:38 - started process bptm (pid=17905)
11/22/2016 19:09:38 - mounting 0011
11/22/2016 19:09:38 - Info bptm (pid=17905) INF - Waiting for mount of media id 0011 on server Master server for reading.
11/22/2016 19:09:38 - requesting resource 0011
11/22/2016 19:09:38 - granted resource 0011
11/22/2016 19:09:38 - granted resource HPMSLD3
11/22/2016 19:09:39 - Info bpbrm (pid=17913) start tar on client
11/22/2016 19:09:39 - Info tar (pid=5243232) Restore started.
11/22/2016 19:09:39 - connected; connect time: 0:00:00
11/22/2016 19:10:44 - mounted 0011; mount time: 0:01:06
11/22/2016 19:10:44 - Info bptm (pid=17905) 0011
11/22/2016 19:10:44 - Info bptm (pid=17905) INF - Waiting for positioning of media id 0011 on server Master server for reading.
11/22/2016 19:10:44 - positioning 0011 to file 95
11/22/2016 19:11:16 - positioned 0011; position time: 0:00:32
11/22/2016 19:11:16 - begin reading
11/22/2016 19:11:29 - Error bptm (pid=17905) VBRT 1 17905 4 1 HPMSLD3 0011 0 1 0 586790 2719526
11/22/2016 19:11:29 - Info tar (pid=5243232) done. status: 0
11/22/2016 19:11:29 - end reading; read time: 0:00:13
11/22/2016 19:11:29 - Info bpbrm (pid=17903) media manager for backup id Sourceclientname_1479324803 exited with status 0: the requested operation was successfully completed
11/22/2016 19:11:29 - Info tar (pid=5243232) done. status: 5 - the restore failed to recover the requested files
11/22/2016 19:11:29 - restored from image Sourceclientname_1479324803; restore time: 0:01:52
11/22/2016 19:11:29 - restoring from image Sourceclientname_1479411265
11/22/2016 19:11:30 - Info bpbrm (pid=6660) Destinationclinetnameis the host to restore to
11/22/2016 19:11:30 - Info bpbrm (pid=6660) telling media manager to start restore on client
11/22/2016 19:11:31 - Info bpbrm (pid=6660) spawning a brm child process
11/22/2016 19:11:31 - Info bpbrm (pid=6660) child pid: 6664
11/22/2016 19:11:31 - connecting
11/22/2016 19:11:31 - requesting resource 0012
11/22/2016 19:11:31 - Waiting for scan drive stop HPMSLD1, Media server: NVMBD2ACD050D00
11/22/2016 19:11:32 - Info bpbrm (pid=6664) start tar on client
11/22/2016 19:11:32 - Info tar (pid=5374286) Restore started.
11/22/2016 19:11:32 - connected; connect time: 0:00:00
11/22/2016 19:12:02 - Info bptm (pid=6662) Waiting for mount of media id 0012 (copy 1) on server NVMBD2ACD050D00.
11/22/2016 19:12:02 - started process bptm (pid=6662)
11/22/2016 19:12:02 - mounting 0012
11/22/2016 19:12:02 - Info bptm (pid=6662) INF - Waiting for mount of media id 0012 on server NVMBD2ACD050D00 for reading.
11/22/2016 19:12:02 - granted resource 0012
11/22/2016 19:12:02 - granted resource HPMSLD1
11/22/2016 19:13:09 - mounted 0012; mount time: 0:01:07
11/22/2016 19:13:09 - Info bptm (pid=6662) 0012
11/22/2016 19:13:09 - Info bptm (pid=6662) INF - Waiting for positioning of media id 0012 on server NVMBD2ACD050D00 for reading.
11/22/2016 19:13:09 - positioning 0012 to file 344
11/22/2016 19:13:36 - positioned 0012; position time: 0:00:27
11/22/2016 19:13:36 - begin reading
11/22/2016 19:17:51 - positioning 0012 to file 345
11/22/2016 19:17:51 - positioned 0012; position time: 0:00:00
11/22/2016 19:30:10 - positioning 0012 to file 346
11/22/2016 19:30:10 - positioned 0012; position time: 0:00:00
11/22/2016 19:30:30 - end reading; read time: 0:16:54
11/22/2016 19:30:30 - Info tar (pid=5374286) done. status: 0
11/22/2016 19:30:30 - Info bpbrm (pid=6660) media manager for backup id Sourceclientname_1479411265 exited with status 0: the requested operation was successfully completed
11/22/2016 19:30:30 - Info tar (pid=5374286) done. status: 5 - the restore failed to recover the requested files
11/22/2016 19:30:30 - restored from image Sourceclientname_1479411265; restore time: 0:19:01
11/22/2016 19:30:30 - Warning bprd (pid=17855) Restore must be resumed prior to first image expiration on Thu 24 Nov 2016 01:03:23 AM IST
11/22/2016 19:30:30 - end Restore; elapsed time 0:21:24
Restore error (2850)
Solved! Go to Solution.
11-22-2016 10:15 AM
11-22-2016 06:26 AM
Do you have the restore progress file? There is sometimes more info here than in Activity Monitor.
tar process on the destination client as well as bptm on master/media server reported failure.
You need to check these logs as a start:
tar on the client.
bptm on master/media server.
If log folders do not exist, create it under /usr/openv/netbackup/logs and retry the restore.
Create these log folders as well:
bpbrm on master/media
bprd on master (NBU must be restarted to enable this log)
11-22-2016 06:47 AM
rogress log filename : /usr/openv/netbackup/logs/user_ops/ip/logs/jbp-07781479821946534110000000049-EGN6CY.log Restore Job Id=63539
Restore started 11/22/2016 19:09:06
19:30:30 (63539.002) Changed /Backup/rman_bkp/17-11-2016/spfile_abcd_9657_20161117_dbid227919520.ora to /backup/netbackup_restore/abc/spfile_abcd_9657_20161117_dbid227919520.ora
19:30:30 (63539.002) VX_SETEXT failed for /backup/netbackup_restore/ctx/spfile_abcd_9657_20161117_dbid227919520.ora - VxFS Extent Attributes not set. Errno = 25: A specified file does not support the ioctl system call.
19:30:30 (63539.002) INF - TAR EXITING WITH STATUS = 0
19:30:30 (63539.002) INF - TAR RESTORED 1 OF 18 FILES SUCCESSFULLY
19:30:30 (63539.002) INF - TAR KEPT 0 EXISTING FILES
19:30:30 (63539.002) INF - TAR PARTIALLY RESTORED 0 FILES
19:30:30 (63539.002) Status of restore from copy 1 of image created Fri 18 Nov 2016 01:04:25 AM IST = the restore failed to recover the requested files
19:30:30 (63539.xxx) INF - Status = Restore error.
11-22-2016 06:55 AM
VX_SETEXT failed for /backup/netbackup_restore/ctx/spfile_abcd_9657_201
What is the filesystem on the source client?
And to which filesystem type are you restoring?
Seems destination filesystem cannot write the file with the required filesystem attributes.
11-22-2016 06:58 AM
11-22-2016 07:35 AM
What is the filesystem on the source client? JFS OR JFS2
And to which filesystem type are you restoring? JFS OR JFS2
Seems destination filesystem cannot write the file with the required filesystem attributes.
Restoration is completed as per DB team. they are able restore the RMAN database.
11-22-2016 08:52 AM
Hello Vinayak,
I think your target client is mounted with ioctl option which causing problem.
You can check the ioctl flag enabled or not on client using 'mount' command.
If yes then umount the filesystem and mount again without ioctl option and then try to restore.
Also check the filesystem type and ACL permission using getacl <mountpoint> command.
There are lots of compatibility issues with AIX filesystem. Please refer the NBU SCL guide for more information.
Thanks & Regards,
11-22-2016 10:15 AM
11-22-2016 08:56 PM
Hi Marianne,
Yes the source is VxFS and destination is JFS or JFS2.
Due to which the restoration is getting completed but getting failed with error 2850.
Thanks for your support.
regards,
Vinayak Chennuri