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: 

Error during DEV backup PSAPSR3 is already in backup status

Former Member

on ‎05-14-2008 2:17 PM

0 Kudos

Dear All,

When i m taking development backup.It generating the error PSAPSR3 is already in backup status.Plz tell me how to resolve this issue.

LOG file is attached.

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

Thank and Regard's

Adil

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎05-19-2008 6:25 PM
0 Kudos

Looks like a backup is already in progress. Was there crash during an online backup? You can end the backup with "alter database end backup" and try running the backup again.

Show replies
Show replies
Former Member
‎06-11-2008 12:18 PM
0 Kudos

Hi Adil,

Please follow the SAP Note#Note 7490

Former Member
‎10-19-2010 10:50 AM
0 Kudos

Hi ,

Are you taken backup successfully , if not pls check below things.

1,tablespace PSAPSR3 is already in backup status, This error usually occurs when you are running an Online Backup and because of some previous failed backups the table spaces are still under back up status.

pls check if any backup is running or not

ps -ef|grep brbackup .

2 , check any lock file is created under oracl/SID/sapbackup if s remove lock file from the directory .

3 , login into DB

> sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 19 14:57:23 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> connect /as sysdba

Connected.

SQL> select status from v$backup;

check the status it should not be ACTIVE .

from your case Tablespace PSAPSR3 is already in backup status so login into DB

> sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Oct 19 14:57:23 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

SQL> connect /as sysdba

Connected.

alter tablespace PSAPSR3 end backup;

SQL> alter tablespace PSAPSR3 end backup;

Tablespace altered.

SQL> select status from v$backup;

STATUS

-

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

STATUS

-

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

STATUS

-

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

STATUS

-

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

NOT ACTIVE

41 rows selected.

SQL>

After complete the above activity pls fire the backup .

It might be resolve your issue .

Edited by: satheesh0812 on Oct 19, 2010 11:54 AM

Ask a Question