Contribute  :  Calendar  :  Advanced Search  :  Site Statistics  :  Directory  :  Web Resources  :  Polls  
    Peoplecnc.com ERP and Technical Documentation    
advanced search  
Oracle ERP1
JDEdwards
Topics
Home
General News (1/202)
ERP White Papers (0/225)
JDEdwards - Peoplesoft - Oracle ERP1 White Paper (9/218)
Oracle Documentation and White Papers (19/456)
Oracle DBA Commands (1/222)
Webserver / Apache (2/232)
User Functions
:

:

Don't have an account yet? Sign up as a New User
Lost your password?
Events
There are no upcoming events
Older Stories
Wednesday 17-May
Thursday 11-May
Wednesday 10-May
Monday 08-May
 Welcome to Peoplecnc.com
 Wednesday, September 08 2010 @ 07:13 AM CDT

How to start and change the status of an Oracle database

    
Monday, May 08 2006 @ 02:29 PM CDT
Contributed by: sv800
Views: 7,841
Oracle Documentation and White PapersCommand description to open, change status an Oracle database

Oracle databases statuses sequence:

SHUTDOWN -> NOMOUNT -> MOUNT -> OPEN

- SQL*Plus should be used to issue the STARTUP and SHUTDOWN commands
- A SHUTDOWN command is required after STARTUP command, even if errors were found during a startup process.

- To startup to OPEN status:

-----
STARTUP
-----

- To startup with a specific PFILE:

-----
STARTUP PFILE=$ORACLE_HOME/dbs/initdb01.ora
-----

- To startup to other statuses :

-----
STARTUP NOMOUNT
-----

(No access to the Oracle database)

-----
STARTUP MOUNT
-----

(Mount the Oracle database for DBA activities)

Optional: the Enterprise Manager can be used to startup an Oracle Database



Altering the Oracle database status

Changing the status MOUNT, to prevent the database from being modified by users:

ALTER DATABASE MOUNT;

Changing the database to status open

ALTER DATABASE OPEN;

Changing the database status to READ ONLY, this status prevents transaction generating online REDO LOGS

ALTER DATABASE OPEN READ ONLY;


READ ONLY STATUS FOR AN ORACLE DATABASE
Eventually, an Oracle database can be “read only” status.
Why? In case that the database crashes, the DBA can perform the execution of selected queries. Some additional setting is required for query performing “sorts”.


STARTUP MOUNT
ALTER DATABASE OPEN READ ONLY;

If the database is in read-only status and a sql insert (or update statement) is executed, an error message appears:

<cannot use system rollback segment for non system tablespace>

Then the database status should be changed to read-write

ALTER DATABASE OPEN;
 
What's Related

Story Options

 Copyright © 2010 Peoplecnc.com
 All trademarks and copyrights on this page are owned by their respective owners.		 Powered By Geeklog 
Created this page in 0.02 seconds