The Oracle 10g Scheduler
Oracle 10g’s DBMS_SCHEDULER provides significant improvements over DBMS_JOB for scheduling jobs and tasks. Let’s take an overview of new functionalities that the Oracle Scheduler provides for DBAs.
How to Convert Physical Machines to Virtual Machines with VMware Converter
The VMware Converter is amazing piece of software which will:
1) Import a Virtual Machine from a physical machine
2) Configure newly created Virtual Machine to make an existing image bootable
Maintain RMAN Catalog
Below is a windows BATCH script used to Maintain RMAN catalogue. The script accepts 3 parameters Target SID, Target password and catalogue password.
Rman Script to Create Standby/Duplicate database using RMAN
Duplicate Database using rman
connect target rman/%password%@primary_server
connect auxiliary sys/%password%@standby_server
connect rcvcat rman/%password%@recovery_catalog
run {
set until time ’27-JUL-2009 10:59:00′;
allocate auxiliary channel tp1 type “sbt_tape”;
allocate auxiliary channel tp2 type “sbt_tape”;
Remove Failed Clusterware
If you have already uninstalled Oracle Clusterware using the Oracle Universal Installer - Please download attached file cleanup.zip that contains a copy of the logpartformat.exe and the guioracleobjmanage.exe (plus necessary dll).
Tweet