cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Backup failure with error code 9999

Go to solution
Former Member

on ‎09-27-2012 1:25 PM

0 Kudos

Hi All

From last week we are facing problem with backup,we are unable to perform whole DB online backup,

every time we schedule in DB13 it say running but in sm66 i can see the long running job gets failed.

We have deleted the lock.brb and alter the tablespace from active every time ,

I am not sure why it is failing from past one week

please help me ,I have attached the deatil logs for your reference,

please let me know what more you needed.

BR0051I BRBACKUP 7.00 (50)

BR0055I Start of database backup: bejnkwli.anf 2012-09-27 02.25.02

BR0484I BRBACKUP log file: R:\ORACLE\PR1\sapbackup\bejnkwli.anf

BR0477I Oracle pfile C:\oracle\PR1\102\database\initPR1.ora created from spfile C:\oracle\PR1\102\database\spfilePR1.ora

BR0280I BRBACKUP time stamp: 2012-09-27 02.25.05

BR0319I Control file copy created: R:\ORACLE\PR1\sapbackup\CNTRLPR1.DBF 13844480

BR0101I Parameters

Name                           Value

oracle_sid                     PR1

oracle_home                    C:\oracle\PR1\102

oracle_profile                 C:\oracle\PR1\102\database\initPR1.ora

sapdata_home                   R:\ORACLE\PR1

sap_profile                    C:\oracle\PR1\102\database\initpr1.sap

backup_mode                    ALL

backup_type                    online

backup_dev_type                util_file

util_par_file                  C:\oracle\PR1\102\database\initPR1.utl

system_info                    SAPServicePR1 SAP2DBSRV Windows 5.2 Build 3790 Service Pack 1 AMD64

oracle_info                    PR1 10.2.0.4.0 8192 9186 170127009 SAP2DBSRV UTF8 UTF8

sap_info                       701 SAPR3 0002LK0003PR10011Z01156852180015Maintenance_ORA

make_info                      NTAMD64 OCI_10201_SHARE Oct 31 2010

command_line                   brbackup -u / -jid ALL__20120927022500 -c force -t online -m all -p initpr1.sap -v PR1B018

BR0116I ARCHIVE LOG LIST before backup for database instance PR1

Parameter                      Value

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            LOCATION=M:\ORACLE\PR1\oraarch\PR1arch

Archive format                 %t_%s_%r.dbf

Oldest online log sequence     9183

Next log sequence to archive   9186

Current log sequence           9186             SCN: 170127009

Database block size            8192             Thread: 1

Current system change number   170136557        ResetId: 741826623

