Oracle数据库表空间级的异地不完全恢复
??? MAXLOGFILES 192??? MAXLOGMEMBERS 3??? MAXDATAFILES 1024??? MAXINSTANCES 32??? MAXLOGHISTORY 9088LOGFILE? GROUP 1 (??? '/opt/app/oracle/oradata/URPDB/group1_2.log',??? '/opt/app/oracle/oradata/URPDB/group1_1.log'? ) SIZE 10M,? GROUP 2 (??? '/opt/app/oracle/oradata/URPDB/group2_2.log',??? '/opt/app/oracle/oradata/URPDB/group2_1.log'? ) SIZE 10M,? GROUP 3 (??? '/opt/app/oracle/oradata/URPDB/group3_2.log',??? '/opt/app/oracle/oradata/URPDB/group3_1.log'? ) SIZE 10M,? GROUP 11 '/opt/app/oracle/oradata/URPDB/group11_1.log'? SIZE 100M,? GROUP 12 '/opt/app/oracle/oradata/URPDB/group12_1.log'? SIZE 100M,? GROUP 13 '/opt/app/oracle/oradata/URPDB/group13_1.log'? SIZE 100M,? GROUP 14 '/opt/app/oracle/oradata/URPDB/group14_1.log'? SIZE 100M,? GROUP 15 '/opt/app/oracle/oradata/URPDB/group15_1.log'? SIZE 100M-- STANDBY LOGFILEDATAFILE? '/opt/app/oracle/oradata/URPDB/system01.dbf',? '/opt/app/oracle/oradata/URPDB/undotbs1.dbf',? '/opt/app/oracle/oradata/URPDB/sysaux.dbf',? '/opt/app/oracle/oradata/URPDB/users.dbf',? '/opt/app/oracle/oradata/URPDB/undotbs2.dbf',? '/opt/app/oracle/oradata/URPDB/tsp_urp.dbf',? '/opt/app/oracle/oradata/URPDB/tsp_urp_index.dbf',? '/opt/app/oracle/oradata/URPDB/tsp_gxsj.dbf',? '/opt/app/oracle/oradata/URPDB/tsp_urp.dbf_1.ora',? '/opt/app/oracle/oradata/URPDB/tsp_owb.ora',? '/opt/app/oracle/oradata/URPDB/tsp_jc.dbf',? '/opt/app/oracle/oradata/URPDB/tsp_jc_index.dbf',? '/opt/app/oracle/oradata/URPDB/tsp_yjssjck.dbf',? '/opt/app/oracle/oradata/URPDB/undotbs03.dbf',? '/opt/app/oracle/oradata/URPDB/undotbs04.dbf'CHARACTER SET AL32UTF8;mount料；SQL> alter database mount;
select name from v$datafile;--select 'alter database rename file '''||name||''' to '''|| replace(name,'+URPDBDG','/opt/app/oracle/oradata/URPDB')||''';' from? v$datafile;3、份料案拷到rman>catalog start with '/data/urpdb/';?墙外：http://mikixiyou.blogspot.com/2012/04/oracle.html