Error in Backup

[Former Member]

Dear All,

I am getting error when taking the development backup....

SAPDATA1\SR3_1\SR3.DATA1 of tablespace PSAPSR3 is already in backup status

this error is showing for all datafiles....

Please suggest me what is the problem...

Thanks

Bhaskar

[Former Member]

Hello Bhaskar

BR0328E Database file %s from tablespace %s is already in backup status.

Explanation: The tablespace to which the file belongs was just backed up,

or the last backup was cancelled. The file is not updated to backup status.

Program reaction: Processing terminates.

User action: If the last backup was cancelled, manually enter the SQLDBA

command

ALTER TABLESPACE <tablespace name> END BACKUP;

Please contribute points if your problem is resolved

[Former Member]

Hi. Can you expain In more detail ? For example give as the error number, also good if you say the DB OS SAP versions. If your error BR0328E when read the :

Note 17163 - BRARCHIVE/BRBACKUP messages and codes.

Regards.

[Former Member]

Hi,

Thanks for your reply

Following is the error log.

BR0051I BRBACKUP 7.00 (13)

BR0189W Expiration period equal 0 - backup volumes could be immediately overwritten

BR0055I Start of database backup: bdxxiprp.ant 2008-05-13 17.40.29

BR0477I Oracle pfile E:\oracle\MRD\102\database\initMRD.ora created from spfile E:\oracle\MRD\102\database\spfileMRD.ora

BR0280I BRBACKUP time stamp: 2008-05-13 17.40.32

BR0319I Control file copy created: G:\oracle\MRD\sapbackup\CNTRLMRD.DBF 24461312

BR0328E Database file Q:\SAPDATA1\SR3_1\SR3.DATA1 of tablespace PSAPSR3 is already in backup status

BR0328E Database file Q:\SAPDATA1\SR3_2\SR3.DATA2 of tablespace PSAPSR3 is already in backup status

BR0328E Database file Q:\SAPDATA1\SR3_3\SR3.DATA3 of tablespace PSAPSR3 is already in backup status

BR0328E Database file Q:\SAPDATA1\SR3_4\SR3.DATA4 of tablespace PSAPSR3 is already in backup status

BR0328E Database file G:\ORACLE\MRD\SAPDATA1\SR3_5\SR3.DATA5 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_6\SR3.DATA6 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_7\SR3.DATA7 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_8\SR3.DATA8 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_9\SR3.DATA9 of tablespace PSAPSR3 is already in backup status

BR0328E Database file H:\ORACLE\MRD\SAPDATA2\SR3_10\SR3.DATA10 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_11\SR3.DATA11 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_12\SR3.DATA12 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_13\SR3.DATA13 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_14\SR3.DATA14 of tablespace PSAPSR3 is already in backup status

BR0328E Database file I:\ORACLE\MRD\SAPDATA3\SR3_15\SR3.DATA15 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_16\SR3.DATA16 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_17\SR3.DATA17 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_18\SR3.DATA18 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_19\SR3.DATA19 of tablespace PSAPSR3 is already in backup status

BR0328E Database file J:\ORACLE\MRD\SAPDATA4\SR3_20\SR3.DATA20 of tablespace PSAPSR3 is already in backup status

BR0056I End of database backup: bdxxiprp.ant 2008-05-13 17.40.35

BR0280I BRBACKUP time stamp: 2008-05-13 17.40.35

BR0054I BRBACKUP terminated with errors

Bhaskar

[Former Member]

Read Note 17163 - BRARCHIVE/BRBACKUP messages and codes.

And find in them BR0328E. Regards.

[former_member204746]

you are using Oracle 10g, then you can also use:

alter database end backup;

this will put all tablespaces out of backup mode.