clevelcd

 Profile Answers by clevelcd 

• Jun 5th, 2008

 

Yes,  Given no other factors, the database will start up without issue.  You killed all sessions, killed all transactions, and didn't write from the buffers.   Note that instance recovery will take place during startup.

rajesh.dba9i

 Profile Answers by rajesh.dba9i 

• Feb 16th, 2010

 

Definately database will be start without error but all uncommitted data will be lost because shutdown abort directly shutdown instance without comitting.

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Feb 19th, 2010

 

Dear ,

        Four modes to shutdown the database:

1) Shutdown immediate
2) Shutdown normal
3) Shutdown transactional
4) Shutdown abort

        when the database is shutdown by first 3 methods checkpoint takes place.
But when is shutdown by abort option it doesn't enforces checkpoints. It simply shutdowns without waiting any users to disconnect. 

         To conclude , it requires recovery. It will not startup normally.......


Regards
Dharmendra Jaiswal

prahlad_786

 Profile Answers by prahlad_786 

• Jun 25th, 2010

 

Shut abort will kill all the transaction.  When Start up, It need Instance recovery to Bring up the database.

yogesh chadnae

• Oct 25th, 2011

 

no oracle will not give u an error but it will perform media recovery between mount and open stage.
let me describe this
their are 4 modes of shuttin down the database

WaitForTransaction WaitForUserSession AllowedNewConnection Checkpoint
1.shutdown normal yes yes no yes
2.shutdown transactional yes no no yes
3.shutdown immediate no no no yes
4.shutdown abort no no no no

when u fire shutdown(normal , transactional , immediate) in this case checkpoint occures and oracle makes datafile and controlfile consistant and the last scn and checkpint is written to controlfile and datafiels . and at time of restarting database oracle will found the same scn and checkpoint in controlfile and datafiles means this is consistant so no need of recovery.
but when shutdown abort no scn and checkpoint is generated so that datafiles scn and controlfile scn do get time to be consistant , here at restart up database oracle will find missnatch in controlfile scn and datafile scn , and will perform media recovery from online redo log file with the help of SMON back ground process

karthik

• Jun 18th, 2014

 

Shut down Abort==> immediately shuts down the database.
statup now==> no startup avail like this.
starup force ==> shutdown abort + startup

ARNAB

• Aug 3rd, 2014

 

materialized view enhance performance of query in distributed sites. materialized view replicate data and create a local copy of same. so in the runtime querys use the local data and avoid network trafficking, and query performance improved hugely.

2) By using materialized view you can avoid complex time taking computation in the runtime of the query. you can update materialized views in the odd hours when load of the database is less by doing the complex computation. If you use normal view instead of the materialized view then complex computation will occur in the runtime of the query and the query performance will degrade.

3) You can also use materialized views to download a subset of data from central servers to mobile clients, with periodic refreshes and updates between clients and the central servers.

syed fahad

• Sep 13th, 2014

 

If a database is shut down with shutdown database command than all the SGA and background process will stop it releases memory after we startup the database the SGA and background process will start

vishal

• Sep 25th, 2014

 

Hi,
Database would not start normally,
We need to do Instance recovery using SMON.

Regards,
Vishal

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.

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