Shulou(Shulou.com)06/01 Report--

This start-stop specification applies to a single instance database.

one。 Start the database:

Sqlplus / as sysdba

SQL > startup

After starting successfully, start listening

Lsnrctl status

After the monitoring is started, dynamic monitoring needs to wait about one minute before the service can be registered successfully. Or manually issue alter system register in SQLPLUS

two。 Shut down the database:

Stop the application

Stop listener

Ps-ef | grep LOCAL | wc-l

[oracle@r11g ~] $lsnrctl stop

Check to see if there is a JOB-- if necessary to determine if it is stopped.

Ps-ef | grep ora_j

Check to see if there are any transactions that have not yet been committed-- if there are transactions that have not been committed, confirm whether you need to wait for the transaction to complete.

Sqlplus'/ as sysdba'

Select instance_name,status from v$instance

Select open_mode,name from v$database

Is there a big query going on?

Select count () from v$transaction

Select count () from v$session_longops where time_remaining > 0

Is there something big going on?

Select sum (used_ublk) from vested transaction;-if there are a large number of returns, please refer to the end of this article

Select to_char (start_time,'yyyy/mm/dd hh34:mi:ss') start_t from v$transaction

Is there a transaction that requires instance recovery during database OPEN

Select from v$fast_start_transactions

And/or

Select from v$fast_start_servers

Manually switch log

SQL > alter system switch logfile

SQL > /

System altered.

SQL > /

System altered.

Do checkpoint

The aim is to write dirty data to the data file to avoid data loss and reduce the phenomenon that the shutdown can not be started.

SQL > alter system checkpoint

SQL > /

System altered.

SQL > /

System altered.

SQL > /

System altered

Close the library

SQL > shutdown immediate

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.