Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

performance Tuning 10g reference poster
 
Oracle training in Linux 

commands
 
Oracle training 

Excel
 
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
RAKESH S
post May 7 2012, 03:17 AM
Post #1


Newbie
*

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



Hi,

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
burleson
post May 7 2012, 07:21 AM
Post #2


Advanced Member
***

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



Hi Rakesh,

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

http://www.dba-oracle.com/t_startup_mount_tasks.htm


The docs note:

QUOTE
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: 18th April 2014 - 08:57 AM