Oracle if updating column
Using a script in Oracle 12c (clonedb.pl, which can also be found in a Metalink note that can be used with Oracle 11g R2), a second set of mapped datafiles can be created to hold just the changes (DDL, DML) to that base copy.So, using this process, you can create numerous clones occupying a very small space apiece (relative to current cloning techniques) in a very short "cloning" time (around 2 minutes apiece).
Some of this is Banner specific, but even those can give you ideas for similar scripts to be used with other third-party Oracle applications.Using their NFS OFM (Oracle File Manager) library in place of their current OFM, NAS (Network Attached Servers) drives can be attached to your database servers through NFS servers to provide near unlimited disk space to y our database servers.Oracle's DNFS implementation also provides an interesting side effect, in that you can have it loop back to itself, resulting in just having to have one server instead of three or more servers.How about creating a Data Guard standby database for your primary database on another server?How about restoring your database quickly if it becomes corrupted or if data is accidentally deleted? if you don't want to bother with the intricacies of RMAN, I even have scripts to back up one or all of your databases on a server, either fully or incrementally, and to clone your database from an RMAN backup.This page shows you step-by-step how to bulletproof your database as much as possible against data loss, gives you the what's and how's of database backups and restores, and takes you through disaster recovery scenarios if you encounter those heart-stopping Oracle errors on database startup, such as datafile corruption or loss, disk drive loss, and other nasties.
You can also download the slides for the presentation in Microsoft Power Point format, including the viewer (totalling around 3,483 K in size).
And, it also provides a way to service multiple clones derived from a base image database created through RMAN.
The base image database contains all of the database data up to the time that the RMAN image backup was created.
And, with the time pressure we are under from Ellucian and Oracle to get this done, this is being posted in the nick of time. As a companion to the Web Logic and Fusion Middleware Installation above, I'm also including my instructions with the steps to stop and restart the PROD database, Web Logic, Node Manager, and opmn on a Linux server.
It's basically just a step-by-step copy-and-paste operation, which helps me to not forget any of the steps.
My Powerpoint presentation from the Co HEsion (SETA) Nashville 2013 conference shows how to do this. There has been a lot of nervousness about upgrading to Web Logic and Fusion Middleware. It took me about a month and a half to pour through all of those documents and to install Web Logic and Fusion Middleware on a clean Linux server.