New Oracle 12c IO Outlier Views
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is […]
12c, Oracle, Oracle Database, Tuning
Oracle Database
Oracle, Oracle Database
Show Oracle FRA Fast Recovery Area Usage and other things
Show Oracle FRA Fast Recovery Area Usage fraUsage.sql –Show Oracle FRA Fast Recovery Area Usage set wrap on column name
Oracle Database
Automated purge of Oracle Data Guard Standby and Snapshot Archivelogs from a DB standby
See my previous post on how to toggle a Data Guard snapshot standby between snapshot and physical recovery here. It
Oracle Data Guard, Oracle Database
Unix Oracle Create a Data Guard Standby with nohup and a here document
Unix Oracle Create a Data Guard Standby with nohup and a here document. So why do a nohup and here
Oracle Data Guard, Oracle Database
Configure my Oracle sqlnet listener to listen for multiple ports on multiple virtual host names – same physical host
Ok, so why do all that? It’s a primary on a Data Guard pair – the DG replication is played
Oracle, Oracle Database
Oracle – Switch from a NON-FRA ( fast recovery area ) db to a db using an FRA
sqlplus / as sysdba … alter system set db_recovery_file_dest_size=25G scope=both; alter system set db_recovery_file_dest=’/oracle/fra’ scope=both; # yes this path better
Oracle Database, RMAN
Tell Oracle RMAN where my backups are – backup location – where to write them and where to read them from
Assuming you are just connected to RMAN via the control file as follows: rman target / Recovery Manager: Release 12.1.0.2.0
Oracle Database
Basic RMAN configurations for backup, restore, to and from disk
Here’s what I do especially in sandboxes for rman configurations – backups to disk. First line – defaults all backups
12c, Oracle, Oracle Database
DBMS_SYSTEM reference
DBMS_SYSTEM pl/sql package does not seem to be documented and may not be supported by Oracle. Here’s where you can