Backup Oracle 11 + Symantec Netbackup - ORA-19665

Hello,

I`m trying to run backup in a Oracle 11 database with util_file + backint to Symantec Netbackup. Apparently backup runs succesfully but it finally get the error:

BR0278E Command output of 'G:\oracle\XXX\11203\BIN\rman nocatalog':

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Oct 13 10:54:07 2014

RMAN>

RMAN> connect target *

connected to target database: XXX (DBID=1667440742)

using target database control file instead of recovery catalog

RMAN> **end-of-file**

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of catalog command on default channel at 10/13/2014 10:54:08

ORA-19665: size 931840 in file header does not match actual file size of 786437

ORA-19664: file type: datafile copy, file name: J:\ORACLE\XXX\SAPBACKUP\BEOYMNCZ.SPA\ACD.D

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2014-10-13 10.54.08

BR0279E Return code from 'G:\oracle\XXX\11203\BIN\rman nocatalog': 1

BR0536E RMAN call for database instance XXX failed

BR0280I BRBACKUP time stamp: 2014-10-13 10.54.08

BR0532E Cataloging backups of all database files failed

None of the tablespaces/datafiles is running in autoextend mode, and the database is running fine & online. Why I get this error? How can I match real size with file header size?

Thanks in advance.

Pablo.

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi Pablo,


RMAN-03009: failure of catalog command on default channel at 10/13/2014 10:54:08
ORA-19665: size 931840 in file header does not match actual file size of 786437
ORA-19664: file type: datafile copy, file name: J:\ORACLE\XXX\SAPBACKUP\BEOYMNCZ.SPA\ACD.D

Could you check you have enough space in SAPBACKUP directory ??

Also share details from alert_<SID>.log file for more details on the error.

Regards,

Deepak Kori

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Deepak,

Yes, I don´t have enough free space in sapbackup dir, but I´m using util_file, with an external tool/external disk, why is the backup copying to local disk?

The policy of the util_file says to copy to remote disk, but sapbackup dir is local. Or is sapbackup a temp directory while the copy is running??

Thanks,

Pablo.

Hi Pablo,

You may need to check the init<SID>.sap file where the backup location is configured.

ideally logs are stored under sapbackup directory.

You may move some old files/folders to another drive for the time being and execute the backup.

Hope this helps.

Regards,

Deepak Kori

Hi,

I have release some space in affected drive and I still have the same problem. Here is the complete log:

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Detailliertes Protokoll: beoysmyk.fnf

BR0051I BRBACKUP 7.00 (16)

BR0055I Start of database backup: beoysmyk.fnf 2014-10-14 15.55.06

BR0101I Parameters

Name Value

oracle_sid XXX

oracle_home G:\oracle\XXX\11203

oracle_profile G:\oracle\XXX\11203\database\initXXX.ora

sapdata_home J:\oracle\XXX

sap_profile G:\oracle\XXX\11203\database\initXXX.sap

backup_mode FULL

backup_type online

backup_dev_type util_file

util_par_file G:\oracle\XXX\11203\database\initXXX.utl

system_info XXXadm ACDCPDQSBW101 Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info XXX 11.2.0.3.0 8192 5627 1460197702 ACDCPDQSBW101 WE8DEC UTF8

sap_info 640 SAPACC XXX G0033705873 R3_ORA 0020202550

make_info NTAMD64 OCI_10201_SHARE Aug 22 2006

command_line brbackup -u system/************ -c force -d util_file -p G:\oracle\XXX\11203\database\initXXX.sap -t online -m full -a -c force

BR0116I ARCHIVE LOG LIST before backup for database instance XXX

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination I:\oracle\XXX\XXXArch

Archive format ARC%S_%R.%T

Oldest online log sequence 5624

Next log sequence to archive 5627

Current log sequence 5627 SCN: 1460197702

Database block size 8192 Thread: 1

Current system change number 1460217574

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

PSAPACC ONLINE* ONLINE D:\ORACLE\XXX\SAPDATA4\ACC_12\ACC.DATA12 2147491840 22 3 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE D:\ORACLE\XXX\SAPDATA4\ACC_13\ACC.DATA13 2147491840 24 3 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE D:\ORACLE\XXX\SAPDATA4\ACC_14\ACC.DATA14 2147491840 26 3 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE I:\ORACLE\XXX\SAPDATA4\ACC_8\ACC.DATA8 2048000000 16 8 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE K:\ORACLE\XXX\SAPDATA4\ACC_10\ACC.DATA10 2048000000 19 10 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE K:\ORACLE\XXX\SAPDATA4\ACC_11\ACC.DATA11 2147483648 20 10 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE K:\ORACLE\XXX\SAPDATA4\ACC_9\ACC.DATA9 2048000000 18 10 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE L:\ORACLE\XXX\SAPDATA4\ACC_1\ACC.DATA1 10485768192 3 11 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE M:\ORACLE\XXX\SAPDATA4\ACC_2\ACC.DATA2 10485768192 4 12 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE M:\ORACLE\XXX\SAPDATA4\ACC_4\ACC.DATA4 2048000000 12 12 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE M:\ORACLE\XXX\SAPDATA4\ACC_5\ACC.DATA5 2048000000 13 12 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE M:\ORACLE\XXX\SAPDATA4\ACC_6\ACC.DATA6 2048000000 14 12 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE M:\ORACLE\XXX\SAPDATA4\ACC_7\ACC.DATA7 1024000000 15 12 NOLINK FILE 0 0 8192

PSAPACC ONLINE* ONLINE N:\ORACLE\XXX\SAPDATA4\ACC_3\ACC.DATA3 10485768192 5 13 NOLINK FILE 0 0 8192

PSAPACC640 ONLINE* ONLINE D:\ORACLE\XXX\SAPDATA4\ACC640_6\ACC640.DATA6 2147491840 23 3 NOLINK FILE 0 0 8192

PSAPACC640 ONLINE* ONLINE D:\ORACLE\XXX\SAPDATA4\ACC640_7\ACC640.DATA7 2147491840 25 3 NOLINK FILE 0 0 8192

PSAPACC640 ONLINE* ONLINE N:\ORACLE\XXX\SAPDATA4\ACC640_1\ACC640.DATA1 2369789952 6 13 NOLINK FILE 0 0 8192

PSAPACC640 ONLINE* ONLINE N:\ORACLE\XXX\SAPDATA4\ACC640_2\ACC640.DATA2 2264932352 7 13 NOLINK FILE 0 0 8192

PSAPACC640 ONLINE* ONLINE N:\ORACLE\XXX\SAPDATA4\ACC640_3\ACC640.DATA3 2243960832 8 13 NOLINK FILE 0 0 8192

PSAPACC640 ONLINE* ONLINE N:\ORACLE\XXX\SAPDATA4\ACC640_4\ACC640.DATA4 1132470272 9 13 NOLINK FILE 0 0 8192

PSAPACC640 ONLINE* ONLINE N:\ORACLE\XXX\SAPDATA4\ACC640_5\ACC640.DATA5 2048000000 17 13 NOLINK FILE 0 0 8192

PSAPACCDB ONLINE* ONLINE K:\ORACLE\XXX\SAPDATA4\ACCDB_1\ACCDB.DATA1 1048584192 11 10 NOLINK FILE 0 0 8192

PSAPACCUSR ONLINE* ONLINE K:\ORACLE\XXX\SAPDATA4\ACCUSR_1\ACCUSR.DATA1 41951232 10 10 NOLINK FILE 0 0 8192

PSAPTEMP ONLINE# ONLINE I:\ORACLE\XXX\SAPDATA3\TEMP_1\TEMP.DATA1 9730793472 -1 8 NOLINK FILE 0 0 8192

PSAPUNDO ONLINE- ONLINE L:\ORACLE\XXX\SAPDATA2\UNDO_1\UNDO.DATA1 10464796672 2 11 NOLINK FILE 0 0 8192

SYSAUX ONLINE* ONLINE L:\ORACLE\XXX\SAPDATA1\SYSTEM_1\SYSAUX01.DBF 679485440 21 11 NOLINK FILE 0 0 8192

SYSTEM ONLINE* SYSTEM L:\ORACLE\XXX\SAPDATA1\SYSTEM_1\SYSTEM.DATA1 660611072 1 11 NOLINK FILE 0 0 8192

BR0119I Redo log files

File Size Group Device Status Link Type

H:\ORACLE\XXX\ORIGLOGA\LOG_G11M1.DBF 52429312 1 7 INUSE NOLINK FILE

H:\ORACLE\XXX\MIRRLOGA\LOG_G11M2.DBF 52429312 1 7 INUSE NOLINK FILE

H:\ORACLE\XXX\ORIGLOGB\LOG_G12M1.DBF 52429312 2 7 INUSE NOLINK FILE

H:\ORACLE\XXX\MIRRLOGB\LOG_G12M2.DBF 52429312 2 7 INUSE NOLINK FILE

H:\ORACLE\XXX\ORIGLOGA\LOG_G13M1.DBF 52429312 3 7 INUSE NOLINK FILE

H:\ORACLE\XXX\MIRRLOGA\LOG_G13M2.DBF 52429312 3 7 INUSE NOLINK FILE

H:\ORACLE\XXX\ORIGLOGB\LOG_G14M1.DBF 52429312 4 7 INUSE NOLINK FILE

H:\ORACLE\XXX\MIRRLOGB\LOG_G14M2.DBF 52429312 4 7 INUSE NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

H:\ORACLE\XXX\ORIGLOGA\CNTRL\CNTRLXXX.DBF 36192256 0 7 NOLINK FILE

J:\ORACLE\XXX\SAPARCH\CNTRL\CNTRLXXX.DBF 36192256 0 9 NOLINK FILE

L:\ORACLE\XXX\SAPDATA1\SYSTEM_1\CNTRL\CNTRLXXX.DBF 36192256 0 11 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPACC:

PSAPACC, PSAPACC640, PSAPACCUSR

BR0280I BRBACKUP time stamp: 2014-10-14 15.55.08

BR0057I Backup of database: XXX

BR0058I BRBACKUP action ID: beoysmyk

BR0059I BRBACKUP function ID: fnf

BR0110I Backup mode: FULL

BR0077I Database file for backup: J:\oracle\XXX\sapbackup\CNTRLXXX.DBF

BR0061I 27 files found for backup, total size 76909.086 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

BR0289I BRARCHIVE will be started at the end of processing

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0280I BRBACKUP time stamp: 2014-10-14 15.55.09

BR0315I 'Alter database begin backup' successful

BR0280I BRBACKUP time stamp: 2014-10-14 15.55.09

BR0229I Calling backup utility with function 'backup'...

BR0278I Command output of 'backint -u XXX -f backup -i J:\oracle\XXX\sapbackup\.beoysmyk.lst -t file -p G:\oracle\XXX\11203\database\initXXX.utl -c':

********************************************************************************

Program: backint 7.5

Input File: J:\oracle\XXX\sapbackup\.beoysmyk.lst

Profile: G:\oracle\XXX\11203\database\initXXX.utl

Function: BACKUP

Backup Type: BACKUP_FILE

********************************************************************************

[4294973680.01] 15:58:21 INF - Data buffer size = 262144

[6384.456] 15:58:25 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC_12\ACC.DATA12> is in progress.

[4294973680.01] 16:00:24 INF - Using Media ID @AAAAF for Backup ID acdcpdqsbw101.hotels.corp_1413294917

[6384.456] 16:00:44 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC_13\ACC.DATA13> is in progress.

[6384.456] 16:01:04 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC_14\ACC.DATA14> is in progress.

[6384.456] 16:01:24 INF - Backup of <I:\ORACLE\XXX\SAPDATA4\ACC_8\ACC.DATA8> is in progress.

[6384.456] 16:01:43 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACC_10\ACC.DATA10> is in progress.

[6384.456] 16:02:02 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACC_11\ACC.DATA11> is in progress.

[6384.456] 16:02:21 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACC_9\ACC.DATA9> is in progress.

[6384.456] 16:02:40 INF - Backup of <L:\ORACLE\XXX\SAPDATA4\ACC_1\ACC.DATA1> is in progress.

[6384.456] 16:04:11 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_2\ACC.DATA2> is in progress.

[4294973680.01] 16:04:22 INF - Using Media ID @AAAAF for Backup ID acdcpdqsbw101.hotels.corp_1413294917

[6384.456] 16:05:46 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_4\ACC.DATA4> is in progress.

[6384.456] 16:06:06 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_5\ACC.DATA5> is in progress.

[6384.456] 16:06:26 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_6\ACC.DATA6> is in progress.

[6384.456] 16:06:45 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_7\ACC.DATA7> is in progress.

[6384.456] 16:06:55 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC_3\ACC.DATA3> is in progress.

[4294973680.01] 16:08:19 INF - Using Media ID @AAAAF for Backup ID acdcpdqsbw101.hotels.corp_1413294917

[6384.456] 16:08:28 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC640_6\ACC640.DATA6> is in progress.

[6384.456] 16:08:48 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC640_7\ACC640.DATA7> is in progress.

[6384.456] 16:09:08 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_1\ACC640.DATA1> is in progress.

[6384.456] 16:09:29 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_2\ACC640.DATA2> is in progress.

[6384.456] 16:09:50 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_3\ACC640.DATA3> is in progress.

[6384.456] 16:10:11 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_4\ACC640.DATA4> is in progress.

[6384.456] 16:10:22 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_5\ACC640.DATA5> is in progress.

[6384.456] 16:10:41 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACCDB_1\ACCDB.DATA1> is in progress.

[6384.456] 16:10:51 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACCUSR_1\ACCUSR.DATA1> is in progress.

[6384.456] 16:10:53 INF - Backup of <L:\ORACLE\XXX\SAPDATA2\UNDO_1\UNDO.DATA1> is in progress.

[4294973680.01] 16:12:22 INF - Using Media ID @AAAAF for Backup ID acdcpdqsbw101.hotels.corp_1413294917

[6384.456] 16:12:28 INF - Backup of <L:\ORACLE\XXX\SAPDATA1\SYSTEM_1\SYSAUX01.DBF> is in progress.

[6384.456] 16:12:36 INF - Backup of <L:\ORACLE\XXX\SAPDATA1\SYSTEM_1\SYSTEM.DATA1> is in progress.

[6384.456] 16:12:44 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC_12\ACC.DATA12> is done.

[6384.456] 16:12:44 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC_13\ACC.DATA13> is done.

[6384.456] 16:12:44 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC_14\ACC.DATA14> is done.

[6384.456] 16:12:44 INF - Backup of <I:\ORACLE\XXX\SAPDATA4\ACC_8\ACC.DATA8> is done.

[6384.456] 16:12:44 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACC_10\ACC.DATA10> is done.

[6384.456] 16:12:44 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACC_11\ACC.DATA11> is done.

[6384.456] 16:12:44 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACC_9\ACC.DATA9> is done.

[6384.456] 16:12:44 INF - Backup of <L:\ORACLE\XXX\SAPDATA4\ACC_1\ACC.DATA1> is done.

[6384.456] 16:12:44 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_2\ACC.DATA2> is done.

[6384.456] 16:12:44 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_4\ACC.DATA4> is done.

[6384.456] 16:12:44 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_5\ACC.DATA5> is done.

[6384.456] 16:12:44 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_6\ACC.DATA6> is done.

[6384.456] 16:12:44 INF - Backup of <M:\ORACLE\XXX\SAPDATA4\ACC_7\ACC.DATA7> is done.

[6384.456] 16:12:44 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC_3\ACC.DATA3> is done.

[6384.456] 16:12:44 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC640_6\ACC640.DATA6> is done.

[6384.456] 16:12:44 INF - Backup of <D:\ORACLE\XXX\SAPDATA4\ACC640_7\ACC640.DATA7> is done.

[6384.456] 16:12:44 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_1\ACC640.DATA1> is done.

[6384.456] 16:12:44 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_2\ACC640.DATA2> is done.

[6384.456] 16:12:44 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_3\ACC640.DATA3> is done.

[6384.456] 16:12:44 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_4\ACC640.DATA4> is done.

[6384.456] 16:12:44 INF - Backup of <N:\ORACLE\XXX\SAPDATA4\ACC640_5\ACC640.DATA5> is done.

[6384.456] 16:12:44 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACCDB_1\ACCDB.DATA1> is done.

[6384.456] 16:12:44 INF - Backup of <K:\ORACLE\XXX\SAPDATA4\ACCUSR_1\ACCUSR.DATA1> is done.

[6384.456] 16:12:44 INF - Backup of <L:\ORACLE\XXX\SAPDATA2\UNDO_1\UNDO.DATA1> is done.

[6384.456] 16:12:44 INF - Backup of <L:\ORACLE\XXX\SAPDATA1\SYSTEM_1\SYSAUX01.DBF> is done.

[6384.456] 16:12:44 INF - Backup of <L:\ORACLE\XXX\SAPDATA1\SYSTEM_1\SYSTEM.DATA1> is done.