- 浏览: 25989 次
- 性别:
- 来自: 北京
最新评论
1.type of checkpoint
full checkpoint alter system checkpoint
incrimental checkpoint(logfile switch) alter system switch logfile.
partial checkpoint alter tablespace backup/online/offline
2.phases of instance recovery
1.chek asydatafiles.
2.cache rocovery(roll forward withredo),open database.
3.transaction recovery(roll back uncommited).
4.commited datas in the datafiles.
3.RBA:every three second, checks record the RBA from the oldest entry in the checkopint quene in the control file.only in the event of a log switch,check wirte this formation to the headers of the datafiles.
logfile switch does not force all dirty buffers to be written to disk.
4.Crash recovery is used to recover from a failure either when a single-instance
database crashes or all instances of an Oracle Real Application Clusters database
crashes. Instance recovery refers to the case where a surviving instance recovers a
failed instance in an Oracle Real Application Clusters database.
5.tunning the duration of instance recovery, control the check redo blocks
fast_start_mttr_target
log_checkpoint_timeout
log_checkpoint_interval
fast_start_io_target
v$instance_recovery
v$fast_start_servers
v$fast_start_transactions
6.tunning the phases of the roll forward and roll back
1.recovery_parallelism
2.fast_start_parallel_rollback (false,lo,hi)
3.v$fast_start_servers; v$fast_start_transactions
6.MTTR:mean time to recovery
MTBF:mean time between failures
7.
发表评论
-
from string get number data using pl/sql or sql
2012-02-16 17:32 852declare @aa varchar(80),--- ... -
SQL
2012-02-15 18:01 6841.select sal salary from emp; ... -
modify ip
2012-02-10 17:45 7551.netconfig 2./etc/sysconfig/n ... -
MULTI dbwr or io slaves
2012-02-10 15:21 848thanks dukope of itpub. ... -
FAQS
2012-02-09 15:59 7091.How can I get the largest amo ... -
HOW TO STUDY ORACLE FROM Yong Huang
2012-01-18 14:48 766Assuming you want to study orac ... -
RMAN
2012-01-14 17:07 6591.components of the rman ... -
STARTUP PFILE=
2011-12-31 14:11 11211.vi initdbs.ora spfile=&quo ... -
MANAGE TABLE
2011-12-26 16:50 5361.heap table IOT PARTI ... -
MONITOR redo size
2011-12-21 17:48 6181.set autot on stat 2.unsin ... -
What do rollback and commit
2011-12-21 11:21 708When we COMMIT, all that is lef ... -
What is the schema ?
2011-12-20 15:18 557A schema is a collection of dat ... -
MANAGE UNDOTABS
2011-12-19 17:15 6551.manual undo_management=ma ... -
DBA SQL
2011-12-19 15:21 4131.select a.name,b.status from v ... -
SEGMENT EXTENTS ORACLEBLOCK
2011-12-15 16:11 7611.SEGMENT: allocated fo ... -
MANAGE TABLESPACE AND DATAFILES
2011-12-13 15:28 5401. tablespace,segment,extent,bl ... -
ORACLE NET
2011-12-12 09:49 6581.net_service_name: servive ... -
SQLPLUS TIPS
2011-12-09 17:51 8691.SQLPLUS : a tool that execute ... -
ORACLE ENVIRONMENT VARIABLES
2011-12-09 17:15 626ORACLE_HOME ORACLE_SID : or ... -
Exam Test1
2011-12-09 16:18 6101.utl_file_dir: indicate the di ...
相关推荐
like instance segmentations and depth-maps, can be obtained by simply rendering our output 3D scene model. We exploit class-specific shape priors by learning a low dimensional shape-space from ...
Create your IBM Cloud account and Provision your Database instance
Create and configure an AlwaysOn failover clustered instance Implement AlwaysOn Availability Groups and appropriately configure them Administer AlwaysOn technologies post implementation Troubleshoot ...
文章名称:SimpleDet: A Simple and Versatile Distributed Framework for Object Detection and Instance Recognition,有需要的可以下载。
Of late, neural networks and Multiple Instance Learning (MIL) are both attractive topics in the research areas related to Artificial Intelligence. Deep neural networks have achieved great successes in...
UML-Instance.pptUML-Instance.pptUML-Instance.pptUML-Instance.ppt
Instance-Based Learning
RAC to Single Instance指导
OrCAD中Instance和Occurrence属性的区别~`
启动配置文件( start_<instance><instance_number>_<hostname> )
Linux下刪除Oracle Instance
环境表述: oracle11gR2数据库安装在虚拟机(CentOS5.5 64bit)上,数据库名orcl,有用户test。虚拟机IP 192.168.128.101 物理机(Windows7 64bit)上没有... PL/SQL通过instance client连接到虚拟机上的数据库orcl
实例配置文件( <SID>_<instance><instance_number>_<hostname> )
PLSQL及对应版本的instance 记得修改自己的tnsname及plsql的工具-->首选项里面加载oci
数据库的应用如果想实现,数据库和数据库Instance是缺一不可的, 如果只有数据库的那些文件,那么,只能代表数据在这个文件中,但是我们无法直接进行操作。而如果只有数据库Instance,那么我们虽然可以急性操作, ...
oracle简易客户端配置instanceclient
Java中new关键字和newInstance() 的区分。
instance retrieval (实例检索).md
SAP ECC 6.0 Dialog Instance的安装