skip to main content

SAP NetWeaver Newbie

End Backup on Oracle Database

If the BRBACKUP terminates before completion, it may leave the tablespace in backup mode. You can check this using txn DB02 --> Current Sizes (in Tablespaces). The last column Backup should show "NOT ACTIVE".

To take them out of backup mode, you may run the following commands from sql prompt.


spool endbackup.lst
select distinct 'alter tablespace ' || tablespace_name || ' end backup;' from v$backup, dba_data_files where v$backup.status='ACTIVE' and v$backup.file#=file_id;
spool off
start endbackup.lst


Remove the lock file (/oracle/SID/sapbackup/.lock) left due to termination.

No comments:

Post a Comment

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.