oraclesean/scripts

Various scripts for Oracle database environments

Scripts

Various scripts for managing Oracle database environments.

General Diagnostics and Reporting

• get_host_env.sh: Collect host metadata into a directory for troubleshooting.
• get_db_env.sh: Collect database metadata into a directory for troubleshooting.
• Show Hidden Parameters: Show hidden (underscore) parameters.
• Database Commit Rate: Database commit rate.
• Log Switches: Find log switches in the alert log.
• Search alert log: Find messages in the alert log.
• srvctl reports and metadata: Some useful srvctl commands for database environments.

Automatic Diagnostic Repository (ADR)

• ADR-report-errors.sh: Report, repair, and clean up ADR directories.

Autonomous Health Framework (AHF)

Data Guard

• Helpful commands: Helpful commands for reporting and validating components of Data Guard Broker configurations.
• Find Data Guard logs: Retrieve locations for database alert and Data Guard Broker logs.
• Get connection strings: Retrieve the Data GUard connection strings for a database.

Real Application Clusters (RAC)

• pretty_crs_stat: Pretty-print output from crs_stat.
• ASM disk devices: Associate ASM disks to their major/minor devices.

Recovery Manager (RMAN)

• RMAN alias: An alias for calling RMAN that sets NLS_DATE_FORMAT and enables detailed date/time output from RMAN commands.
• Helpful commands: Helpful commands for reporting RMAN metadata.

Zero Data Loss Recovery Appliance (ZDLRA)