数据库备份和恢复方案及步骤.doc

操作系统：GNU/Linux 数据库管理系统：Oracle10g 一、安装Recovery Catalog 用dbca创建一个DATABASE catdb，用于存放recovery catalog data [oracle@localhost ~]$dbca 在catdb中创建一个名为rcat_ts的表空间作为用户rman的默认表空间 [oracle@localhost ~]$sqlplus sys/oracle@catdb as sysdba SQL create tablespace rcat_ts; SQL create user rman identified by oracle temporary tablespace temp Default tablespace rcat_ts quota unlimited on rcat_ts; 授予catlog所有者rman recovery_catalog_owner角色，该角色提供给用户所有查询和维护recovery catalog所必需的权限 SQL grant connect,resource,recovery_catalog_owner to rman; 启动rman,以catalog所有者rman登录 [oracle@localhost ~]$rman catalog rman/oracle@catdb RMAN create catalog tablespace rcat_ts; 5，用rman同时连接到target数据库、catalog数据库，在新建的recovery catalog中注册target数据库 [oracle@localhost ~]$rman target sys/oracle@orcl catalog rman/oracle@catdb RMAN register database; 察看已在recovery catalog中注册的target数据库 [oracle@localhost ~]$sqlplus rman/oracle@catdb SQLselect * from db; 配置RMAN?[oracle@localhost ~]$rman target sys/oracle@orcl catalog rman/oracle@catdb 2，RMAN?show all??（检查配置）? ?configure default device type to disk? ?( 设置默认的备份的设备为磁盘）??? ?CONFIGURE DEVICE TYPE DISK PARALLELISM BACKUP TYPE TO BACKUPSET; （设置备份的并行级别）? ?configure channel 1 device type disk format /home/backup_%U??（设置备份文件格式）? ?configure channel 2 device type disk format /home/oraclebackup_%U??（设置备份文件格式）? ?configure controlfile autobackup on? ?(打开控制文件的自动备份）? ?configure controlfile autobackup format for device type disk to ctl_%F （设置控制文件备份格式）. 备份测试? ?备份全库?1，同时连接target数据库和recovery catalog数据库 [oracle@localhost ~]$rman target sys/oracle@orcl catalog rman/oracle@catdb 2，RMAN backup database plus archivelog delete input; 3，连接target数据库 [oracle@localhost ~]$sqlplus sys/oracle@orcl as sysdba SQL conn hr/hr; SQL select salary from employees where employee_id=157; SQL update employees set salary =2000 where employee_id=157; SQL commit; SQL select salary from employees where employee_id=157; 　 四. 恢复测试[oracle@localhost ~]$sqlplus sys/oracle@orcl as sysdba 2，把target数据库先关闭，然后启动到