注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

陈钟鸣的博客

独立之精神,自由之思想.

 
 
 

日志

 
 

oracle-startup & shutdown  

2008-06-23 08:56:02|  分类: oracle |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Start:

start instance:(nomount)
    1.Reading the init file from $ORALCE_HOME/dbs in the following order:
        a.first spfileSID.ora
        b.If not found then, spfile.ora
        c.If not found then, initSID.ora
    2.Allocating the SGA
    3.Starting the background processes
    4.Opening the alertSID.log file and the trace file.
Mounting the database(Mount)
    you start an instance and mount a database but do not open the database.
    For example,the database must be mounted but not open during the following tasks:
    
    1.Renaming data files(data files for an offline tablespace can be renamed when the database is open)
    2.Enabling and disabling online redo log file archiving options.
    3.performing full database recovery.
    
    Mounting a database includes the following tasks:
    1.Associating a database with a previously started instance.
        把数据库与预先启动的实例联合在一起.
    2.Locating and opening the control files specified in parameter file.
        定位与打开parameter file里指定的controlfile.
    3.Reading the control files to obtain(获得) the names and status of the data files and online redo log files.
        However,no checks are performed to verify the existence of the data files and online redo log files at this time.
        
Opening the Database(OPEN)
    1.Opening the online datafiles;
    2.Opening the online redo log files.
    

Shutdown
    shutdown abort|imeediate|transactional|normal
    
shutdown normal
    is the default shutdown mode.Normal database shutdown processds with the following conditions:
    1.No new connections can be made.
    2.The Oracle server waits for all users to disconnect before completing the shutdown.
    3.Database and redo buffers are written to disk.
    4.Background processes are terminated(结束),and the SGA is remvoed form memory.
    5.oralce closes and dismounts the database before shutting down the instance.
    6.The next startup does not require(需要) an instance recovery.
    
shutdown transactional
    A transactional shutdown prevents(预防) clients from losing work.A transactional database shutdown processds with following conditins:
    1.No client can start a new transaction on this particular instance.
    2.A client is disconnected when the client ends the transaction that is in progress.
    3.When all transactions have finished,a shutdown occurs(执行,重现) immediately.
    4.The next startup does not require an instance recovery.
    
shutdown immediate
    Immediate database shutdown processds with the following conditions:
    1.Current SQL statements beging processed by Oracle are not completed.
    2.The Oracle server does not wait for the users,who are currently connected to the database,to disconnect.
    3.Oracle rolls back active transactions and disconnnects all connected users.
    4.Oracle closes and dismounts the database before shutting down the instance.
    5.The next startup does not require an instance recovery.
    
shutdown abort
    If the normal and immediate shutdown options do not work,you can abort the current database instance.
    Aborting an instance proceeds with the following conditions:
    1.current sql statements beging processed by the Oralce server are immediately terminated.
    2.database and redo buffers are not written to disk.
    3.uncommitted transactions are not rolled back.
    4.the instance is terminated without closing the files.
    5.the database is not closed or dismounted.
    6.the next startup requires instance recovery,which occurs(重现) automatically.
  评论这张
 
阅读(63)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017