ORACLE 11gR2 数据库备份与恢复全攻略：RMAN与用户管理详解

BACKUP

RECOVER

5星 · 超过95%的资源需积分: 9 36 浏览量更新于2023-07-05 收藏 8.48MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源推荐

xvi

28 Making User-Managed Database Backups

Querying V$ Views to Obtain Backup Information ...................................................................... 28-1

Listing Database Files Before a Backup ....................................................................................... 28-1

Determining Datafile Status for Online Tablespace Backups................................................... 28-2

Making User-Managed Backups of the Whole Database.............................................................. 28-3

Making User-Managed Backups of Tablespaces and Datafiles ................................................... 28-4

Making User-Managed Backups of Offline Tablespaces and Datafiles .................................. 28-4

Making User-Managed Backups of Online Tablespaces and Datafiles .................................. 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 Datafile Backups ................................................................................... 28-17

Testing the Restore of Datafile 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-3

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-17

About User-Managed Media Recovery Problems.................................................................... 29-18

Investigating the Media Recovery Problem: Phase 1............................................................... 29-19

Trying to Fix the Recovery Problem Without Corrupting Blocks: Phase 2 .......................... 29-20

Deciding Whether to Allow Recovery to Corrupt Blocks: Phase 3........................................ 29-21

Allowing Recovery to Corrupt Blocks: Phase 4........................................................................ 29-23

Performing Trial Recovery........................................................................................................... 29-23

xvii

30 Performing User-Managed Recovery: Advanced Scenarios

Responding to the Loss of a Subset of the Current Control Files ............................................... 30-1

Copying a Multiplexed Control File to a Default Location ...................................................... 30-1

Copying a Multiplexed Control File to a Nondefault Location ............................................... 30-2

Recovering After the Loss of All Current Control Files ................................................................ 30-2

Recovering with a Backup Control File in the Default Location ............................................. 30-3

Recovering with a Backup Control File in a Nondefault Location ......................................... 30-4

Recovering Through an Added Datafile with a Backup Control File..................................... 30-4

Recovering Read-Only Tablespaces with a Backup Control File............................................. 30-5

Re-Creating a Control File ................................................................................................................... 30-6

Recovering Through a RESETLOGS with a Created Control File ........................................... 30-7

Recovery of Read-Only Files with a Re-Created Control File .................................................. 30-8

Re-Creating Datafiles When Backups Are Unavailable................................................................ 30-8

Recovering NOLOGGING Tables and Indexes .............................................................................. 30-9

Recovering Transportable Tablespaces ........................................................................................... 30-10

Recovering After the Loss of Online Redo Log Files................................................................... 30-10

Recovering After Losing a Member of a Multiplexed Online Redo Log Group ................. 30-11

Recovering After Losing of All Members of an Online Redo Log Group ............................ 30-12

Recovering from a Dropped Table Without Using Flashback Features ................................... 30-15

Dropping a Database with SQL*Plus.............................................................................................. 30-16

Glossary

Index

otherwise empty line; however, some screen readers may not always read a line of text

that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or

organizations that Oracle does not own or control. Oracle neither evaluates nor makes

any representations regarding the accessibility of these Web sites.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For

information, visit http://www.oracle.com/support/contact.html or visit

http://www.oracle.com/accessibility/support.html if you are hearing

impaired.

会员权益专享

ORACLE 11gR2 数据库备份与恢复全攻略：RMAN与用户管理详解

Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-CSDN博客_rman备份.pdf

windows oracle11g 备份与还原

oracle数据库备份与还原实例

oracle11gr2补丁下载

oracle11gr2是什么版本

windows 下 oracle11备份还原

almalinux安装oracle11gR2

oracle数据库备份与还原

aix7.1安装oracle 11gr2

centos7下安装oracle11gr2

请提供oracle 11gr2的data guard官方中文文档url

centos7安装oracle11gr2依赖包

安装oracle11gr2要怎么配置环境

xshell安装oracle 11gR2

win 2008安装oracle 11gr2

oracle 11gr1 和11gr2,Oracle 11g R1和R2官方下载地址

oracle备份和还原

oracle数据库分开备份还原

centos7.7安装oracle11gr2

centos7.7 oracle11gr2 静默安装 依赖库

会员权益专享

最新资源

centos7.7 oracle11gr2 静默安装依赖库