Topic: Database Administration >> Options of starting oracle.........
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Options of starting oracle......... |
| Navi |
Posted: Sep 06, 2007 02:35:17 AM |
Total Post: 60
Joined: Jun, 2007
|
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
|
|
|
 Mohammed Taj |
| Posted: Sep 06, 2007 06:42:20 AM |  |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
when database is mount stage then controlfile is read and Oracle reads the controlfile to get name of the datafiles and redolog files.
when database going to then all datafiles or redolog files physically exists on filesystem if not then you will get error otherwise database open for normal use.
Regards
Taj
|
|
|
|
|
| nick |
| Posted: Sep 11, 2007 11:31:23 AM | |
|
Total Post: 30
Joined: Sep, 2007
|
In mount stage the information about datafiles and redo files are read from the control file. While opening the database, database actually locate the files as per the locations specified in controlfiles and if not found, it will return an error.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
