Oracle 10g backup and recovery techniques

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Oracle 10g backup and recovery techniques can be divided into 5 major categories: User Managed, RMAN based, Enterprise Manager Database Control based, Logical and Flashback Technology based."

User-Managed Online/Offline Backup

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "We are starting the discussion with User Managed path. Using the User-Managed path we can do both Oracle database backup as well as recovery. Let's first start with learning User-Managed Backups. User-Managed Backups can be taken either by first making the database "offline" or even when the database is upand running. The steps of implementation are different in both the cases."

User-Managed Complete Recovery in NOARCHIVELOG Mode

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "In NOARCHIVELOG mode the recovery is very simple. All you have to do is to restore the database files from your backup to the original location and start the database. Let's suppose one of your data file got corrupted. The time you try to start the Oracle Instance, it will give you an error. In this case shut down the database. Restore all the data files, redo log files and control file back to their original location from your last whole/complete cold backup."

RECOVER DATABASE UNTIL TIME

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "If you use just RECOVER DATABASE, then this is consideredas complete recovery where as if we use the clause UNTIL TIME/UNTIL CANCEL/UNTIL CHANGE with the RECOVERDATABASE statement then we can stop the process of recovery in the middle. This concept applies to both User-Managed and RMAN based."

What is the purpose of RESETLOGS? - Oracle

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Figure 10-8: Zoomed area of Figure 10-1 with focus on RMAN based incomplete recovery. There are two different ways to do such type of recovery. After any type of incomplete recovery, open the database using the RESETLOGS clause. After any type of incomplete recovery, complete database backup is required."

User-Managed Online Backup - Oracle

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "The other names given to this kind of backup are viz., Open/Hot/Inconsistent database backup. The SCN will be different in all the backed up data files that's why once you restore all the data files, recovery of database is required before making it available to users."

Creating Image Copies Using RMAN - Oracle

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Image copies generated using RMAN COPY command are similar to images copies generated using operating system commands like copy in Windows Server2004/XP/NT and no recovery is needed after restoring the files back from the backed up location."

Data Pump Export/Import - Logical Backup and Recovery

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "As shown in Figure 10-9 under logical backup and recovery we have two techniques available. One, we inherited from Oracle 9i i.e. Export/Import or Simple Export/Import (exp & imp) and second one is new to Oracle 10g version i.e. Data Pump Export/Import (expdp & impdp)."

Oracle Enterprise Manager Database Control Based Backup Techniques

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Oracle Enterprise Manager Database Control Based Backup Techniques: EM Database Control provides common backup features but more comprehensive ones are still available via RMAN. In case the database is running under NOARCHIVELOG mode then there will be two options available under customized backup category as shown in Figure 10-10."

expdp, impdp, Simple Export/Import - Oracle

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "There are two ways to do export of data from Oracle database using Export utility. One is called the "Conventional Path Export" and other is called the "Direct Path Export". Conventional path export is the default mode of the Export utility where as Direct path export can be achieved by setting DIRECT equal to Y."

EM Database Control based Whole Database Backup

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Oracle Enterprise Manager (EM) Database Control based Whole Database Backup: In case you are running the database in ARCHIVELOG mode then these options are available under Customized Backup category. In case the database is running in the NOARCHIVELOG mode, see Figure 10-10."

Oracle Enterprise Manager (EM) Database Control based Tablespaces Backup

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "In case you are running the database in ARCHIVELOGmode then these options are available under Customized Backup category. In case the database is running in the NOARCHIVELOG mode, see Figure 10-10."

Oracle Flash Recovery Area

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Flash Recovery Area is a single place (folder) for all the recovery-related files. One single location approach provides easy manageability. In this location we can have all the following files required in the recovery operation."

Oracle Flashback Version Query

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Flashback Version Query is an enhancement to Flashback Query technology. It provides the all the versions of a specific row existed between one time to another time or between one SCN to another SCN. We use the VERSIONS BETWEEN clause of SELECT statement to make this happen."

FLASHBACK TABLE emp TO BEFORE DROP -Oracle Flashback Drop

The is an excerpt from Oracle 10g Administration book, available for free download in PDF format. "Flash back drop helps you to restore the dropped table without using tablespace point in time recovery as it was in the case of Oracle 9i. In Oracle 10g, each tablespace has its own recycle bin which holds the dropped tables."