11-24-2017 05:44 AM
Hi,
We have Netbackup 7.7.1, And SAP with Oracle DB on AIX,
We have created new DB tablespace using oracle brtools and created with wrong special characters as below:
# ls -al
-rw-r----- 1 oraprd dba 32212262912 Nov 24 16:32 sr3.data122
# ls -al | od -c
0000000 t o t a l 6 2 9 1 5 2 7 2 \n d
0000020 r w x r - x r - x 2 o
0000040 r a p r d d b a
0000060 2 5 6 N o v
0000100 1 0 1 4 : 5 6 . \n d r w x r
0000120 - x r - x 2 0 o r a p r
0000140 d s y s t e m
0000160 4 0 9 6 N o v 1 0 1
0000200 4 : 5 3 . . \n - r w - r - - -
0000220 - - 1 o r a p r d
0000240 d b a 3 2 2 1 2 2
0000260 6 2 9 1 2 N o v 2 4 1 6 :
0000300 3 0 s r 3 . d a t a 1 2 1 177 2
0000320 033 [ D 033 [ D 033 [ D 033 [ D 033 [ D 033
0000340 [ D 033 [ D 033 [ D 033 [ D 033 [ D 033 [
0000360 D 033 [ D 177 2 033 [ C 033 [ C 033 [ C 033
0000400 [ C 033 [ C 033 [ C 033 [ C 033 [ C 033 [
0000420 C 033 [ C 033 [ C 033 [ C \n
0000433
And we've got this error on Netbackup logs
On the file list:
oracle/PRD/sapdata5/sr3_124/sr3.data1212[D[D[D[D[D[D[D[D[D[D[D[D2[C[C[C[C[C[C[C[C[C[C[C[C
On the Detailed status:
Info bpbrm (pid=282345) sapprd1 is the host to backup data from
Info bpbrm (pid=282345) listening for client connection
Info bpbrm (pid=282345) INF - Client read timeout = 7200
Info bpbrm (pid=282345) accepted connection from client
Info bpbrm (pid=282345) start bpbkar on client
Info dbclient (pid=0) Backup started
Info dbclient (pid=0) Backup started
Info bpbrm (pid=282345) bptm pid: 282351
Critical bpbrm (pid=282345) from client sapprd1: FTL - terminated by signal 4
Info dbclient (pid=0) done. status: 130
Info dbclient (pid=0) done. status: 150: termination requested by administrator
Error bpbrm (pid=282345) could not write EXIT STATUS to database client
Info dbclient (pid=0) done. status: 130: system error occurred
Info nbjm (pid=28144) starting backup job (jobid=168092) for client sapprd1, policy sapprd_sap, schedule Default-Application-Backup
Info nbjm (pid=28144) requesting STANDARD_RESOURCE resources from RB for backup job (jobid=168092, request id:{3CE1B9AB-FB69-4DFD-BE48-DF70AB570D59})
requesting resource STU_Disk
requesting resource nbu.NBU_CLIENT.MAXJOBS.sapprd1
requesting resource nbu.NBU_POLICY.MAXJOBS.sapprd_sap
granted resource nbu.NBU_CLIENT.MAXJOBS.sapprd1
granted resource bu.NBU_POLICY.MAXJOBS.sapprd_sap
granted resource MediaID=@aaaab;DiskVolume=PureDiskVolume;DiskPool=dp_disk_nbuapp;Path=PureDiskVolume;StorageServer=nbuapp;MediaServer=nbuapp
granted resource STU_Disk
estimated 0 kbytes needed
Info nbjm (pid=28144) started backup (backupid=sapprd1_1511527947) job for client sapprd1, policy sapprd_sap, schedule Default-Application-Backup on storage unit STU_Disk
started process bpbrm (pid=282345)
connecting
connected; connect time: 0:00:00
end writing
system error occurred (130)
---------------------------------------------------------------
And on the /usr/openv/netbackup/logs/bpbkar logs:
bpbkar: INF - BACKUP START
bpbkar: INF - Estimate:-1 -1
bpbkar add_to_filelist: starting sizeof(filelistrec) <128>
bpbkar: /
bpbkar: /PROXY_BACKUP
bpbkar: INF - Processing /oracle/PRD/sapdata5/sr3_124/sr3.data121^?2^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[
D^[[D^?2^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C
glob: Missing ']' in filelist name
bpbkar: FTL - terminated by signal 4
bpbkar: ERR - bpbkar FATAL exit status = 130: system error occurred
bpbkar: INF - EXIT STATUS 130: system error occurred
bpbkar: INF - setenv FINISHED=0
-------------------------------------------------
bp.conf
SERVER = nbu
SERVER = nbuapp
SERVER = backup
CLIENT_NAME = PROD
VeRBOSE = 5
I've tried:
LOCKED_FILE_ACTION = SKIP
IGNORE_XATTR = YES
Could anyone help me please ?
Thank You
11-24-2017 06:48 AM - edited 11-24-2017 07:37 AM
Uhh, seen that before.
Control character in file names are usually the result of using a GUI where character can be invisible. The invisible character does not go along with either rman, brtools. I have even seen table space files with a space in the end of the file name - that was hard nut to debug on.
The fix is to take the database down and perform a rename of the database filer - structured so the database doesn't loose a stable space file. I had DBA do this in my shop.
11-24-2017 07:08 AM
Hi Nicolai,
Thank you for your reply and your help,
Is there any way or workaround to run the backup ?
And do you know how can we rename these tablespace without affecting the DB Production ?
Regards
11-24-2017 07:36 AM
I never manged to get the backup to work with special character in the file name.
You need to consult a dba on how to re-name the database files, likely the database need to be taken offline.
11-24-2017 07:49 AM
bpbkar does not parse the invalid file name. Even if the backup did work, the control sequences in the file name could have unawated side effect when restoring.
bpbkar: INF - Processing /oracle/PRD/sapdata5/sr3_124/sr3.data121^?2^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[D^[[
D^[[D^?2^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C^[[C
glob: Missing ']' in filelist name
11-24-2017 09:19 PM
Hi Nicolai,
Thank you for your reply,
No workaround for this issue ?
Regards
11-24-2017 11:41 PM
Hi,
I took successful file System Backup from Netbackup as standard policy,
But still i couldn't take backup as SAP policy,
And DB team wanted to take full DB backup first.
Please find attached screenshot
Thank You
11-26-2017 08:48 AM
Hi,
No Way ?
Regards
11-27-2017 12:25 AM
The backup you made with the standard policy is useless. A database need to be consistent, RMAN or Brtools ensure that.
The only way a backup of a database can be consistent is if the database is shutdown, this backup can't be seen from either RMAN or Brtools.
11-27-2017 01:15 PM
Hi,
Thank you for your help,
How can we copy this file or rename it under os level ?
Because with ls -l command the special characters not showing.
Regards
11-27-2017 07:49 PM - edited 11-27-2017 07:50 PM
Hi Adminz,
This has absolutely nothing to do with O/S level (or NetBackup for that matter). It is an Oracle database issue, and you need an Oracle DBA to fix it for you. Once that is done, you'll be able to get a consistent database backup.
Nicolai has already explained at least twice what you need to do:
Hope this helps,
Steve
11-28-2017 05:19 AM
Dears,
How can i copy this file under OS level or rename it ?
Thank You
11-28-2017 05:25 AM
11-28-2017 06:49 AM
Thank you all for your help,
I just wanted to rename or copy this files just asking how can i do this
Not for DB FS but normal files under os level with special characters how can i do it ?
Regards