- INSTANCE OVERVIEW - |
-- +----------------------------------------------------------------------------+
prompt Instance Overview
COLUMN host_name format a20
set linesize 300
SELECT host_name ,
instance_name ,
instance_number ,
version ,
TO_CHAR(startup_time,'mm/dd/yyyy HH24:MI:SS') start_time,
status ,
DECODE(archiver, 'FAILED', archiver,archiver) archiver,
DATABASE_STATUS
FROM v$instance
ORDER BY instance_number;
exit
3.数据库空间大小检查tablespace_check.code
-- +----------------------------------------------------------------------------+
-- | - TABLESPACE OVERVIEW - |
-- +----------------------------------------------------------------------------+
prompt TABLESPACE OVERVIEW
COLUMN tablespace_name format a20
COLUMN autoextensible format a15
COLUMN total format a15
COLUMN used format a15
COLUMN free format a15
COLUMN used_percent format a25
set linesize 300
set pagesize 200
select a.tablespace_name, a.autoextensible,
total_m||'M' total,
(case when total_m-free_m < 1 then '0' else null end)||to_char(round(total_m-free_m,2))||'M' used ,
round(free_m,2)||'M' free,
100*round((total_m-free_m)/total_m,4)||'%' used_percent
from
(
select a.tablespace_name, a.autoextensible,sum(a.bytes)/1024/1024 total_m
from dba_data_files a
group by a.tablespace_name, a.autoextensible
)a,
(select b.tablespace_name, sum(b.bytes)/1024/1024 free_m
from dba_free_space b
group by b.tablespace_name
) b
where a.tablespace_name = b.tablespace_name
order by autoextensible asc;
exit
4. 逻辑备份exp脚本
export ORACLE_SID=devdb2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH
export NLS_LANG=american_america.ZHS16GBK
export PS1="`hostname`$"'[$PWD] '
umask 022
#######################exp devdb data#######################################################
backdate=`date +%Y%m%d%H%M`
begintime=`date +%Y-%m-%d:%H-%M`
cd /u02/expdata/backup
expleiz/leiz@devdb2file=/u02/expdata/backup/leiz_$backdate.dmp log=/u02/expdata/backup/leiz_$backdate.log wner=leiz
5. tsm磁带库备份
cd /usr/tivoli/tsm/client/ba/bin/
dsmc incremental -subdir=yes "/u02/expdata/backup/*" >> /u02/expdata/dsmc.log
echo "######################`date`##############################################" >> /u02/expdata/dsmc.log
dsmc q backup -inactive -subdir=yes "/u02/expdata/backup/*" >> /u02/expdata/dsmc.log
6.发送邮件
VA_HOME=/usr/java14/bin
MAILTO_HOME=/usr/local/mailto
MAILFROM_USER=leiz@163.com.cn
MAILFROM_PASS=12345
MAILSERVERIP=172.22.3.113
MAILTO_USER=
--查询rollback 段详细信息(收缩次数,扩展次数,平均活动事务等) --COL RBS ... oracle自动化巡检脚本 14页 7下载券 oracle、filesystem、ba... 暂无评价 3...
可用于oracle数据库日常巡检/* Script Version2011....BACKUP MODE: select set_stamp, backup_type, to... oracle、filesystem、ba... 暂无评价 3页 免费...
Oracle 数据库日常检查 数据库日常 日常检查 A. ...$df -h Filesystem size used avail capacity ...–showbackup cd 到上面的目录,检查文件应列出下面...
oracle日常巡检 - 副本_IT/计算机_专业资料。... show parameter dump_dest 注:background_dump_...v$logfile; select * from v$log; 三、查看数据...
oracle巡检脚本 2页 8财富值 HP巡检脚本 5页 1财富值 Linux日常巡检脚本 6页 8财富值 路由器批量巡检脚本 3页 5财富值 oracle巡检命令脚本 1页 2财富值...
oracle日常巡检_计算机软件及应用_IT/计算机_专业...='background_dump_dest'; 4 剩余表空间 没有... oracle、filesystem、ba... 暂无评价 3页 免费 ...
无标题 Linux/hp unix/AIX日常巡检脚本 以下为Linux...FILESYSTEM_CHECK() { FS=`df -k
在项目工作上,关于oracle日常巡检是比较麻烦的工作,... alter database backup controlfile to trace; set...system cd $ORACLE_HOME/network/admin/ echo '3-...
oracle巡检脚本-申迪_计算机硬件及网络_IT/计算机_...v$Datafile where file_id=file#; 2)信息2 ...average_wait from v$system_event where event ...
CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE ...system archive log current'; backup archivelog ...oracle/product/8.1.7:Y 以下的脚本检查 oratab ...
热门文档