linux rman备份表空间,LINUX 下ORACLE利用rman备份迁移数据库

第一医院数据库迁移的实施步骤

利用RMAN备份正式库

全库备份及控制文件

RMAN>run{

allocate channel c1 device type disk;

sql 'alter system archive log current';

backup as compressed backupset database format '+ FRA/DYYY/BACKUPSET/db_%d_%T_%U'; sql 'alter system archive log current';

backup current controlfile format '+ FRA/DYYY/controlfile/cntrl_%s_%p_%s';

release channel c1;

}

生成数据库还原脚本restoredatafil e.sql

检查是否有增加数据文件select count(*)from v$datafile；

如果有增加数据库文件必须重新生成

sqlplus /nolog

conn /as sysdba

set serveroutput on;

set linesize 200

spool restore_datafile.rman

declare

cursor df is select file#, name from v$datafile;

begin

dbms_output.put_line('run');

dbms_output.put_line('{');

for dfrec in df loop

dbms_output.put_line('set newname for datafile ' ||

dfrec.file# || ' to ''' || http://www.doczj.com/doc/b81c2d7fa417866fb84a8e3e.html ||''' ;');

end loop;

dbms_output.put_line('restore database;');

dbms_output.put_line('switch datafile all;');

dbms_output.put_line('}');

end;

/

spool off