What to do if Backup terminated in the middle or terminated manually?

f backup terminates due to some problem, the tablespaces which was in backup mode, doesn’t come back to end backup mode.

So when you rerun the backup or backup job is re-submitted it throws error stating that tablespaces are already in backup mode.

So to bring the table space from begin backup mode to end backup mode follow the following steps.

Before:

Login to SAP system using ORA (Unix) or adm

# sqlplus “/ as sysdba”

SQL> select * from v$backup where status= ‘ACTIVE’;

The above statement checks how many tablespaces are in backup mode and listed them out with STATUS = ACTIVE.

SQL> alter table space end backup;

After:

SQL> select* from v$backup where status=’ACTIVE’;

If nothing comes up, then all tablespaces are normal. If any table space name come up then issue the above command to bring that table space into end backup mode.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk