Andreas' Adventures

Ok, I promise I will take more time to read things like manuals and other documents when it comes to new features in the database. Take the Flashback Recovery Area (FRA). Oracle does store archive logs in there, which is cool as it speeds up the recovery. The bad thing is that the Oracle Database behaves like a small child. When you do not look it will do strange things. So I was busy setting up the online backup of an infrastructure database. This one is still in 10.1.x while all the others in this environment are on 10.2.x . For the RMAN I have a catalog (also 10.2.x) so I had some problems with the versions as the 10.1.x database refused to get into the 10.2.x RMAN catalog. I thought that I have plenty of space for the archivelogs in the ASM (everything was RAC of course). I turned my attention to some other issues (aka not watching your kid for a moment). Then during an important demo for the client a developer told me that he cannot use the OID. Of course I checked, but the OID wa...

Almost everbody knows how to create backups of the controlfile. Usually a alter database backup controlfile to trace; is used . And now for the 64000$ question: Which information is not backed up by this command? The answer is: THE BACKUP RECORDS! In order to prevent the loss of this information you can better use the following command: alter database backup controlfile to '/a_real/location/inyour/system';

Just want to store them here for myself, but if others use them - well feel free (and drop me a note). The script for the Cluster Registry #!/bin/ksh # Author: Andreas Chatziantoniou, Accenture Technology Solutions # Date : 25-JUN-2007 # # Purpose: # Create a backup of the Oracle Cluster Registry regularly # # Usage: # ./backup_oracle_crs.sh # # This script should be used from the cron in regular intervals # # Results: # The backupfile of the Oracle Cluster Registry will be created in the /tmp # directory. The filename will contain the hostname and the time that # the backup was created. OCRBCK=/tmp/ocrbackup.`hostname`.`date +"%Y%m%d%H%M"` /opt/oracle/crs/bin/ocrconfig -export $OCRBCK And here is the script for the Voting Disk #!/bin/ksh # Author: Andreas Chatziantoniou, Accenture Technology Solutions # Date : 25-JUN-2007 # # Purpose: # Create a backup of the Oracle Voting Disk regularly # # Usage: # ./backup_oracle_voting_disk.sh # # This script should be used from the cr...