Oracle数据库检查表
最新oracle巡检报告模板
最新oracle巡检报告模板篇一：Oracle 数据库深度巡检报告南方基地RAC数据库深度检查报告上海新炬网络技术有限公司XX年08文档控制此文档仅供新炬公司与最终用户审阅，不得向与此无关的个人或机构传阅或复制。
修改记录分发者审阅记录相关文档1、数据库相关AWR报告 1. 实例rac1: awrrpt_1_11063_ awrrpt_1_11129_ 2. 实例rac2: awrrpt_2_11063_ awrrpt_2_11129_目录文档控制 ................................................ ................................................... (2)修改记录 ................................................ ................................................... .. (2)分发者 ................................................ ................................................... (2)审阅记录 ................................................ ................................................... .. (2)相关文档 ................................................ ................................................... .. (2)目录 ................................................ ................................................... .. (2)1. 检查介绍 ................................................ ................................................... (5)2. 检查系统 ................................................ ................................................... ............5 检查方法 ................................................ ................................................... ............5 检查范围 ................................................ ................................................... ............5 检查总结 ................................................ ................................................... . (7)概要 ................................................ ................................................... ....................7 总结建议 ................................................ ................................................... ............7 主机性能指标 ................................................................................................... ....7 数据库性能指标 ................................................ ...................................................83. 硬件配置 ................................................ ................................................... . (9)主机配置 ................................................ ................................................... ............9 共享内存参数 ................................................ ..................... 错误！未定义书签。
ORACLE巡检表
WHERE t.owner = i.table_owner
AND t.segment_name = i.table_name)
AND t.segment_type IN ('TABLE', 'TABLE PARTITION')
AND t.owner NOT IN ('SYS', 'SYSTEM')
Oracle数据库打开状态检查
SELECT inst_id, dbid, NAME,
TO_CHAR(created, 'yyyy-mm-dd hh24:mi:ss') created, log_mode, TO_CHAR(version_time, 'yyyy-mm-dd
hh24:mi:ss') version_time, open_mode FROM
select owner,object_name,object_type,status from dba_objects where owner like 'FOUNDER' and status not like 'VALID';
SELECT object_id, owner || '.' || object_name object_name, object_type, status, TO_CHAR (created, 'yy-mm-dd hh24:mi:ss') created, TO_CHAR (last_ddl_time, 'yy-mm-dd hh24:mi:ss') last_ddl_time FROM all_objects WHERE status != 'VALID';
Oracle数据库健康检查及其评估
O RACLE数据库健康检查及其评估XXXXXOracle数据库健康检查与评估XXXX巡检人：报告生成日期：yyyy-mm-dd文档操纵此文档仅供江苏移动批阅，不得向与此无关的个人或者机构传阅或者复制。
修改记录分发者批阅记录有关文档目录文档操纵 (2)修改记录 (2)分发者 (2)批阅记录 (2)有关文档 (2)目录 (3)1.检查介绍 (5)1.1检查系统 (5)1.2检查范围 (5)2.硬件配置 (7)2.1主机配置 (7)3.系统配置 (8)3.1操作系统数据库有关要求补丁 (8)3.2硬盘可用空间 (8)3.3CPU 利用率 (8)4.数据库配置 (10)4.1数据库版本与单独补丁 (10)4.2CRS版本与单独补丁 (10)4.3ORACLE CLUSTER配置 (10)4.4数据库产品选项 (10)4.5初始化参数文件 (11)4.6CRS日志文件 (11)4.7RDBMS运行日志与跟踪文件 (11)4.8操纵文件 (11)4.9Redo log 文件 (12)4.10归档Redo log 文件 (12)4.11数据文件 (13)4.12表空间 (14)4.13回滚段管理 (15)5.数据库简单风险评估 (16)5.1安全性管理 (16)6.SqlNet 概况 (17)6.1监听器Listener (17)6.2SQL*Net (17)6.3TNSNAMES (17)7.数据库性能 (18)7.1数据库各项基于时间模型的统计信息 (18)7.2数据库负荷压力分析 (19)7.3各项命中率 (19)7.4等待事件 (20)7.5统计信息分析 (20)7.6数据库I/O性能 (21)7.7索引/行迁移/行链 (21)7.8Enqueue等待分析 (21)7.9Latch分析 (21)7.10Resource Limit分析 (22)7.11Top SQL语句 (22)8.数据库备份策略评估 (23)8.1备份 (23)8.2恢复 (23)9.数据库特别关注点检查 (24)10.检查总结 (25)附录:初始化参数 (26)数据库所有非默认值的参数： (26)1.检查介绍1.1检查系统系统要紧包含1个数据库，具体情况如下：1.2检查范围本次检查仅限于数据库。
Oracle_Database_Checklist
Oracle Database ChecklistPrepared by Pete FinniganReferences:Oracle security step-by-step – A survival guide for Oracle security – Pete Finnigan - SANS Press – April 2004 (version 1.0 and version 2.0)Links to many useful papers and presentations about Oracle security –/orasec.htmOracle security website /deploy/securityOracle Corporation main page Customer support site Security alerts /deploy/security/alerts.htmIntroduction:This checklist is to be used to audit an Oracle database installation. This checklist is just that “a checklist” and does not contain any specific SQL or shell commands because it is intended to be just a list rat her than a “how to” document otherwise. It is also important that the Oracle database is not checked in isolation and the surrounding elements such as the operating system used, the network configuration, web access, application servers and clients are considered.Whilst every effort has been made to ensure that this checklist is as complete and comprehensive as possible new issues and vulnerabilities are found every day therefore don’t rely on it to be all encompassing. Regularly check for updates of this list. Elements to be considered prior to applying this checklist:∙Host Operating System– Although this checklist includes items that specifically relate to the operating system hosting the Oracle installation they are included because they have a direct effect on Oracle. It is imperative that the host operating system is secured before any applications (in this case Oracle). The same applies to network components and other applications hosted on the same servers. Please consult other S.C.O.R.E documents ( /score ), center for internet security (CIS) benchmarks and tools ( ) and SANS step-by-step guides ( ) for more information.∙Procedural – It is important to also consider physical security of the servers hosting the Oracle database and also to employ security procedures and policies and to develop standards for change and control.∙Findings and data sensitivity –Establish the sensitivity of the data stored within the Oracle database and establish rules for reporting any security findings back to the organisation. This should take into account availability, confidentiality and the integrity of the data. This is important to be able to place any findings within the correct context when reporting back results of an audit.∙Practicality of the checklist –This list is the culmination of the knowledge of many Oracle database security practitioners and as such includes every issue thought to be relevant to somebody. To some organisations some items are important to be fixed and to others not relevant because of mitigating circumstances. Oracle can be configured in many differing ways and this affects how it is secured. The list has been provided with severity levels to allow the audit to be conducted to a specified level and also includes OS and Oracle versions relevancies.∙Oracle database security standards - This checklist could also be used to define a company standard for securing Oracle.Before using this checklist to review an Oracle database installation it is important to understand the use to which the Oracle database and applications will be put. How the database is used can have a direct effect on how this list is read and interpreted. Oracle is a complicated beast to configure in any multitude of guises and checks and solutions that are relevant for one installation and type of application will conflict with another. Practicality is called for!Checklist:Before presenting the checklist a few words about what the columns mean. The action column indicates broad sections that checks are grouped into and also includes the action references indicated in the Oracle security step-by-step guide. The severity levels are set between 1 and 5 (1 indicating the highest level). These levels were reached by consensus during the writing of the step-by-step. The O/S column identifies whether Unix or Windows or both can be checked. The Oracle version column indicates the relevant Oracle installation and finally the default install column indicates whether the issue can be considered after a default installation. For ease of identification all of the highest severity issues are indicated by being greyed out.。
Oracle数据库巡检
序号检查内容正常值(参考) 影响因素1 --高速缓存的命中率select round((1 -(physical.value- direct.value- lobs.value) /logical.value) * 100,2) || '%' "高速缓存的命中率"from v$sysstat physical,v$sysstat direct,v$sysstat lobs,v$sysstat logical where = 'physical reads'and = 'physical reads direct'and = 'physical reads direct (lob)'and = 'session logical reads';90%-100%(可能略低于90%在数据库繁忙运行期间)1. Buffer 命中率受OracleSGA中的data blockbuffers参数的设置影响2. 跟Oracle buffer Pool的使用方法有关3. 把经常使用的小表cache在内存中4. 调优SQL语句，以养活少访问的数据量db_cache_size?2 --库缓存的命中率select round(sum(pins -reloads) / sum(pins) * 100, 2) || '%' "库缓存的命中率"from v$librarycache;95%-100%1. Library命中率受OracleSGA中的shared pool参数设置影响2. 跟应用软件的开发有密切的关系，特别是共享SQL的使用3 --闩命中率select round((1 -sum(misses +immediate_misses) / sum(gets + immediate_gets)) * 100,2) || '%' "闩命中率"from v$latch;99%-100%1. 应用程序SQL是否使用绑定变量2. Shared_pool_size参数的设置4 --内存排序率select round((1- disk.value/(disk.value+ memory.value)) *100, 2) || '%' "内存排序率"from v$sysstat disk, v$sysstat memorywhere = 'sorts (disk)'and = 'sorts 99%-100%1. 数据库参数sort_area_size或pga_aggregate_target的大小2. 应用程序的SQL语句的写法(memory)';5 --缓冲区未等待率select round((1- busy.value/tol.value) * 100, 2) || '%' "缓冲区未等待率"from(select sum(count) valuefrom v$waitstatwhere class in('data block', 'segment header', 'undo header', 'undo block')) busy, (select value from v$sysstat where name= 'session logical reads') tol;99%-100%1. db_block_buffers或db_cache_size等参数2. 增加表的Freelist参数3. 使用AutomaticSegment StorgeManagement（ASSM）来创建表空间4. 优化程序使用的SQL语句6 --redo缓冲区未等待率select round((1 - waits.value/ redos.value) * 100, 2) || '%'"redo缓冲区未等待率"from v$sysstat waits, v$sysstat redoswhere = 'redo log space requests'and = 'redo entries';99%-100%1. Log_buffer_size参数设置过小2. 归档的速度太慢3. 联机日志文件太小4. 联机日志文件放在缓慢的磁盘设备上7 --SQL语句执行和分析的比例select round((1- hard.value/total.value) * 100, 2) || '%'"SQL语句执行和分析的比例"from v$sysstat hard, v$sysstat totalwhere = 'parse count (hard)'and = 'parse count (total)';越接近100%越好1. Share_pool_size参数的大小2. 最重要的影响因素是应用程是否使用了绑定变量8 --析的CPU的时间和分析完成CPU时间对比select round((1 - cpu.value /total.value) * 100, 2) || '%'"cpu分析和完成比"from v$sysstat cpu, v$sysstat totalwhere = 'parse time cpu'越接近100%越好1. 如果这个比例很低，说明分析过程中CPU等待了其它的资源and = 'parse time elapsed';9 --非分析的过程中CPU对比select round((1 - parse.value/ total.value) * 100, 2) || '%'"非分析的过程中CPU对比"from v$sysstat parse, v$sysstat totalwhere = 'parse time cpu'and = 'CPU used by this session';越接近100%越好1. 如果这个比例很低，说明CPU用在分析SQL语句上面消耗了很多CPU时间，可能是没有用绑定变量10 --等待rollback segment的header比率select name,waits,gets,round(waits / gets * 100, 2) || '%'"等待rollbacksegment的header比"from v$rollstat a, v$rollname bwhere n = n;rollback segment等待率比率越小越好1. 回滚段竟争情况受回滚段size的设置影响2. 跟应用软件的有关，特别是long runnig timetransaction的使用11 --Tablespace的I/O比例select df.tablespace_name,sum(f.phyrds),sum(f.phyblkrd),sum(f.phywrts),sum(f.phyblkwrt)from v$filestat f, dba_data_files dfwhere f.file# = df.file_id group by df.tablespace_name order by df.tablespace_name;Tablespace I/O越小越好1. Tablespace的I/O情况受db_block_size参数的设置影响2. 跟数据文件的磁盘分布有密切关系12 --Datafile 的I/O比例select ,sum(f.phyrds),sum(f.phyblkrd),sum(f.phywrts),sum(f.phyblkwrt)from v$filestat f, v$datafile dfwhere f.file# = df.file# group by Datafile I/O越小越好1. Datafile的I/O情况受db_block_size参数的设置影响2. 跟数据文件的磁盘分布有密切关系order by ;13 --重做日志缓存区命中率select name,gets,misses,immediate_gets,immediate_misses,100- round(decode(gets, 0, 0,misses / gets * 100), 2) || '%'ratio1,100 -round(decode(immediate_gets + immediate_misses,0,0,immediate_misses / (immediate_gets + immediate_misses) * 100),2) || '%' ratio2from v$latchwhere name in('redo allocation', 'redo copy');重做日志缓存区的命中率越大越好，应大于90%1. 受log_buffer_size设置影响2. 跟应用软件的有关，特别是共享SQL的使用14 --碎片程度select tablespace_name,round(sqrt(max(blocks) /sum(blocks)) *(100/ sqrt(sqrt(count(blocks)))),2) || '%' FSFIfrom dba_free_spacegroup by tablespace_name order by tablespace_name;FSFI越大越好，应大于30%1. 碎片情况受db_block_size,segment_size的设置影响。
ORACLE数据库常规巡检报告单（例子）
ORACLE数据库常规巡检报告单（例⼦）ORACLE数据库常规巡检报告单⽬录ORACLE数据库常规巡检报告单 (1)⼀、概述 (3)⼆、使⽤的相关软件简要说明 (3)三、主机及操作系统常规配置检查 (3)1、系统设置检查 (3)2、I/O 设备信息 (3)3、⽹络配置信息 (4)四、ORACLE 数据库常规检查 (5)1、ORACLE 常规检查 (5)2、基本参数配置 (5)3、ORACLE ⽤户配置⽂件 (6)五、数据库关键性能检查及分析 (6)1、数据库性能检查 (6)2、数据库响应时间分析 (6)六、备份恢复策略检查和维护 (7)1、RMAN 配置情况 (7)2、备份策略描述 (7)3、备份策略实施 (7)4、备份检查和每⽇备份脚本⽇志检查 (8)5、对当前策略的总结 (8)七、关键性SQL 语句定位及分析 (8)⼋、近期警告⽇志及相关分析 (8)1、orcl_ora_8727.trc (8)2、orcl_ora_8727.trc (9)九、⼩结 (9)⼀、概述按照维护计划和为了系统的稳定运⾏，需要定期对系统进⾏⼀次巡检，时间周期为每星期⼀次。
⽬的在于诊断当前环境是否存在安全隐患，系统运⾏是否存在明显的系统瓶颈，定位重要的SQL 语句并进⾏性能分析，分析当前备份策略，分析警告⽇志信息并提供解决⽅案。
⼆、使⽤的相关软件简要说明1．使⽤RDA 对整个系统进⾏检查，并且⽣成报告2．使⽤AWR 对数据库进⾏检查，并且⽣成报告。
3．使⽤RMAN 对数据库进⾏备份，并且使⽤RMAN 相关的功能进⾏备份检查。
相关详细后页提供三、主机及操作系统常规配置检查1、系统设置检查主机和版本号Linux localhost 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64主机名localhost.localdomain操作系统平台64-bit Red Hat Linux操作系统版本 2.6.92、I/O 设备信息3、⽹络配置信息四、ORACLE 数据库常规检查1、ORACLE 常规检查Database OverviewDB Name ORCLGlobal Name /doc/e298af7e4693daef5ef73dba.html Host Name localhost Instance Name orclInstance Start Time 18-Nov-2008 14:14:01Restricted Mode NOArchive Log ModeARCHIVELOG3、ORACLE ⽤户配置⽂件# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHunset USERNAME#for oracleexport ORACLE_SID=orclexport ORACLE_BASE=/oracleexport ORACLE_HOME=/oracle/10gexport PATH=$ORACLE_HOME/bin:$PATHexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBK五、数据库关键性能检查及分析1、数据库性能检查2、数据库响应时间分析响应时间是⾮常重要的数据库性能指标从以上信息可以看出，RMAN 备份占⽤的⼤量的时间，六、备份恢复策略检查和维护1、RMAN 配置情况RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;CONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE DEFAULT DEVICE TYPE TO DISK;CONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'orclcongrol_%F'; CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 100 M MAXOPENFILES 8 RATE 40 M; CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXPIECESIZE 100 M MAXOPENFILES 8 RATE 40 M; CONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/10g/dbs/snapcf_orcl.f'; # default2、备份策略描述选⽤RMAN 多级备份策略,以每个星期作为⼀个周期星期1 数据库全备0 级星期2 增量备份 1 级星期3 增量备份 1 级星期4 累积增量备份1c 级星期5 数据库全备0 级星期6 增量备份 1 级星期天增量备份 1 级基于以上策略,任何时间点的数据恢复只需要做最多1 次0 级恢复和2 次1 级恢复.加上当⽇的归档⽇志可以实现快速的完全恢复3、备份策略实施Cat /etc/crontabSHELL=/bin/bashPATH=/sbin:/bin:/usr/sbin:/usr/binMAILTO=rootHOME=/# run-parts01 * * * * root run-parts /etc/cron.hourly02 4 * * * root run-parts /etc/cron.daily22 4 * * 0 root run-parts /etc/cron.weekly42 4 1 * * root run-parts /etc/cron.monthly00 4 * * 1 oracle /oracle/scripts/rman/backupweek1.cmd &00 4 * * 2 oracle /oracle/scripts/rman/backupweek2.cmd &00 4 * * 3 oracle /oracle/scripts/rman/backupweek3.cmd & 00 4 * * 4 oracle/oracle/scripts/rman/backupweek4.cmd &00 4 * * 5 oracle /oracle/scripts/rman/backupweek5.cmd &00 4 * * 6 oracle /oracle/scripts/rman/backupweek6.cmd &00 4 * * 7 oracle /oracle/scripts/rman/backupweek7.cmd &4、备份检查和每⽇备份脚本⽇志检查使⽤crosscheck backupset 检查。
Oracle完整检查表
分离数据库和操作系统的特权 用户，不能使一个用户权限过
大
对默认的账号和密码进行修 改，避免存在弱口令
select name from syslogins 询问每个账户的作用
select value from v$parameter where name=„
audit_trail‟
分离，仅授予管理用户所需
用户所需的最小权限
的最小权限；
访问控制
操作系统和数据库的特权用户的 应实现操作系统和数据库系 权限必须分离，避免一些特权用
统特权用户的权限分离 户拥有过大的权限，减少人为误 操作
应严格限制默认帐户的访问
权限，重命名系统默认帐 不能ห้องสมุดไป่ตู้默认的账号和密码登录数
户，修改这些帐户的默认口
_TIME'
检查情况
结果
整改建议
每个数据库用户都需要用户名 和密码登录，对默认的数据库 名不能使用默认的密码，必须
修改为新的密码
管理员账户口令最小长度为10 位，包含数字、字母、特殊字 符三种形式，口令最长生存期
为90天
最大非法登录次数为5次，账号 封锁策略为登录失败5次后封锁
5-10分钟
Show parameter REMOTE_LOGIN_PASSWORDFILE
from dba_users where ACCOUNT_STATUS='OPEN'
AND password in 根据反馈的结果对比默认口令的
值可知是否存在默认口令 常见默认口令值：
('E066D214D5421CCC', -dbsnmp
'24ABAB8B06281B4C', -ctxsys
Oracle数据库日常检查
Oracle数据库日常检查A.查看所有的实例及其后台进程是否正常确认所有的instance工作正常，登陆到所有的数据库或instance上，检测oracle后台进程$env|grep SIDORACLE_SID=UWNMS3B．检查文件系统的使用情况如果文件系统的剩余空间小于10％，则需要删除不必要的文件以释放空间。
$df-hFilesystem size used avail capacity Mounted on/dev/md/dsk/d020G17G 3.1G85%//proc0K0K0K0%/procmnttab0K0K0K0%/etc/mnttabfd0K0K0K0%/dev/fdswap85G192K85G1%/var/rundmpfs85G0K85G0%/dev/vx/dmpdmpfs85G0K85G0%/dev/vx/rdmpswap85G213M85G1%/tmp/dev/vx/dsk/data10dg/Ora_File_Vol01394G292G98G75%/data05/dev/vx/dsk/data1dg/vola0131443G156G283G36%/archivelogAIX:$df–g or df–kHP-UX$bdf or df–k or df-h注意：需要特别关注根目录，数据库软件和数据库备份所在目录的剩余空间情况！备注：数据库运行日志的及时清除1).可清除bdump,cdump,udump下的相关日志$cd$ORACLE_BASE/admin/db_name/bdump$ls-ltotal174-rwxrwxrwx1oracle dba59047Jul3022:02alert_UWNMS1.log-rwxrwxrwx1oracle dba1000Jul1422:00uwnms1_j000_18128.trc -rw-r-----1oracle dba1000Jul2222:00uwnms1_j001_5369.trc -rwxrwxrwx1oracle dba695Jul1419:12uwnms1_lgwr_18100.trc -rwxrwxrwx1oracle dba2668Jul3022:02uwnms1_lgwr_19661.trc -rwxrwxrwx1oracle dba983Jul1417:36uwnms1_lgwr_7816.trc -rwxrwxrwx1oracle dba955Jul1419:11uwnms1_lgwr_7883.trc -rwxrwxrwx1oracle dba803Jul1417:31uwnms1_p000_7714.trc -rwxrwxrwx1oracle dba801Jul1417:31uwnms1_p001_7716.trc $cd../cdump$ls-ltotal4drwxr-x---2oracle dba512Jul2514:12core_18095drwxr-x---2oracle dba512Jul2519:17core_25934$cd../udump$ls-ltotal20042-rw-r-----1oracle dba505Jul1616:33uwnms1_ora_14771.trc-rw-r-----1oracle dba4516169Jul2514:12uwnms1_ora_18095.trc -rwxrwxrwx1oracle dba644Jul1419:12uwnms1_ora_18119.trc -rw-r-----1oracle dba505Jul3015:11uwnms1_ora_18820.trc-rwxrwxrwx1oracle dba774Jul1510:23uwnms1_ora_19573.trc -rwxrwxrwx1oracle dba587Jul1510:23uwnms1_ora_19645.trc -rwxrwxrwx1oracle dba644Jul1510:23uwnms1_ora_19680.trc -rw-r-----1oracle dba720942Jul1516:28uwnms1_ora_24759.trc-rw-r-----1oracle dba4951562Jul2519:17uwnms1_ora_25934.trc -rw-r-----1oracle dba505Jul1517:21uwnms1_ora_27326.trc-rw-r-----1oracle dba503Jul3016:54uwnms1_ora_6612.trc-rwxrwxrwx1oracle dba585Jul1417:12uwnms1_ora_7523.trc-rwxrwxrwx1oracle dba767Jul1417:30uwnms1_ora_7566.trc 2).可清除oracle的监听日志$cd$ORACLE_HOME/network/log$ls-ltotal533072-rwxrwxrwx1oracle dba272507851Jul3111:28listener.log-rw-r--r--1oracle dba257876Jul3108:48sqlnet.log$cp/dev/null listener.logC．查找警告日志文件1.联接每一个操作管理系统2.使用‘TELNET’或是可比较程序3.对每一个管理实例，经常的执行$ORACLE_BASE/<SID>/bdump操作，并使其能回退到控制数据库的SID。