Home » RDBMS Server » Server Administration » Options of starting oracle.........
Options of starting oracle......... [message #265294] Thu, 06 September 2007 01:42 Go to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

When i was studying, Options of starting oracle i found that:-

The existence of datafiles, redolog files and the consistency of the database(ckecked for same SCN in datafile header and control file) are checked in OPEN stage, by following steps:-
1) I shutdown the database.
2) Changed one of the datafile name by operating system command.
3) Issued following command:-

SQL> startup mount pfile=C:\oracle\admin\Venkat\pfile\Third.ora;
ORACLE instance started.

Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
Database mounted.


4) Database got mounted.
5) When i tried to open the database it gave error:-
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 9 - see DBWR trace file
ORA-01110: data file 9: 'C:\ORACLE\ORADATA\VENKAT\NAVDBF.DBF'


that means the existence of datafiles, redolog files and the consistency of the database(ckecked for same SCN in datafile header and control file) are checked in OPEN stage.

Question:-
Then what exactly happens in MOUNT stage.I read that control files are read in MOUNT stage, then what oracle does after reading the control file in MOUNT stage.
I am really confused by the meaning of "MOUNT the database".

Please guide me.

Regards,
Naveen
Re: Options of starting oracle......... [message #265295 is a reply to message #265294] Thu, 06 September 2007 01:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Mounting the database means load the database instances in memory but not open any data file.
Re: Options of starting oracle......... [message #265301 is a reply to message #265295] Thu, 06 September 2007 01:54 Go to previous messageGo to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi Arju,

Mounting the database means load the database instances in memory but not open any data file.
I am not understanding this one because instance is started in NOMOUNT stage only.

Regards,
Naveen

[Updated on: Thu, 06 September 2007 01:55]

Report message to a moderator

Re: Options of starting oracle......... [message #265312 is a reply to message #265294] Thu, 06 September 2007 02:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

1.STARTUP NOMOUNT - brings up the instance or in other words the sga and background processes. This is mode startup in when wanting to create the database. No files are necessary to perform this startup, except the spfile or pfile.

2.STARTUP MOUNT - performs a 'nomount' then opens the control file. This is mode you startup in when wanting to perform recovery, or to rename some of the database files, such as system tablespace or log files.

3.STARTUP OPEN - performs a 'nomount', then a 'mount', then it opens all the database files, including the redo log files. This is mode needed inorder to access an data within the database.
Re: Options of starting oracle......... [message #265317 is a reply to message #265294] Thu, 06 September 2007 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you read Database Concepts instead of posting and posting and posting questions that are answered in this book?

Regards
Michel
Re: Options of starting oracle......... [message #265325 is a reply to message #265294] Thu, 06 September 2007 02:22 Go to previous messageGo to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi,

Thank you for all of your answers. It has helped me a lot.

Regards,
Naveen
Re: Options of starting oracle......... [message #265340 is a reply to message #265325] Thu, 06 September 2007 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I remark that you still don't post the answers you got from other forums and that can help readers of this forum.

http://www.orafaq.com/forum/mv/msg/88502/264170/102589/#msg_264170

Regards
Michel
Re: Options of starting oracle......... [message #265362 is a reply to message #265340] Thu, 06 September 2007 03:14 Go to previous messageGo to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi Michel,

Dont worry Michel i will not post any questions.

Regards,
Naveen
Re: Options of starting oracle......... [message #265383 is a reply to message #265362] Thu, 06 September 2007 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm not worry, I just wish you change to a kind person.
You receive help why don't you want to share with others?

Regards
Michel
Re: Options of starting oracle......... [message #265398 is a reply to message #265383] Thu, 06 September 2007 04:39 Go to previous messageGo to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi Michel,

http://www.dbapool.com/forumthread/topic_7727.html

Once please check this link michel yesterday only i replied to this mail, how much i know i will definitely share my ideas. Please dont be so harsh to any one.

Regards,
Naveen
Re: Options of starting oracle......... [message #265422 is a reply to message #265398] Thu, 06 September 2007 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Why not here?
Re: Options of starting oracle......... [message #265430 is a reply to message #265422] Thu, 06 September 2007 05:34 Go to previous messageGo to next message
naveenkumar001
Messages: 62
Registered: July 2007
Location: Bangalore
Member

Hi Michel,

I thought in both forums answers were same so i dint post.

Regards,
Naveen
Re: Options of starting oracle......... [message #265431 is a reply to message #265294] Thu, 06 September 2007 05:36 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Start with one forum while posting as well as answering as a beginner.
Previous Topic: Recovering a lost schema password
Next Topic: calculating maxextents for rollback segments.
Goto Forum:
  


Current Time: Tue Dec 06 04:46:13 CST 2016

Total time taken to generate the page: 0.08415 seconds