BR0118I Tablespaces and data files

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

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3_1\SR3.DATA1               2432704512    4           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3_2\SR3.DATA2               2411732992    5           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3_3\SR3.DATA3               2474647552    6           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3_4\SR3.DATA4               2411732992    7           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3_5\SR3.DATA5               2390761472    8           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3_6\SR3.DATA6               2390761472    9           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3_7\SR3.DATA7               1667244032   10           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_10\SR3.DATA10             2327846912   13           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_11\SR3.DATA11             2327846912   14           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_12\SR3.DATA12             2327846912   15           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_13\SR3.DATA13             2348818432   16           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_14\SR3.DATA14             4257226752   17           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_15\SR3.DATA15             3187679232   18           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_16\SR3.DATA16             2726305792   19           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_17\SR3.DATA17             2642419712   20           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_18\SR3.DATA18             4802486272   21           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_19\SR3.DATA19             5494546432   22           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_8\SR3.DATA8               2306875392   11           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA2\SR3_9\SR3.DATA9               2327846912   12           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_20\SR3.DATA20             3732938752   23           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_21\SR3.DATA21             3187679232   24           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_22\SR3.DATA22             2998935552   25           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_23\SR3.DATA23             2852134912   26           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_24\SR3.DATA24             2642419712   27           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_25\SR3.DATA25             2600476672   28           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_26\SR3.DATA26             2621448192   29           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_27\SR3.DATA27             2600476672   30           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA3\SR3_28\SR3.DATA28             2118131712   31           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3_29\SR3.DATA29             2170560512   32           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3_30\SR3.DATA30             2453676032   33           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3_31\SR3.DATA31              943726592   34           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_32\SR3.DATA32             2390761472   35           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_33\SR3.DATA33             2453676032   36           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_34\SR3.DATA34             2537562112   37           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_35\SR3.DATA35             2579505152   38           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_36\SR3.DATA36             2453676032   39           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_37\SR3.DATA37             2453676032   40           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_38\SR3.DATA38             2411732992   41           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_39\SR3.DATA39             2432704512   42           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3        ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA6\SR3_40\SR3.DATA40              566239232   43           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_1\SR3701.DATA1         3942653952   44           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_2\SR3701.DATA2         3879739392   45           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_3\SR3701.DATA3         4110426112   46           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_4\SR3701.DATA4         4299169792   47           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_5\SR3701.DATA5         7130324992   48           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_6\SR3701.DATA6         4047511552   49           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_7\SR3701.DATA7         3795853312   50           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA4\SR3701_8\SR3701.DATA8         1876959232   51           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3701_10\SR3701.DATA10       3774881792   53           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3701_11\SR3701.DATA11       3837796352   54           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3701_12\SR3701.DATA12       3837796352   55           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3701_13\SR3701.DATA13       6962552832   56           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3701_14\SR3701.DATA14       4047511552   57           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3701_15\SR3701.DATA15       3659538432   58           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3701     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3701_9\SR3701.DATA9         4278198272   52           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3USR     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SR3USR_1\SR3USR.DATA1           20979712   59           7  NOLINK  FILE   10485760000     20971520     8192

PSAPSR3USR     ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA5\SR3USR_2\SR3USR.DATA2           10493952   60           7  NOLINK  FILE   10485760000     20971520     8192

PSAPTEMP       ONLINE#    ONLINE+   H:\ORACLE\PR1\SAPDATA1\TEMP_1\TEMP.DATA1             4183826432   -1           7  NOLINK  FILE   10485760000     20971520     8192

PSAPUNDO       ONLINE-    ONLINE+   H:\ORACLE\PR1\SAPDATA1\UNDO_1\UNDO.DATA1             1300242432    2           7  NOLINK  FILE   10485760000     20971520     8192

SYSAUX         ONLINE*    ONLINE+   H:\ORACLE\PR1\SAPDATA1\SYSAUX_1\SYSAUX.DATA1          377495552    3           7  NOLINK  FILE   10485760000     20971520     8192

SYSTEM         ONLINE*    SYSTEM+   H:\ORACLE\PR1\SAPDATA1\SYSTEM_1\SYSTEM.DATA1          954212352    1           7  NOLINK  FILE   10485760000     20971520     8192

BR0119I Redo log files

File                                                Size  Group     Device  Status    Link    Type

O:\ORACLE\PR1\MIRRLOGA\LOG_G11M2.DBF            52429312    1           14  INUSE     NOLINK  FILE

N:\ORACLE\PR1\ORIGLOGA\LOG_G11M1.DBF            52429312    1           13  INUSE     NOLINK  FILE

O:\ORACLE\PR1\MIRRLOGB\LOG_G12M2.DBF            52429312    2           14  INUSE     NOLINK  FILE

N:\ORACLE\PR1\ORIGLOGB\LOG_G12M1.DBF            52429312    2           13  INUSE     NOLINK  FILE

O:\ORACLE\PR1\MIRRLOGA\LOG_G13M2.DBF            52429312    3           14  INUSE     NOLINK  FILE

N:\ORACLE\PR1\ORIGLOGA\LOG_G13M1.DBF            52429312    3           13  INUSE     NOLINK  FILE

O:\ORACLE\PR1\MIRRLOGB\LOG_G14M2.DBF            52429312    4           14  INUSE     NOLINK  FILE

N:\ORACLE\PR1\ORIGLOGB\LOG_G14M1.DBF            52429312    4           13  INUSE     NOLINK  FILE

BR0120I Control files

File                                                Size   Id.      Device  Link    Type

N:\ORACLE\PR1\origlogA\cntrl\cntrlPR1.dbf       13844480    0           13  NOLINK  FILE

