Oracle Rman Cross-version recovery 11.2.0.3-11.2.0.4

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.