-
Archives
- January 2026
- April 2019
- March 2019
- September 2018
- August 2016
- July 2016
- May 2015
- April 2015
- December 2014
- November 2014
- August 2014
- February 2014
- January 2014
- November 2013
- July 2013
- June 2013
- March 2013
- December 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- October 2011
- August 2011
- June 2011
- May 2011
- April 2011
- March 2011
- December 2010
- November 2010
- October 2010
- August 2010
- July 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
-
Meta
Category Archives: Oracle in general
RMAN in Data Guard configurations – Problems of restoring rman disk backups and standby site and vice versa
… or: the problem of backup association From time to time i come across the same problems in data guard configurations using rman-to-disk: Backups taken on the standby database are not taken into account when trying to perform an rman … Continue reading
Posted in Oracle in general
3 Comments
Managing the AWR (automatic workload repository)
Overview on the AWR The automatic workload repository “AWR” was introduced with Oracle 10g. It collects performance data in intervals (default: 60 minutes) and keeps them by default for one week. The data is stored in the SYSAUX tablespace. The … Continue reading
Posted in Oracle in general
1 Comment
Oracle Dataguard – automatic archive log file management on primary site
System Environment Suppose you have an oracle data guard environment with one primary database and one physical standby database running. You perform online backups with RMAN from the PRIMARY database. Your users complain about slowness during the night. You notice … Continue reading
Posted in Oracle in general
Leave a comment
Changing ADR Destination for 11g Listener
With 11g Release 1 Oracle introduced the Automatic Diagnostic Repository – “ADR”. The ADR is designed as central repository for storing all oracle-related log files such as alert.log, listener.log and so on. The log files are stored in XML format … Continue reading
Posted in Oracle in general
Leave a comment
Building and using the kfed utility
When using ASM sometimes it it extremely helpful to get more information on the asm disk header. The “kfed” utility from oracle enables to dump the asm disk header and many more. With this tool corruptions to the asm can … Continue reading
Posted in Oracle ASM, Oracle in general
Leave a comment
Using ASM with files (either locally or via NFS)
From time to time i need to configure additional and temporary storage for data migration or just testing purposes. Raw Devices are not recommended to use from 11g onwards. So why not use the loopback device for that? With this scenario … Continue reading
Posted in Oracle ASM, Oracle in general
3 Comments