Surviving a Database Disaster with RMAN Backups :
Follow along with this real-world disaster scenario and learn how one company
recovered their databases using RMAN backups. Oracle Background Processes : With every
release of Oracle, background processes have been added or modified. Amar Kumar
Padhi takes an in-depth look at these processes that are key to the proper
working of the database. Manipulating Oracle Files with UTL_FILE :
Take hold of your alert log with the use of a few new subprograms in the
UTL_FILE package. CONFIGURE This! Taking Advantage of Oracle 9i Recovery
Manager (RMAN) Features During Backups : Oracle Recovery Manager
(RMAN) features have been expanded significantly in Oracle 9i. This article
discusses several of these new features and includes examples on how to
implement them to make any Oracle DBA's backup, restoration, and disaster recovery
plans more effective. DBA Call to Action: Oracle Database Integrity :
James Koopmann offers a refresher on database integrity, and why it's
important. Deleting Historical Data on Oracle Databases :
Archiving historical database data is an important, complex and in most cases
forgotten task of database projects. Marin Komadina examines the problem of
deleting historical data and presents some practical tips on how to execute and
check the deleting performance. Reporting Database Object Increase On Oracle :
On the production Oracle system, a DBA is responsible for collecting database
increase statistics. Learn how to do so easily and economincally, without
changing the existing database. Recovering Accidentally Lost Data Using Oracle's
Flashback Query : Recent studies show that nearly 50% of system
outages are due to human errors. Oracle 9i's new feature, Flashback Query
allows the user to view an old image of data that has been modified and
committed by the DML statement, without requiring any structural changes to the
database. Becoming the Master of Disaster : If a
disaster happened to your database server, could you recover from it? This
article discusses the questions a DBA can ask to probe the realm of what we all
hate to think about - the possibility of the untimely demise of a production
database server. Learn how to become a fearless 'master of disaster'. Hold On There SYSter : Probably the most
sacred user in all of Oracledom is the SYS user. Koopmann takes a quick look at
how DBAs can take hold of this often misused account. Activating, Monitoring, and Tuning Automatic PGA Memory
Management via PGA_AGGREGATE_TARGET Under Oracle 9i : Sizing the
Program Global Area (PGA) is now one of many tasks made simpler under Oracle
9i. Learn how a database server utilizes the PGA, how the PGA can be
automatically sized using PGA_AGGREGATE_TARGET initialization parameter, and how
the PGA's size can be monitored and tuned using some new dynamic database
views, now part of 9i. Concerned About The (Oracle) Environment?
: Jim Czuprynski offers suggestions on the perfect environment for evaluating
software changes before they are run against the production Oracle database. Killing the Oracle DBMS_JOB : If you've
ever had a problem with a run-away job that didn't want to end, or found that
you needed to shut down the database only to find it was waiting for a job to
complete, Koopmann can help. Learn how to manage those jobs that don't want to
end. Using Flashback in Oracle 9i : Lost data? No
problem. View or recover data with Oracle 9i's Flashback feature,
DBMS_FLASHBACK! Updatable Snapshots : In his latest article, Prakash
continues his exploration of Oracle replication solutions by taking a closer
look at Updatable Snapshots. Updatable Snapshots, a feature of Oracle
Enterprise Edition only, is the snapshot, or copy, of a table, whose changes
can also be propagated back to the parent table.Oracle Replication Solutions : The management of copies of
tables across a distributed database environment is replication. The latest
article from Prakash addresses the different forms of replication available in
Oracle, including potential conflicts and the inherent advantages and
disadvantages of each type of replication.
