Oracle rman cross-version recovery 11.2.0.3-11.2.0.4

1. Switch between archives and perform rman full library backup

two。 On the server that was transmitted.

3. Restore it-create the corresponding directory

1. Modify the configuration file and modify the configuration parameters proportionally

Create corresponding directories 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

two。 Write rman recovery script

4. Check 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 10 to'/ home/upt/oracle/oradata/wms/wms_index02.dbf'

Set newname for datafile 11 to'/ home/upt/oracle/oradata/wms/wms_data05.dbf'

Set newname for datafile 12 to'/ home/upt/oracle/oradata/wms/wms_index03.dbf'

Set newname for datafile 13 to'/ home/upt/oracle/oradata/wms/wms_index04.dbf'

Set newname for datafile 14 to'/ home/upt/oracle/oradata/wms/wms_data06.dbf'

Set newname for datafile 15 to'/ home/upt/oracle/oradata/wms/wms_index05.dbf'

Set newname for datafile 16 to'/ 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