RMAN备份&恢复诊断脚本集

User Managed Backup & Recovery Diagnostic Collection注意事项：需要以SYSDBA权限登录SQL*PLUS执行
实例需要 MOUNT or OPEN mode.
生成结果文件：recovery_diagnostics.out （default location is /tmp）----------------- start ------------------
set echo on
set linesize 200 trimspool on
col name form a60
col status form a10
col dbname form a15
col member form a80
col inst_id form 999
col resetlogs_time form a25
col created form a25
col db_unique_name form a15
col stat form 9999999999
col thr form 99999
col "Uptime" form a80
col file# form 999999
col checkpoint_change# form 999999999999999
col first_change# form 999999999999999
col change# form 999999999999999
set pagesize 50000;
alter session set nls_date_format = "DD-MON-RRRR HH24:MI:SS";spool "/tmp/recovery_diagnostics.out";show userselect inst_id, instance_name, status, startup_time || " - " ||
trunc（SYSDATE-（STARTUP_TIME）） || " day（s）, " || trunc（24*（（SYSDATE-STARTUP_TIME） -
trunc（SYSDATE-STARTUP_TIME）））||" hour（s）, " || mod（trunc（1440*（（SYSDATE-STARTUP_TIME） - trunc（SYSDATE-STARTUP_TIME）））, 60） ||" minute（s）, " || mod（trunc（86400*（（SYSDATE-STARTUP_TIME） - trunc（SYSDATE-STARTUP_TIME）））, 60） ||" seconds" "Uptime"
from gv$instance
order by inst_id
/select dbid, name, database_role, created, resetlogs_change#, resetlogs_time, open_mode, log_mode, checkpoint_change#, controlfile_type, controlfile_change#, controlfile_time from v$database;archive log list;select * from v$controlfile;select distinct（status）, count（*） from V$BACKUP group by status;select file#, f.name, t.name, f.status, checkpoint_change#
from v$datafile f, v$tablespace t where f.ts#=t.ts#;select file#, status, checkpoint_change#, checkpoint_time, resetlogs_change#, resetlogs_time, fuzzy from v$datafile_header;select status,checkpoint_change#,checkpoint_time, resetlogs_change#,
resetlogs_time, count（*）, fuzzy from v$datafile_header
group by status,checkpoint_change#,checkpoint_time, resetlogs_change#,
resetlogs_time, fuzzy;select distinct（FHRBA_SEQ） Sequence, count（*） from X$KCVFH group by FHRBA_SEQ;
select v1.thread#, v1.group#, v1.sequence#, v1.first_change#, v1.first_time, v1.next_time,
v1.archived, v1.status,v2.member
from v$log v1, v$logfile v2 where v1.group#=v2.group#
order by v1.first_time;select * from v$recover_file order by 1;select distinct（status）from v$datafile;select round（sum（bytes）/1024/1024/1024,0） db_size_GB from v$datafile;select fhsta, count（*） from X$KCVFH group by fhsta;select min（fhrba_Seq）, max（fhrba_Seq） from X$KCVFH;

spool off
----------------- end ------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle segment_name为数字的怪象Oracle收集索引统计信息相关资讯 Rman备份脚本 RMAN脚本

Oracle 11g R2 RAC RMAN备份脚本示（12/27/2015 11:33:20）
RMAN全备份脚本（06/16/2014 21:46:52）
Oracle生产环境RMAN备份脚本（05/12/2014 20:38:00）

Oracle数据库中rman备份脚本非常实（11/17/2014 09:15:59）
RMAN备份脚本书写格式和注意事项（05/26/2014 17:09:08）
RMAN故障诊断脚本集（12/12/2013 09:24:30）

本文评论查看全部评论（0）

表情：姓名：匿名字数

</textare        </div>
                <div style="text-align: center;padding:20px;">
            <button class="layui-btn layui-bg-purple" id="dofav">收藏该网址</button>
        </div>
    </div>
</div>
<div class="copyright">
    <div id="footbar">
        版权所有©石家庄振强科技有限公司2024 <a href="https://beian.miit.gov.cn" target="_blank">冀ICP备08103738号-5</a> <a href="/storage/sitemap.xml">网站地图</a>
    </div>
</div>
<script> var _mtj = _mtj || [];
(function () {
    var mtj = document.createElement("script");
    mtj.src = "https://node12.aizhantj.com:21233/tjjs/?k=p2tceukth5c";
    var s = document.getElementsByTagName("script")[0];
    s.parentNode.insertBefore(mtj, s);
})(); </script>
<script src="/static/lib/layui/layui.js"></script>
<script src="/static/lib/jquery/jquery.js"></script>
<script src="/static/lib/ajax.js"></script>
<script>
    layui.use(function () {
        var layer = layui.layer;
        var $ = layui.jquery;
        $("#dofav").click(function () {
            var artid = $(".article").attr("artid");
            var params={
                artid:artid,
                addtype:'escdns_article',
                t:Math.random()
            };
            if(artid>0){
                ajax.request({
                    method: "/index/article/addfavorite", type: "post", callback: function (res) {
                        layer.msg(res.msg);
                    }
                },params);
            }
        })
    })
</script>
</body>
</html>

首页 / 数据库 / MySQL / RMAN备份&amp;恢复诊断脚本集

首页 / 数据库 / MySQL / RMAN备份&恢复诊断脚本集