ORACLE BACKUP AND RECOVERY

文件:	hotbackup.rar
大小:	0KB
下载:	下载

BACK AND RECOVERY DATABASE

 

MTTR: mean-time-to-recovery

MTBF: mean-time-between-failure

 

Oracle Recovery Structure and Processes:

oracle processes relating to recovery:

DBWR:write dirty buffers from data buffer cache to data file.

LGWR:write data from redo log buffer to redo log file.

SMON:perform automatic instance recovery.

PMON:clear abnormally server process\user connection;rollback and   

     release resource hold by the failed process

CKPT:synchronize the header of datafile and control file with the   

     current redo log and checkpoint number. 

ARC: a process that automatically copies redo log that have been 

     marked for archiving.

 

oracle memory relating to recovery:

data buffer cache:

log buffer:

share pool:

large pool:

 

oracle file relating to recovey:

data file:

redo log file:

control file:

archive log file:

password file:

Parameter file:

 

mainly dynamic view:

v$instance v$process  v$sga   v$bgprocess   v$database v$datafile

 

 

Large Pool:

 相关参数：large_pool_size

          DBWR_IO_SLAVES

          BACKUP_TAPE_IO_SLAVES

 ***RMAN(recovery Manager uses large pool for bakcup and recovery when you set DBWR_IO_SLAVES or BACKUP_TAPE_IO_SLAVES parameters.

 

large_pool_size 的值可以通过查看视图来决定：

   select * from v$sgastat where pool='large pool';

DBWR_IO_SLAVES 默认情况下设置为0；RMAN要求其设置为4

BACKUP_TAPE_IO_SLAVES决定BAKCUP AND RECOVERY时，是否使用DBWR_IO_SLAVES

如果其设置为TRUE 则使用。

 

增加数据文件或扩充现有文件大小：

1）alter tablespace user

  add datafile '...../xx.dbf' size xxM;

 

2）alter database datafile '...../xx.dbf' resize xxxxM;

 

增加日志文件组或成员：

1） alter database

    add logfile  group xx

    '..../xx.dbf' size xxM;

2） alter database

     add logfile member

      ' ...../xx.dbf'  to group x;