N:\ORACLE\PR1\origlogB\cntrl\cntrlPR1.dbf       13844480    0           13  NOLINK  FILE

R:\ORACLE\PR1\sapdata1\cntrl\cntrlPR1.dbf       13844480    0           17  NOLINK  FILE

BR0280I BRBACKUP time stamp: 2012-09-27 02.25.05

BR0057I Backup of database: PR1

BR0058I BRBACKUP action ID: bejnkwli

BR0059I BRBACKUP function ID: anf

BR0110I Backup mode: ALL

BR0077I Database file for backup: R:\ORACLE\PR1\sapbackup\CNTRLPR1.DBF

BR0061I 61 files found for backup, total size 162713.672 MB

BR0143I Backup type: online

BR0130I Backup device type: util_file

BR0109I Files will be saved by backup utility

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

BR0280I BRBACKUP time stamp: 2012-09-27 02.25.07

BR0315I 'Alter database begin backup' successful

BR0280I BRBACKUP time stamp: 2012-09-27 02.25.07

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

BR0278I Command output of 'E:\usr\sap\PR1\SYS\exe\uc\NTAMD64\backint.exe -u PR1 -f backup -i R:\ORACLE\PR1\sapbackup\.bejnkwli.lst -t file -p C:\oracle\PR1\102\database\initPR1.utl -c':

BACKINT Parameters

==>  -u PR1 -f backup -i R:\ORACLE\PR1\sapbackup\.bejnkwli.lst -t file -p C:\oracle\PR1\102\database\initPR1.utl -c

Search... "H:\ORACLE\PR1\SAPDATA1\SR3_1\SR3.DATA1" :  OK    : 2375688 KB

Search... "H:\ORACLE\PR1\SAPDATA1\SR3_2\SR3.DATA2" :  OK    : 2355208 KB

Search... "H:\ORACLE\PR1\SAPDATA1\SR3_3\SR3.DATA3" :  OK    : 2416648 KB

Search... "H:\ORACLE\PR1\SAPDATA1\SR3_4\SR3.DATA4" :  OK    : 2355208 KB

Search... "H:\ORACLE\PR1\SAPDATA1\SR3_5\SR3.DATA5" :  OK    : 2334728 KB

Search... "H:\ORACLE\PR1\SAPDATA1\SR3_6\SR3.DATA6" :  OK    : 2334728 KB

Search... "H:\ORACLE\PR1\SAPDATA1\SR3_7\SR3.DATA7" :  OK    : 1628168 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_10\SR3.DATA10" :  OK    : 2273288 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_11\SR3.DATA11" :  OK    : 2273288 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_12\SR3.DATA12" :  OK    : 2273288 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_13\SR3.DATA13" :  OK    : 2293768 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_14\SR3.DATA14" :  OK    : 4157448 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_15\SR3.DATA15" :  OK    : 3112968 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_16\SR3.DATA16" :  OK    : 2662408 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_17\SR3.DATA17" :  OK    : 2580488 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_18\SR3.DATA18" :  OK    : 4689928 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_19\SR3.DATA19" :  OK    : 5365768 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_8\SR3.DATA8" :  OK    : 2252808 KB

Search... "H:\ORACLE\PR1\SAPDATA2\SR3_9\SR3.DATA9" :  OK    : 2273288 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_20\SR3.DATA20" :  OK    : 3645448 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_21\SR3.DATA21" :  OK    : 3112968 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_22\SR3.DATA22" :  OK    : 2928648 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_23\SR3.DATA23" :  OK    : 2785288 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_24\SR3.DATA24" :  OK    : 2580488 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_25\SR3.DATA25" :  OK    : 2539528 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_26\SR3.DATA26" :  OK    : 2560008 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_27\SR3.DATA27" :  OK    : 2539528 KB

Search... "H:\ORACLE\PR1\SAPDATA3\SR3_28\SR3.DATA28" :  OK    : 2068488 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3_29\SR3.DATA29" :  OK    : 2119688 KB

Search... "H:\ORACLE\PR1\SAPDATA5\SR3_30\SR3.DATA30" :  OK    : 2396168 KB

