- 博客(24)
- 收藏
- 关注
转载 Check FRA usage
SQL> set linesize 150 column name format a35 SELECT NAME, SPACE_LIMIT/1024/1024/1024 AS SPACE_...
2018-08-23 09:35:28
100
转载 CHG: Restart Dataguard Standby databases
CHG: Restart Dataguard Standby databases Stop Dataguard Standby Database: PreStep: Ba...
2018-08-21 11:06:46
137
转载 check memory_target and memory_max_target
SQL> set linesize 130 set pagesize 1000 column name format a30 column value format a30 select n...
2018-08-21 08:54:02
117
转载 Generate Script to kill multiple Oracle sessions
$ cd /data/oracle/SHRARS/backup/export/ITSK0004746383 $ sqlplus -s / as sysdba < killsession.sql set ...
2018-06-23 23:01:20
93
转载 Kill Multiple Seesions in Oracle
SQL> set pagesize 1000 select 'ALTER SYSTEM KILL SESSION '''|| sid ||','|| SERIAL# ||''' immediate;' from ...
2018-06-21 14:41:49
93
转载 Generate Script to Rebuild all SYS non-partitioned Indexes
SQL> set linesize 150 set pagesize 10000 select 'alter index '||owner||'.'||index_name||' rebuild online;'...
2018-06-18 15:38:29
462
转载 Generate Script to Analyze on all SYS non-partitioned tables
SQL> set linesize 150 set pagesize 10000 select 'analyze table '||owner||'.'||table_name||' validate struc...
2018-06-18 15:36:50
267
转载 Analyze on all SYS tables (Except AWR Tables)
**************************************************************************************** Generate Script to ...
2018-06-13 16:36:39
246
转载 opatch lsinventory -detail -oh $ORACLE_HOME
cd $ORACLE_HOME/OPatch ./opatch lsinventory -detail -oh $ORACLE_HOME > /tmp/hostname_${ORACLE_SID}_lsinve...
2018-06-12 14:41:55
203
转载 Rebuild all non-partioned Indexes
Check all partioned and non-partioned tables & Indexes SQL> set linesize 180 set pagesize ...
2018-06-12 13:09:00
117
转载 Check all partioned tables & Indexes
SQL> set linesize 150 set pagesize 10000 column table_name format a30 column tablespace_name forma...
2018-06-12 13:07:59
129
转载 Rebuild the Partitioned index to fix corrupted indexes
SQL> set linesize 150 column OWNER format a20 column SEGMENT_NAME format a20 column PARTITION_NAME format...
2018-05-29 16:10:50
115
转载 ORA-24247:网络访问被访问控制列表 (ACL) 拒绝
ORA-24247:网络访问被访问控制列表 (ACL) 拒绝 开发编写了一个oracle 发送邮件的存储过程,之前是在10G 的版本运行使用,现在11.2.0.4 的版本使用,调试无法使用 发现报错...
2018-05-16 14:29:19
581
转载 check RMAN BACKUP status
SQL> select name, db_unique_name, open_mode from v$database; NAME DB_UNIQUE_NAME...
2018-04-27 14:56:46
135
转载 V$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_JOB_DETAILS展示了rman备份的相关细节。 比如,rman备份持续时间、rman备份的执行次数、每一次rman备份工作的状态(failed or completed and so on),...
2018-04-27 14:55:11
1637
转载 opatch命令报错Inventory is corrupted
测试环境中执行opatch报错,简单描述一下解决过程。 错误信息如下: [orat3@hpserver2 OPatch]$ ./opatch lsin...
2018-04-23 15:42:40
426
转载 check parameters
SQL> set linesize 200 set pagesize 1000 column name format a40 column value format a60 select inst_id, n...
2018-04-23 14:38:37
537
转载 Restore archivelogs to a different location
RMAN>run >{ >set archivelog destination to '/stage'; >restore archivelog from logseq 100278 until l...
2018-01-07 16:12:19
117
转载 check undo info
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS'; col status format a15 col description format a40 ...
2018-01-01 19:46:32
106
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 11gR1 RAC
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,Goldengate,Streams部分实战文...
2012-02-14 17:28:01
108
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 11gR1 RAC DataGuard
Oracle10g/11gRAC,DataGuard实战环境 请加入QQ群参加Oracle10...
2012-02-14 15:33:49
142
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 10gR2 RAC
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,Goldengate,Streams...
2012-02-14 10:04:14
86
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 10gR2 DataGuard
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,Goldengat...
2012-02-13 17:24:39
74
转载 Oracle 10g/11g RAC, DataGuard实战之Oracle 10gR2 RAC DataGuard
请加入QQ群参加Oracle10g/11gRACDataGuard,Goldengate交流和免费提供99%正确率的OracleRAC,DataGuard,...
2012-02-13 17:03:11
89
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人