cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Prod Backup Fails

Adminz
Level 3

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.data12122

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

13 REPLIES 13

Nicolai
Moderator
Moderator
Partner    VIP   

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.

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

Nicolai
Moderator
Moderator
Partner    VIP   

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.

Nicolai
Moderator
Moderator
Partner    VIP   

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

Hi Nicolai,


Thank you for your reply,

 

No workaround for this issue ?

 

Regards

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

 

 

Hi,

 

No Way ?


Regards

Nicolai
Moderator
Moderator
Partner    VIP   

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.

 

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

Systems_Team
Moderator
Moderator
   VIP   

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:

  • 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.
  • You need to consult a dba on how to re-name the database files, likely the database need to be taken offline.

Hope this helps,

Steve

 

Dears,

How can i copy this file under OS level or rename it ?

Thank You

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Have you seen this in the previous post?

"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. "

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