1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

How to make datafiles offline?

How to make datafiles offline?

First of all, why you want take the datafile offline/online in the first place. You need to take datafile offline for the reason below:

You need relocate/rename your datafile
Your datafile is missing/corrupted. So you need to take it online so that you can startup your database
Or you want to perform offline datafile backup
To do this, you can use this command

alter database datafile '/datafile/file01.dbf' offline

Take note the above statement only can be used when your database is in archivedlog mode. The reason is, if the database is noarchivedlog mode, the datafile can be missing/deleted. By only allow to use the statement in only archivedlog mode, it will prevent you from losing the datafile.


When you need to take datafile offline, you can the below statement instead.

alter database datafile '/oracle/datafile/file01.dbf' offline for drop

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy