Re: How to determine if a database is in use?

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: NO-AUTO-REPLIES_WW <no-auto-replies_ww@xxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 13 Apr 2016 15:19:33 -0400

On 04/13/2016 03:13 PM, raza siddiqui wrote:

Always worth starting with the basics. However, this may only be relevant if the database is accessed at the time the offline backup is taken. If you backup and leave down, you might have to wait til an End of Week / Month, Quarter or Year cycle to really determine if that particular instance is accessed during those fiscal (or other) periods.

Well, I'd say that "drop database" will pretty much leave it down. The cold backup will enable you to bring it up.

--
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com

Other related posts: