| Options of starting oracle......... [message #265294] |
Thu, 06 September 2007 01:42  |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
