Help - Search - Members - Calendar
Full Version: Make tablespace offline in mount state
Oracle DBA Forums > Oracle > Oracle Forum

Can anybody let me know

I started database in mount state;

startup mount;

alter tablespace users offline;

I tried to make tablespace offline
In another case online

but showing error database not open
same for command alter tablespace begin backup;

I do think we can make tablespace offline in mount...

Pls let me what activties can b performed on mount state ...???
Hi Rakesh,

>> let me what activties can b performed on mount state ...??

The docs note:

You can start an instance, and optionally mount and open a database, in restricted mode so that the instance is available only to administrative personnel (not general database users). Use this mode of instance startup when you need to accomplish one of the following tasks:

  • Perform an export or import of data
  • Perform a data load (with SQL*Loader)
  • Temporarily prevent typical users from using data
  • Perform certain migration or upgrade operations

When the startup command enters the mount stage, it opens
ad reads the control file. The control file is a binary file that tracks
important database information, such as the location of the database datafiles.In the mount stage, Oracle determines the location of the datafiles, but does not yet open them. Once the datafile locations have been identified, the database is ready to be opened.

Most folks use "startup mount" for moving to ARCHIVELOG MODE.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2016 Invision Power Services, Inc.