Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Reply to this topicStart new topic
> Make tablespace offline in mount state
post May 7 2012, 03:17 AM
Post #1


Group: Members
Posts: 4
Joined: 10-April 12
Member No.: 47,064


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 ...???
Go to the top of the page
+Quote Post
post May 7 2012, 07:21 AM
Post #2

Advanced Member

Group: Members
Posts: 13,573
Joined: 26-January 04
Member No.: 13

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.

Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 20th October 2017 - 09:00 AM