Maintenance

of the ArsDigita Community System by Philip Greenspun
The most important thing to ensure in an ACS installation is that Oracle exports are being made. In general, it is unwise to rely on full recovery of a damaged Oracle installation. In theory, it is possible to recover Oracle if (1) the thing was set up correctly to begin with, and (2) you have an Oracle dba wizard around to bring the system back to life. In practice, I don't feel comfortable unless I have a full export of my Oracle database made nightly (using the Oracle exp utility, as outlined in my book).

So check on this!

Disaster recovery or just rebuilding your Oracle installation for any other reason (change of block size, moving everything to new disks) would then consist of the following steps:


philg@mit.edu