I have applied the following commands:Shutdown abortstartupNow what will happen, will the database will give an error / it will work.

Mohammed Nadeem

• Feb 12th, 2015

There will be the mismatch with SCN in header combining with Datafiles and controls files hence needed instance recovery which is automated by SMON

Mohammad Mubasheer Ahmed

• Jan 26th, 2015

Database will be down abruptly without writing the committed data to data files. When it is brought up, SMON will automatically perform instance recovery be scanning the online redo log files.

Answer Question  Select Best Answer

How to check whether database whether it is opened by pfile/spfile.

Kapil Relan

 Profile Answers by Kapil Relan Questions by Kapil Relan

• Apr 15th, 2011

if you are not aware about what your database has chosen at startup ie PFILE or SPFILE you can simply try the following SQL statement:,which i tried create spfile from pfile;if you get the output that...

clevelcd

 Profile Answers by clevelcd Questions by clevelcd

• Jun 5th, 2008

Another alternative: SHOW PARAMETER SPFILE;

Answer Question  Select Best Answer