1. Switch archive, perform rman full library backup
2. On the transmitting server.
3. Restore it--create a corresponding directory
1. Modify the configuration file, proportionally modify the configuration parameters
Create a corresponding directory based on these directory changes
Mkdir-p/home/opt/oracle/diag/rdbms/wms/wms
Mkdir-p/home/opt/oracle/diag/rdbms/wms/wms/trace
Mkdir-p/home/opt/oracle/diag/rdbms/wms/wms/alert
Mkdir-p/home/opt/oracle/diag/rdbms/wms/wms/incident
Mkdir-p/home/opt/oracle/diag/rdbms/wms/wms/cdump
Mkdir-p/HOME/OPT/ORACLE/DIAG/RDBMS/WMS/WMS/HM
Mkdir-p/home/opt/oracle/admin/wms/adump
Mkdir-p/home/opt/oracle/admin/wms/pfile
Mkdir-p/home/opt/oracle/admin/wms/dpdump
Mkdir-p/home/upt/oracle/oradata/wms
Mkdir-p/home/upt/oracle/fast_recovery_area/wms
Mkdir-p/home/upt/oracle/arch
2. Write Rman Recovery script
4. Verifying Objects and data
Restore Controlfile from '/home/upt/data/20150920235901/wms_full_20150920235901_c-324000772-20150921-01 ';
SQL ' ALTER DATABASE mount ';
Catalog start with '/home/upt/data/20150920235901 ';
run{
Set newname for datafile 1 to '/home/upt/oracle/oradata/wms/system01.dbf ';
Set newname for datafile 2 to '/home/upt/oracle/oradata/wms/sysaux01.dbf ';
Set newname for DataFile 3 to '/home/upt/oracle/oradata/wms/undotbs01.dbf ';
Set newname for datafile 4 to '/home/upt/oracle/oradata/wms/users01.dbf ';
Set newname for datafile 5 to '/home/upt/oracle/oradata/wms/wms_data01.dbf ';
Set newname for datafile 6 to '/home/upt/oracle/oradata/wms/wms_data02.dbf ';
Set newname for datafile 7 to '/home/upt/oracle/oradata/wms/wms_data03.dbf ';
Set newname for datafile 8 to '/home/upt/oracle/oradata/wms/wms_index01.dbf ';
Set newname for DataFile 9 to '/home/upt/oracle/oradata/wms/wms_data04.dbf ';
Set newname for datafile '/home/upt/oracle/oradata/wms/wms_index02.dbf ';
Set newname for datafile one to '/home/upt/oracle/oradata/wms/wms_data05.dbf ';
Set newname for DataFile "/HOME/UPT/ORACLE/ORADATA/WMS/WMS_INDEX03.DBF";
Set newname for DataFile "/HOME/UPT/ORACLE/ORADATA/WMS/WMS_INDEX04.DBF";
Set newname for DataFile "/HOME/UPT/ORACLE/ORADATA/WMS/WMS_DATA06.DBF";
Set newname for DataFile "/HOME/UPT/ORACLE/ORADATA/WMS/WMS_INDEX05.DBF";
Set newname for DataFile "/HOME/UPT/ORACLE/ORADATA/WMS/WMS_INDEX06.DBF";
Set newname for Tempfile 1 to '/home/upt/oracle/oradata/wms/temp01.dbf ';
Restore database;
Switch datafile all;
Switch Tempfile all;
Recover database;
}
--Online log redo logfile processing
Alter DATABASE rename file '/home/opt/oracle/oradata/wms/redo04.log ' to '/home/upt/oracle/oradata/wms/redo04.log ';
ALTER DATABASE clear logfile Group 4;
ALTER DATABASE drop logfile Group 4;
ALTER DATABASE Add logfile Group 4 '/home/upt/oracle/oradata/wms/redo04.log ' size 100m;
Alter DATABASE rename file '/home/opt/oracle/oradata/wms/redo05.log ' to '/home/upt/oracle/oradata/wms/redo05.log ';
ALTER DATABASE clear logfile Group 5;
ALTER DATABASE Add logfile Group 5 '/home/upt/oracle/oradata/wms/redo05.log ' size 100m;
Alter DATABASE rename file '/home/opt/oracle/oradata/wms/redo06.log ' to '/home/upt/oracle/oradata/wms/redo06.log ';
ALTER DATABASE clear logfile Group 6;
ALTER DATABASE Add logfile Group 6 '/home/upt/oracle/oradata/wms/redo06.log ' size 100m;
--Upgrade
Sql>startup Upgrade
Sql>@?/rdbms/admin/catupgrd.sql
Sql>@?/rdbms/admin/catalog.sql
Sql>@?/rdbms/admin/catproc.sql
Sql>@?/rdbms/admin/utlrp.sql
Sql>shutdown Immediate
Sql>startup
Oracle Rman Cross-version recovery 11.2.0.3-11.2.0.4