Saturday, July 3, 2010

Database Shutdown Process - Oracle

1. Connect to O/S (UNIX) using ora(SID)
2. Connect database #sqlplus "/as sysdba"
3. Check database name and database open mode
SQL) select name, open_mode from v$database;
4. Check database backup status using following command
SQL) select * from v$backup;
If status in not active then you may shutdown database using command
SQL) shutdown immediate
If status is active state then first cancel backup using command
SQL) alter database end backup;
after successful execution of this command database can be shutdown using command
SQL ) shutdown immediate;

5. Check any backint process in O/S level using command
$ps -ef grep backint grep ora(SID)
6. If there exists any process kill using following command
#kill -9 (PID)

No comments: