backup error; datafiles is already in backup status

[former_member633852]

Dear Experts,

While we are starting online db backup, we are getting following errors;

BR0280I BRBACKUP time stamp: 2009-07-13 02.16.07

BR0319I Control file copy created: /oracle/TBP/sapbackup/cntrlTBP.dbf 34783232

BR0328E Database file /oracle/TBP/sapdata1/system_1/system.data1 of tablespace SYSTEM is already in backup status

BR0328E Database file /oracle/TBP/sapdata1/undo_1/undo.data1 of tablespace PSAPUNDO is already in backup status

BR0328E Database file /oracle/TBP/sapdata1/sysaux_1/sysaux.data1 of tablespace SYSAUX is already in backup status

BR0328E Database file /oracle/TBP/sapdata2/sr3_1/sr3.data1 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata3/sr3700_1/sr3700.data1 of tablespace PSAPSR3700 is already in backup status

BR0328E Database file /oracle/TBP/sapdata4/sr3usr_1/sr3usr.data1 of tablespace PSAPSR3USR is already in backup status

BR0328E Database file /oracle/TBP/sapdata4/sr3700_2/sr3700.data2 of tablespace PSAPSR3700 is already in backup status

BR0328E Database file /oracle/TBP/sapdata1/sr3_2/sr3.data2 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata2/sr3_3/sr3.data3 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata3/sr3_4/sr3.data4 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata4/sr3_5/sr3.data5 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata1/sr3_6/sr3.data6 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata3/sr3_7/sr3.data7 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata4/sr3_8/sr3.data8 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata2/sr3700_3/sr3700.data3 of tablespace PSAPSR3700 is already in backup status

BR0328E Database file /oracle/TBP/sapdata1/sr3_9/sr3.data9 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata2/sr3_10/sr3.data10 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata3/sr3_11/sr3.data11 of tablespace PSAPSR3 is already in backup status

BR0328E Database file /oracle/TBP/sapdata4/sr3_12/sr3.data12 of tablespace PSAPSR3 is already in backup status

BR0056I End of database backup: beazuchh.anf 2009-07-13 02.16.08

BR0280I BRBACKUP time stamp: 2009-07-13 02.16.08

I've tried to take datafiles out of backup mode with following commands ;

SQL> select * from v$backup;

FILE# STATUS CHANGE# TIME

-

---

-

---

-

---

-

---

1 ACTIVE 492340220 05-JUL-09

2 ACTIVE 492340220 05-JUL-09

3 ACTIVE 492340220 05-JUL-09

4 ACTIVE 492340220 05-JUL-09

5 ACTIVE 492340220 05-JUL-09

6 ACTIVE 492340220 05-JUL-09

7 ACTIVE 492340220 05-JUL-09

8 ACTIVE 492340220 05-JUL-09

9 ACTIVE 492340220 05-JUL-09

10 ACTIVE 492340220 05-JUL-09

11 ACTIVE 492340220 05-JUL-09

FILE# STATUS CHANGE# TIME

-

---

-

---

-

---

-

---

12 ACTIVE 492340220 05-JUL-09

13 ACTIVE 492340220 05-JUL-09

14 ACTIVE 492340220 05-JUL-09

15 ACTIVE 492340220 05-JUL-09

16 ACTIVE 492340220 05-JUL-09

17 ACTIVE 492340220 05-JUL-09

18 ACTIVE 492340220 05-JUL-09

19 ACTIVE 492340220 05-JUL-09

19 rows selected.

SQL> select 'alter database datafile '

2 || file# || ' end backup;'

3 from v$backup where status = 'ACTIVE';

'ALTERDATABASEDATAFILE'||FILE#||'ENDBACKUP;'

-

---

alter database datafile 1 end backup;

alter database datafile 2 end backup;

alter database datafile 3 end backup;

alter database datafile 4 end backup;

alter database datafile 5 end backup;

alter database datafile 6 end backup;

alter database datafile 7 end backup;

alter database datafile 8 end backup;

alter database datafile 9 end backup;

alter database datafile 10 end backup;

alter database datafile 11 end backup;

'ALTERDATABASEDATAFILE'||FILE#||'ENDBACKUP;'

-

---

alter database datafile 12 end backup;

alter database datafile 13 end backup;

alter database datafile 14 end backup;

alter database datafile 15 end backup;

alter database datafile 16 end backup;

alter database datafile 17 end backup;

alter database datafile 18 end backup;

alter database datafile 19 end backup;

when we execute above script we are getting following errors;

alter database datafile 1 end backup

*

ERROR at line 1:

ORA-01235: END BACKUP failed for 1 file(s) and succeeded for 0

ORA-01234: cannot end backup of file 1 - file is in use or recovery

ORA-01110: data file 1: '/oracle/TBP/sapdata1/system_1/system.data1'

alter database datafile 2 end backup

*

ERROR at line 1:

ORA-01235: END BACKUP failed for 1 file(s) and succeeded for 0

ORA-01234: cannot end backup of file 2 - file is in use or recovery

ORA-01110: data file 2: '/oracle/TBP/sapdata1/undo_1/undo.data1'

alter database datafile 3 end backup

*

ERROR at line 1:

ORA-01235: END BACKUP failed for 1 file(s) and succeeded for 0

ORA-01234: cannot end backup of file 3 - file is in use or recovery

ORA-01110: data file 3: '/oracle/TBP/sapdata1/sysaux_1/sysaux.data1'

alter database datafile 4 end backup

*

ERROR at line 1:

ORA-01235: END BACKUP failed for 1 file(s) and succeeded for 0

ORA-01234: cannot end backup of file 4 - file is in use or recovery

ORA-01110: data file 4: '/oracle/TBP/sapdata2/sr3_1/sr3.data1'

alter database datafile 5 end backup

*

ERROR at line 1:

ORA-01235: END BACKUP failed for 1 file(s) and succeeded for 0

ORA-01234: cannot end backup of file 5 - file is in use or recovery

ORA-01110: data file 5: '/oracle/TBP/sapdata3/sr3700_1/sr3700.data1'

How can we take datafile out of backup mode ?

Regards

Atakan

[Former Member · Accepted solution]

Hi,

You can take out tablespace from backp mode from below sql.

SQL>ALTER TABLESPACE <tablespace name> END BACKUP;

Check

Hope this helps

Thanks

Sushil

[Former Member]

Yes the only option is thr(Alter Tablespace) which is suggest by mr. Suryavanshi.

Once the prev. backup will be stoped u can start backup once again,

Thanks

Presu

[former_member633852]

Thx Sushil,

alter tablespace end backup works,

Thx