Q

How to do a clean shutdown while still in backup mode

Scenario: - Oracle (805 on NT4) online backup in progress. (scheduled via SAPDBA - using backint to Acrcserve) - Power failure - Current UPS scripts allow for SAP shutdown. Question: How do I do a clean shutdown of Oracle while all the tablespaces are still in a backup mode. If I do a shutdown immediately, it will sit there and wait for the backup to finish. I need the backup to cancel immediately and shut the database down. I do not...

really want to do a shutdown abort...


1. Crash the database, e.g. shut the power down.
2. Take the tablespaces out of backup mode using a script, and then shut the database down.

Alter database [tablespace] end backup;
(For each tablespace in your database using svrmgrl)

If you crash while in backup mode, you will have to take EACH DATAFILE (not tablespace) out of backup mode when you try to restart Oracle. I would recommend that you script this ahead of time, since some databases routinely have hundreds of datafiles. Sapdba might allow for this I am not sure.


This was first published in May 2002

Dig deeper on SAP security administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close