Single Instance DB Maintenace Activities Steps

DB SERVER MAINTENANCE STEPS

Here are the steps that describes step by step activities to be performed before doing any maintenance on the Server or database.

Step-1
    Take a backup of Database to outside the server environment.

Step-2 After backup job completed, Shutdown database
 enter into oracle user

$sqlplus '/as sysdba'
sql>shutdown immediate

Wait until database shutdown normally 

Step-3 Shutdown database listener
 $lsnrctl stop 

Step-4 Now you can restart the server 
Then do your activities.

After  completion of activities 

Step -5 restart the server
 #shutdown -r

 Step-6: Start the database 

$sqlplus '/as sysdba'
sql>startup

after startup

Step-7 start the listener
$lsnrctl start


Hope you can use it.