![](https://csdnimg.cn/release/download_crawler_static/9820448/bg10.jpg)
xvi
Part VIII Performing User-Managed Backup and Recovery
28 Making User-Managed Database Backups
Querying V$ Views to Obtain Backup Information ...................................................................... 28-1
Listing Database Files Before a Backup ....................................................................................... 28-1
Determining Data File Status for Online Tablespace Backups................................................. 28-2
Making User-Managed Backups of the Whole Database.............................................................. 28-3
Making User-Managed Backups of Tablespaces and Data Files................................................. 28-4
Making User-Managed Backups of Offline Tablespaces and Data Files ................................ 28-4
Making User-Managed Backups of Online Tablespaces and Data Files................................. 28-5
Making User-Managed Backups of the Control File.................................................................... 28-10
Backing Up the Control File to a Binary File............................................................................. 28-10
Backing Up the Control File to a Trace File............................................................................... 28-11
Making User-Managed Backups of Archived Redo Logs ........................................................... 28-11
Making User-Managed Backups in SUSPEND Mode ................................................................. 28-11
About the Suspend/Resume Feature......................................................................................... 28-12
Making Backups in a Suspended Database............................................................................... 28-12
Making User-Managed Backups to Raw Devices......................................................................... 28-14
Backing Up to Raw Devices on Linux and UNIX..................................................................... 28-14
Backing Up to Raw Devices on Windows................................................................................. 28-16
Making Backups with the Volume Shadow Copy Service (VSS) ............................................. 28-17
Verifying User-Managed Data File Backups ................................................................................. 28-17
Testing the Restoration of Data File Backups ........................................................................... 28-17
Running the DBVERIFY Utility .................................................................................................. 28-17
29 Performing User-Managed Database Flashback and Recovery
Performing Flashback Database with SQL*Plus ............................................................................ 29-1
Overview of User-Managed Media Recovery.................................................................................. 29-2
About User-Managed Restore and Recovery.............................................................................. 29-2
Automatic Recovery with the RECOVER Command................................................................ 29-4
Recovery When Archived Logs Are in the Default Location ................................................... 29-5
Recovery When Archived Logs Are in a Nondefault Location................................................ 29-5
Recovery Cancellation.................................................................................................................... 29-6
Parallel Media Recovery ................................................................................................................ 29-7
Performing Complete Database Recovery ....................................................................................... 29-7
Performing Closed Database Recovery ....................................................................................... 29-8
Performing Open Database Recovery........................................................................................ 29-11
Performing Incomplete Database Recovery................................................................................... 29-13
Performing Cancel-Based Incomplete Recovery...................................................................... 29-14
Performing Time-Based or Change-Based Incomplete Recovery.......................................... 29-16
Recovering a Database in NOARCHIVELOG Mode................................................................... 29-16
Troubleshooting Media Recovery.................................................................................................... 29-18
About User-Managed Media Recovery Problems.................................................................... 29-18
Investigating the Media Recovery Problem: Phase 1............................................................... 29-20
Trying to Fix the Recovery Problem Without Corrupting Blocks: Phase 2.......................... 29-20
Deciding Whether to Allow Recovery to Mark as Corrupt Blocks: Phase 3 ........................ 29-22