rman异机恢复-凯发app官方网站

rman异机恢复步骤
1) 备份现有主机上的数据库
2) 在新主机上，将控制文件、数据文件和临时文件还原到新位置
3) 在新主机上，重命名联机重做日志
4) 使用 nid 更改db_name 和 dbid （根据需要）
原库db_name：prim
目标db_name：test
$ rman target /
rman> backup database format '/tmp/db_%u';
rman> backup archivelog all format '/tmp/archs_%u';
rman> backup current controlfile format '/tmp/control.bks';
rman> backup spfile format '/tmp/spfile.bks';
如果是非归档模式
$ rman target /
rman> shutdown immediate;
rman> startup mount;
rman> backup database format '/tmp/db_%u';
rman> backup current controlfile format '/tmp/control.bks';
rman> backup spfile format '/tmp/spfile.bks';
scp到目标主机
export oracle_sid = prim
rman> startup nomount force;
rman> restore spfile from '/tmp/spfile.bks';
rman> restore spfile to pfile '/tmp/initnewdb.ora' from '/tmp/spfile.bks';
修改配置参数
$ grep audit /tmp/initnewdb.ora
*.audit_file_dest='//admin/prim/adump'
$ mkdir -p /<path>/admin/prim/adump
sql> shutdown immediate;
sql> startup nomount;
sql> show parameter control_files
sql> show parameter dump
sql> show parameter create
sql> show parameter recovery
还原控制文件
rman> restore controlfile from '/tmp/control.bks';
rman> alter database mount;
rman> report schema;
rman> catalog start with '//';
rman> restore database preview summary;
恢复
rman> run {
# set newname for all datafiles to be mapped to a new path
# or use set newname for database if you wish to have all files located in the same directory
# eg. set newname for database to ' data/inovadg/datafile/%b'
set newname for datafile 1 to 'new file path and name';
...
set newname for tempfile 1 to 'new file path and name';
restore database;
switch datafile all;
switch tempfile all;
}
确认
rman> report schema;
如果从脱机备份中恢复
rman> recover database noredo;
在原库备份期间的归档
rman> backup archivelog all format '/tmp/rest_of_arc_%u.bks;
传到目标主机
scp ...
rman> catalog backuppiece '/tmp/rest_of_arc';
精准恢复
rman> run {# change the date and time to suit
set until time "to_date('01 sep 2011 12:04:00','dd mon yyyy hh24:mi:ss')";
recover database;
}
修改redo位置
sql> select * from v$logfile;
sql> alter database rename file '<old redo log path and name>' to '<new redo log path and name>';
开库
rman> alter database open resetlogs;
补全临时文件
sql> select * from v$tempfile;
sql> alter tablespace temp add tempfile 'new tempfile path filename

阅读(2892) | 评论(0) | 转发(0) |

上一篇：修改pdb参数

下一篇：recover 时需要检查的信息

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们