Backup Failed for last two days

[Former Member]

Dear All,

We are getting Backup failed for last 2 days and it throws below error .

BR0280I BRBACKUP time stamp: 2011-12-09 19.27.17

BR0312E Database instance SRX shutdown during online backup

BR0252W Function remove() failed for 'X:\oracle\SRX\sapbackup\.behkdcyf.013' at location BrCleanup-6

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for 'X:\oracle\SRX\sapbackup\.behkdcyf.014' at location BrCleanup-6

BR0253W errno 13: Permission denied

BR0115I Compression rate for all files 4.4881:1

BR0280I BRBACKUP time stamp: 2011-12-09 19.27.19

BR0301W SQL error -24909 at location BrDbDisconnect-1, SQL statement:

'/* BRBACKUP */ ALTER TABLESPACE "PSAPSR3DB" END BACKUP'

'COMMIT RELEASE'

ORA-24909: call in progress. Current operation cancelled

BR0327W Disconnect from database instance SRX failed

BR0280I BRBACKUP time stamp: 2011-12-09 19.29.45

BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRBACKUP time stamp: 2011-12-09 19.30.19

BR0317I 'Alter tablespace PSAPSR3700 end backup' successful

BR0280I BRBACKUP time stamp: 2011-12-09 19.30.19

BR0301E SQL error -1142 at location BrBackAlter-3, SQL statement:

'/* BRBACKUP */ ALTER TABLESPACE "PSAPSR3DB" END BACKUP'

ORA-01142: cannot end online backup - none of the files are in backup

BR0280I BRBACKUP time stamp: 2011-12-09 19.30.19

BR0318E 'Alter tablespace PSAPSR3DB end backup' failed

BR0280I BRBACKUP time stamp: 2011-12-09 19.30.29

BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0056I End of database backup: behkdcyf.and 2011-12-09 19.27.18

BR0280I BRBACKUP time stamp: 2011-12-09 19.30.34

BR0054I BRBACKUP terminated with errors

Note : I have checked till now SAP is not down (ST02 - Startup: 14.09.2011 13:18:46)

Kindly suggest to resolve the issue as well what was the reason behind ...

Thanks

[volker_borowski2]

> BR0312E Database instance SRX shutdown during online backup
> BR0252W Function remove() failed for 'X:\oracle\SRX\sapbackup\.behkdcyf.013' at location BrCleanup-6
> BR0253W errno 13: Permission denied
> BR0252W Function remove() failed for 'X:\oracle\SRX\sapbackup\.behkdcyf.014' at location BrCleanup-6
> BR0253W errno 13: Permission denied
> Note :   I have checked till now SAP is not down (ST02 - Startup:     14.09.2011 13:18:46)
> 

Hi,

pretty obvious messages.

During an online Backup, brconnect checks that the DB stays online.

Obviously it detected that the DB had been shutdown during this run, therefore logging the message.

-> Check Alertlog to confirm related timing

Permission denied is self speaking.

ST02, SAP not down but DB down can be configured, i.E. if you schedule OFFLINE Backups in DB13.

Wild guess:

You have two Systems in an MCOD DB and System two is not aware of the fact,

that it should keep out of doing backups then.

Volker

[Former Member]

Temp i am closing this thread ...

[former_member189725]

Please ensure the files .behkdcyf.013 and .behkdcyf.014 are deleted .

Just check the status of the tablespace using

select STATUS from dba_tablespaces;

It should be all online , else run

ALTER TABLESPACE "PSAPSR3DB" END BACKUP;

Now try to bring the tablespace to backup mode with

ALTER TABLESPACE "PSAPSR3DB" BEGIN BACKUP;

If it is sucessful, then take the tablespace PSAPSR3DB out of backup mode .

Then start the online backup of the entire database.

[Former Member]

Hi ,

Thanks for ur valuable reply ..

I have already checked Tablespace status in DB02old , all the Table space are ONLINE , NOT ACTIVE .

Tablespace Size (kb) Free (kb) Used (%) Tab/ind Extents AutoExt (kb) Used (%) Status Backup

PSAPSR3 35.538.944 5.400.960 84 51.141 70.617 55.320.576 54 ONLINE NOT ACTIVE

PSAPSR3700 21.008.384 1.131.648 94 916 6.730 27.164.672 73 ONLINE NOT ACTIVE

PSAPSR3DB 5.816.320 3.763.328 35 3.091 4.581 10.485.760 20 ONLINE NOT ACTIVE

PSAPSR3USR 20.480 20.032 2 6 6 2.097.152 0 ONLINE NOT ACTIVE

PSAPTEMP 901.120 900.096 0 0 0 2.097.152 0 ONLINE NOT ACTIVE

PSAPUNDO 7.740.352 6.877.824 11 19 726 Off 11 ONLINE NOT ACTIVE

PSAPYBMCD 901.120 678.144 24 302 798 2.097.152 11 ONLINE NOT ACTIVE

PSAPYBMCI 901.120 758.208 15 371 912 2.097.152 7 ONLINE NOT ACTIVE

SYSAUX 972.800 716.160 26 1.769 2.898 2.097.152 12 ONLINE NOT ACTIVE

SYSTEM 1.177.600 724.480 38 1.226 2.413 5.242.880 9 ONLINE NOT ACTIVE

Kindly advise .

Thanks

[former_member188883]

Hi,

Please check you have full permission to sapbackup folder. Ensure that there are no .lck files in the sapbackup folder.

Also end the current running backup using the command

alter database end backup;

Restart SAP application and database.

After this try to run backup again.

Hope this is useful.

Regards,

Deepak Kori

[Former Member]

Hi,

Please execute the SQL query : select distinct(status) from v$backup;

If you find any status as "ONLINE" execute the SQL query : alter database end backup;

If you do not find any status as "ONLINE", check for any lock file under the sapbackup directory.

Thanks.