Database Reference
In-Depth Information
■
Flashback Transaction
■
Flashback table
■
Flashback table drop
As you can see there are a number of different variations on the Flashback features, specific
to different kinds of needs.
Manual backups - You can write scripts that perform manual backups of your database.
You can then take those manual backups and manually restore them.
Oracle MAA Recommendations
The Oracle database provides a number of ways to protect the enterprise from data loss.
The different kinds of protection range from basic offline backup and recovery procedures
to more complex functionality to provide disaster recovery and multisite solutions.
Oracle provides guidance with respect to data protection in a series of recommended best
practices collectively called the Maximum Availability Architecture (MAA) best practices.
These best practices describe the architectures, processes, standards, and procedures that
should be followed to ensure that your database is protected to the maximum extent possible.
The MAA practices actually extend to the various layers in the Enterprise computing land-
scape, including application and infrastructure.
Various Oracle database features and products are part of the MAA best practices
including the following and many other topics:
■
Backup and recovery
■
High availability
■
Disaster recovery
■
Data replication and distribution
■
Database rolling upgrades
As you will see in the next several chapters, the Oracle Database has a rich set of features to
protect your database from data loss. This topic concentrates a great deal on Oracle Database
backup and recovery. Likewise, the OCP exam contains a large number of questions related to
database backup and recovery, specifically those associated with RMAN. Backup and recov-
ery is one of the most fundamental architectural features of the Oracle Database with respect
to data protection.
However, there are other things that need to be considered when planning your enterprise
data-protection strategy. These include topics such as high availability, disaster recovery, how
to correct user or application data corruptions, and data replication. Solutions to these prob-
lems involve the following Oracle Database features and products:
Oracle Real-Application Clusters
High availability is provided through the use of Oracle
Real-Application Clusters (RAC). With RAC you can have more than one computer con-
nected to your database. Thus, if one of the computers fails, the remaining computers can
continue to run.
Search WWH ::
Custom Search