gumengkai的博客

STARTUP NOMOUNTCREATE CONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS ARCHIVELOG MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 292 LOGFILE GROUP 1 (

两种shell脚本：验证rman备份集的有效性，用rmab备份集做定期恢复实验脚本1：rman_validate_v2.sh#!/bin/bash# +-----------------------------------------------------------------------+# | Quanwen Zh

FAST_START_PARALLEL_ROLLBACK specifies the degree of parallelism used when recovering terminated transactions. Terminated transactions are transactions that are active before a system failure. If a sy

查看隐含参数SQL> show user #以sys用户创建视图USER is "SYS"SQL> create or replace view show_hidden_parameter (inst_id,NUM ,

SELECT DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(TO_NUMBER('01c0004c', 'xxxxxxxxxxxx')) FILE_ID, DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(TO_NUMBER

1. 全备(包括控制文件)[oracle@centos6 scripts]$ cat rman_backup.shsource /home/oracle/.bash_profilerman target / log=/home/oracle/backup/backupall_rman.log<<EOFrun{allocate channel ch1 device type disk;

TABLE1.user_tables(dba_tables),表实际使用的空间SQL> select table_name,tablespace_name,num_rows,blocks,empty_blocks from user_tables where table_name='T';TABLE_NAME                     TABLESPACE_NAM

[oracle@centos6 ~]$ cat ckuser.shecho show user | $ORACLE_HOME/bin/sqlplus -s $1 | grep -i 'USER ' | wc -l注：不要使用sqlplus / as sysdba的方式校验！！原理就是登陆成功后可以用show user的方式查看到user的信息，通过筛选'USER '关键字即可判断是否登陆

[oracle@centos6 scripts]$ cat showdb.shsqlplus -s $DB_CONN_STR <<EOFREM ------------------------------------------------------------------------set pagesize 20set feedback offset verify offset

[oracle@centos6 scripts]$ cat showtps.shsqlplus -s $DB_CONN_STR <<EOFset echo off heading on underline on;column inst_num heading "Inst Num" new_value inst_num format 99999;column inst_name he

1. 查看活动会话信息SELECT * FROM V$SESSION WHERE USERNAME IS NOT NULL AND STATUS = 'ACTIVE' ORDER BY LOGON_TIME, SID;注：status用来判断会话状态       Active：正执行sql语句(waiting for/using a resource)       I

1.  查看表空间的名称及大小select t.tablespace_name, round(sum(bytes / (1024 * 1024)), 0) ts_size from dba_tablespaces t, dba_data_files d where t.tablespace_name = d.tablespace_name group by t.tablespace_nam

巡检项：cpu使用率，内存使用率，文件系统使用率，日志文件大小，oracle后台日志(有无异常)，oracle连接数使用情况，oracle表空间使用率，asm存储使用率，失效索引，rman备份日志(有无异常)主巡检脚本：Oracheck.sh[oracle@orcl scripts]$ cat oracheck.sh #!/bin/sh# Get HostnameD