ITPub博客

首页 > 数据库 > Oracle > SG学习笔记之RMAN不完全恢复

SG学习笔记之RMAN不完全恢复

原创 Oracle 作者:outdo 时间:2006-11-07 09:04:11 0 删除 编辑
RMAN不完全恢复的大致步骤
1. Mount the database. 加载数据库(目标数据库必须加载)
2. Allocate multiple channels for parallelization. 配置通道
3. Restore all datafiles. (备份文件必须由RMAN产生或注册)
4. Recover the database by using UNTIL TIME, UNTIL SEQUENCE, or UNTIL SCN.
5. Open the database by using RESETLOGS.
6. Perform a whole database backup.[@more@]RMAN不完全恢复的大致步骤
1. Mount the database. 加载数据库(目标数据库必须加载)
2. Allocate multiple channels for parallelization. 配置通道
3. Restore all datafiles. (备份文件必须由RMAN产生或注册)
4. Recover the database by using UNTIL TIME, UNTIL SEQUENCE, or UNTIL SCN.
5. Open the database by using RESETLOGS.
6. Perform a whole database backup.
二例子:基于时间或日志序列
RMAN> RUN {
2> ALLOCATE CHANNEL c1 TYPE DISK;
3> ALLOCATE CHANNEL c2 TYPE DISK;
4> SET UNTIL TIME = ‘2001-12-09:11:44:00';
5> RESTORE DATABASE;
6> RECOVER DATABASE;
7> ALTER DATABASE OPEN RESETLOGS; }
RMAN> RUN {
2> SET UNTIL SEQUENCE 120 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE; # recovers through log 119
6> ALTER DATABASE OPEN RESESTLOGS;
7> }

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/167606/viewspace-876285/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-10

  • 博文量
    30
  • 访问量
    775698