-
编辑 删除
10.2和以上版本的pga动态工作区管理
10.2和以上版本的pga动态工作区管理：_pga_max_size范围为200m到2g（64位）1g（32位）当_pga_max_size=200m的时候，工作区的大小由_smm_max_size决定，_smm_max_size等于pga_aggregate_target的20%当pga_aggregate_t...
-
编辑 删除
database records an archived log in the control file
The archiver process archives a redo logRMAN restores an archived logThe RMAN BACKUP AS COPY command copies a logThe RMAN CATALOG command catalogs a user-managed backup of an archived log...
-
编辑 删除
When RMAN Performs Control File Autobackups
By default, control file autobackups are turned off, and no control file autobackups are performed. If CONFIGURE CONTROLFILE AUTOBACKUP is ON, then RMAN automatically backs up the control file and th...
-
编辑 删除
Planning an Incremental Backup Strategy
Choose a backup scheme according to an acceptable MTTR (mean time to recover). For example, you can implement a three-level backup scheme so that a full or level 0 backup is taken monthly, a cumulati...
-
编辑 删除
Multiple Copies of RMAN Backups
1、 it is not possible to duplex backup sets to the flash recovery area用FRA区域存放bankupset的时候无法采用多路技术RMAN> delete noprompt backupset;using channel ORA_DISK_1RMAN> show all;RMAN conf...
-
编辑 删除
关于flashback log
Flashback Database uses its own logging mechanism, creating flashback logs which are stored in the flash recovery area. You can only use Flashback Database if flashback logs are available. Therefore, ...
-
编辑 删除
maximum control file size？？
The maximum control file size is 20000 database blocks. If DB_BLOCK_SIZE equals 8192, then the maximum control file size is 156 MB.另外只有在10g之后control file才能自动扩展
-
编辑 删除
Renaming a Datafile in the Primary Database
When you rename one or more datafiles in the primary database, the change is not propagated to the standby database. Therefore, if you want to rename the same datafiles on the standby database, you mu...
-
编辑 删除
Duplicate Database fails with Rman-5001 [ID 334588.1]
Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.5 to 11.2.0.2 - Release: 9.2 to 11.2Information in this document applies to any platform.***Checked for relevance on 15-Dec-2010*** Sym...
-
编辑 删除
Oracle backup fails with error RMAN-06056: could not access datafile
ProblemOracle backup fails with error "RMAN-06056: could not access datafile".SolutionRMAN OUTPUTcould not read file header for datafile 189 error reason 1 released channel:ch0RMAN-00571: ======...
