小编做DBA的时候,经常用的一个脚本来自idevelopment这个网站,今天分享给各位朋友。网站上包含Oracle/SQL Server/MySQL 甚至操作系统管理的脚本,如果你是一个Oracle DBA,这些脚本足够你消化一段时间。
这个网站的主人是Jeffrey M. Hunter,Oracle ACE。现为The DBA Zone公司高级DBA,他的相关介绍可点此了解。
部分脚本及目录预览:
Oracle on Linux数据库安装脚本及说明
Disk Space Error While Installing RHEL5
Install Oracle Database 11g R2 on Linux – (RHEL 6)
Install Oracle Database 11g R2 on Linux using Oracle ASM – (OL5)
Install Oracle Database 11g R2 on Linux – (OL5)
Install Oracle Database 11g R1 on Linux – (RHEL 5)
Install Oracle Database 10g R2 on Linux – (RHEL 5)
Install Oracle Database 10g R1 on Linux using ASM – (RHEL 4)
Install Oracle9i R2 on Linux – (Fedora Core 2)
Install Oracle9i R2 on Linux Using RAW Devices – (Red Hat Linux 8.0)
Starting TNS Listener gives “Linux Error: 32: Broken pipe”
Install Oracle9i R2 on Red Hat Linux 7.3 – 8.0
ORA-01041 / ORA-03113 after shutdown/startup – (Oracle 9i)
Install Oracle8i on Red Hat Linux 7.1 – 7.2
Install Oracle9i on Red Hat Linux 7.1 – 7.2
Export / Import导入导出
Monitor Import Speed
Export Files Greater Than 2GB
Faster database exports/imports
RMAN – (Recovery Manager)
RMAN Recovery Catalog – (11g)
Migrating Databases from non-ASM to ASM and Vice-Versa
Duplicate a Database in Flash Recovery Area using ASM to non-ASM Host using RMAN
How to Restore the controlfile using RMAN
Drop a Target Database using RMAN
A Typical Oracle9i RMAN Setup and Configuration
Creating a Standby Database using RMAN – (UNIX / Linux)
Duplicating a Database using RMAN – (UNIX / Linux)
Duplicating a Database using RMAN – (Windows NT / 2000)
Case Study #3 – (Backup / Recovery / No-Archivelog / Exclude Tablespace)
Case Study #2 – (Backup / Recovery / No-Archivelog / Read-Only Tablespace)
Case Study #1 – (Backup / Recovery / No-Archivelog)
Using the LIST Command
Views and Synonyms
RESTORE / RECOVERY Examples
BACKUP Examples
Configuring RMAN Default Settings
The Recovery Catalog
Creating an RMAN Database User on the Target Database for Backups
Setting the CONTROL_FILE_RECORD_KEEP_TIME Parameter
Introduction to RMAN
dba_snapshot9i-10g数据库检查脚本
dba_snapshot_database_10g.sql
dba_snapshot_database_8i.sql
dba_snapshot_database_9i.sql
特别说明:没有认真看过的脚本就绝不要执行。对于 DBA 来说,如果一个脚本你从来没有认真读取了解过,就不要去执行,脚本中的一个错误就可能导致严重的数据灾难。——《DBA手记4 数据库安全警示录》