Search... "H:\ORACLE\PR1\SAPDATA5\SR3_31\SR3.DATA31" :  OK    : 921608 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_32\SR3.DATA32" :  OK    : 2334728 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_33\SR3.DATA33" :  OK    : 2396168 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_34\SR3.DATA34" :  OK    : 2478088 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_35\SR3.DATA35" :  OK    : 2519048 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_36\SR3.DATA36" :  OK    : 2396168 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_37\SR3.DATA37" :  OK    : 2396168 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_38\SR3.DATA38" :  OK    : 2355208 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_39\SR3.DATA39" :  OK    : 2375688 KB

Search... "H:\ORACLE\PR1\SAPDATA6\SR3_40\SR3.DATA40" :  OK    : 552968 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_1\SR3701.DATA1" :  OK    : 3850248 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_2\SR3701.DATA2" :  OK    : 3788808 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_3\SR3701.DATA3" :  OK    : 4014088 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_4\SR3701.DATA4" :  OK    : 4198408 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_5\SR3701.DATA5" :  OK    : 6963208 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_6\SR3701.DATA6" :  OK    : 3952648 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_7\SR3701.DATA7" :  OK    : 3706888 KB

Search... "H:\ORACLE\PR1\SAPDATA4\SR3701_8\SR3701.DATA8" :  OK    : 1832968 KB

Search... "H:\ORACLE\PR1\SAPDATA5\SR3701_10\SR3701.DATA10" :  OK    : 3686408 KB

Search... "H:\ORACLE\PR1\SAPDATA5\SR3701_11\SR3701.DATA11" :  OK    : 3747848 KB

Search... "H:\ORACLE\PR1\SAPDATA5\SR3701_12\SR3701.DATA12" :  OK    : 3747848 KB

Search... "H:\ORACLE\PR1\SAPDATA5\SR3701_13\SR3701.DATA13" :  OK    : 6799368 KB

please help me

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

paul_power
Active Contributor
‎09-27-2012 3:04 PM
0 Kudos

Hello Karthikeyan,

I dont see an error in the above logs.

Are you using the latest brtools?

Have you restarted the db (and perhaps clear shared memory)

Let us know further details of the error you are encountering.

Regards,

Paul

Show replies
Show replies
Former Member
‎09-27-2012 3:20 PM
0 Kudos

Hi PAUL,

We have not restarted the DB.

we have cancel an active whole DB backup which was active.

post to that all the active whole DB backup is getting failed.

Please let me know what more you needed to investigate

manish_singh13
Active Contributor
‎09-27-2012 4:41 PM
0 Kudos

Hi Karthik,

Maybe there is still any tablespace in backup mode. Could you please execute this query and paste the results:

select d.tablespace_name, b.time, b.status from dba_data_files d, v$backup b where d.file_id = b.FILE# and b.STATUS = 'ACTIVE' ;

Thanks,

Manish

Former Member
‎09-27-2012 4:52 PM
0 Kudos

Thanx manish, But I have already executed this command to alter table space end bckup

manish_singh13
Active Contributor
‎09-27-2012 5:02 PM
0 Kudos

Hi Karthik,

As above logs not showing any errors. Can you please check again the logs to see if above logs are complete.

If there is no error to be found in the logs then you can try method mentioned by Paul. Also plz remember to clean failed backup directories.

Apart from online backup other jobs are getting completed (archive logbackup, stats update etc)?

Thanks,

Manish

Former Member
‎09-27-2012 5:22 PM
0 Kudos

Manish,

redo log backups are running successfully,

please tell me how to clean failed backup directories.

manish_singh13
Active Contributor
‎09-27-2012 5:47 PM
0 Kudos

Hi Karthik,

At what location your backup is saving files after backup as it's not there in above logs. Check that location and rename/delete the failed backup directories. If that's on Tape then its fine if any other disk then check there.

Apart from that at location R:\ORACLE\PR1\sapbackup check how many .lst files are there. I believe lock file you have already deleted from this location.

Thanks,

Manish

Answers (0)

Ask a Question