database offline

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Thames - 31 Aug 2005 07:43 GMT

How can I take database offline(command window) before performing
backup and restoring operations?

Thanks

Reply to this Message

Thames - 31 Aug 2005 07:45 GMT

further question:
what is full offline backup of the database?
How can I do that

Reply to this Message

siva - 31 Aug 2005 22:27 GMT

you need to force all the applications connected to the database and
deactivate before doing offline backup. This way all the activites are
written to active log and create a consistent point..
Here is the command for offline backup..
backup database test to /dir/filename

~ Siva
IBM Certified DBA

Reply to this Message