VirtualObjectives

Oracle

Script Description
Using Archive Logs to Make a Copy of a Production Database How to use archive logs from a Standby environment and apply them to a new server which can be split off and used as a copy of the Production database.
Oracle RMAN Backup Scripting Describes how to configure your RMAN backup script for an Oracle RAC running on Windows servers.
Restoring a Physical Standby Database Procedure covers the complete restore of a Physical Standby database.
Restore to a Oracle Test RAC Environment How to restore a Production database into a two node Test RAC environment.
Oracle Rolling Patch Procedure - Single Instance How to perform a rolling point release upgrade of Oracle on a single instance environment running 10g on a Windows server.
Oracle Rolling Patch Procedure - RAC How to perform a rolling point release upgrade of Oracle on an Oracle RAC environment running 10g on a Windows server while keeping at least one node active.
Reinitialise Oracle Enterprise Manager (OEM) Learn how to reinitialise Oracle Enterprise Manager (OEM) for Database Control.
AWR and ASH Reports Learn how to generate Automatic Workload Repository (AWR) performance statistics and Active Session History (ASH) statistics.
Changing SYS and SYSMAN Passwords in an Oracle RAC Environment How to change the SYS and SYSMAN passwords in an Oracle RAC Environment including the Data Guard Standby server, ASM, and Oracle Enterprise Manager (OEM)
Search User Activity and SQL Scripts for searching user activity by machine or username and search for SQL activity by date, session ID, etc.
Data Guard Standby Queries Various queries to determine if Data Guard is working and help diagnose and fix gaps in archive logs.
SQL Performance Display the top 50 SQL statements by: Elapsed Time, CPU Time, Disk Reads per Execution, Buffer Gets Execution and Number of Executions.
ORAENV for Windows ORAENV for Windows Oracle environments providing the ability to change environment variables like ORACLE_HOME
ORAENV for Windows RAC Environments ORAENV for Windows Oracle RAC environments providing the ability to change environment variables like ORACLE_HOME