Backing Up Logs with BACKUP … PLUS ARCHIVELOG
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:5.0pt; mso-para-margin-right:0cm; mso-para-margin-bottom:0cm; mso-para-margin-left:0cm; mso-para-margin-bottom:.0001pt; mso-para-margin-top:1.0gd; mso-para-margin-right:0cm; mso-para-margin-bottom:0cm;
关于使用Flash Recovery Area后一些初始化参数的使用限制
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:5.0pt; mso-para-margin-right:0cm; mso-para-margin-bottom:0cm; mso-para-margin-left:0cm; mso-para-margin-bottom:.0001pt; mso-para-margin-top:1.0gd; mso-para-margin-right:0cm; mso-para-margin-bottom:0cm;
丢失联机重做日志文件的恢复
/* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-
不同备份方法的特性比较
不同备份方法的特性比较: Feature Recovery Manager User-Managed Export Closed database backups Supported.Requires instance to be mounted. Supported. Not supported. Open database backups Supported.No need to use BEGIN/END BACKUP statements Supported.Must use BEGIN/END BACKUP statements. Requires rollback or undo segments to gene
Crash recovery和Media recovery的区别
Datafile media recovery(often simply called media recovery) is the most basic form of user-initiated data recovery. Crash recovery process is a special form of recovery,witch happens the first time an Oracle database instance is started after a crash (or SHUTDOWN ABORT).In Crash recovery,the goal is to bring the datafiles to a transaction-consistent state,preserving all committed changes up to the point when the instance failed. 两者的重要区别: 1、Media recovery must be expli