Harry Dragstra

Harry Dragstra is Senior Oracle DBA. He is specialized in Oracle RAC, Oracle Virtualization, and has a a strong interest in APEX development and PL/SQL.

Homepage: http://www.amis.nl


Posts by Harry Dragstra

Rman 11gR2 changes tag labeling of the inc backup in incrementally updated backups

14/10/2011 - 5:51 pm

Posted in AMIS, DBA, Database, IT Architecture, Oracle, Tools | No comments

In (rman) incrementally updated backups, only incremental backups are done after the first full backup to the Fast Recovery Area.
From 11gR2 on the incremental backup pieces will get the same tag as the datafile copies, and that’s actually different behaviour from pre- 11gR2 versions of the database.
I stumbled on this different behaviour when a backup [...]

How to switch datafiles to FRA and back again

14/10/2011 - 3:30 pm

Posted in AMIS, DBA, Database, Oracle, Technical Architecture, Tools | 2 comments

If you, like me, like to use (rman) incrementally updated backups, a copy of all datafiles will be present in the Fast Recovery Area. That becomes quite handy if you are in sudden need of extra disk space for your database, and the FRA still has ample space left. By switching one or more datafiles [...]

DBPITR with a rman archival backup

20/3/2011 - 4:37 pm

Posted in DBA, Database, Devel. + PL/SQL tools, General | No comments

One of our customers had this request:
Can you make a backup of my development database that I can use to restore ( the same database ) to a couple of months back in time?
This customer uses Standard Edition [ SE ] 11gR1 database on Windows, and has a backup regime where tape backups [...]

I don’t like a reclaimable database disk copy

1/6/2010 - 1:22 pm

Posted in DBA, IT Architecture | No comments

As of Oracle 10g it’s possible to recover (or wind forward) a RMAN disk copy of the database to a specific time in the past. This type of backup is quite suitable for big databases (> 100GB), because you have to perform a time consuming full backup only once. All other backups to disk will [...]

Oracle database directory listing with ls function

14/5/2009 - 9:02 pm

Posted in Database, Databases, Devel. + PL/SQL tools, General | 5 comments

Say, you are in need of a directory listing from within the Oracle database similar to the one generated with Unix command ls. Your database doesn’t contain a JVM, so the use of some simple JAVA is out of the question. Well, starting from DB Release 10g there is the possibility of using the searchfiles [...]