Oracle RMAN更改实例名复制数据库
将练习数据库(TRN)的RMAN备份,恢复至测试库(TEST)
1. 修改TEST启动文件参数db_name='TRN'
2. 执行数据恢复操作
[oracle@pmsdb1 ~]$ export ORACLE_SID=TEST [oracle@pmsdb1 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Apr 9 17:18:18 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics and Real Application Testing options SQL> SQL> startup nomount ORACLE instance started. Total System Global Area 1.7180E+10 bytes Fixed Size 3731384 bytes Variable Size 2550136904 bytes Database Buffers 1.4563E+10 bytes Redo Buffers 63377408 bytes SQL> host rman target / Recovery Manager: Release 12.1.0.2.0 - Production on Mon Apr 9 17:18:44 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: TRN (not mounted) RMAN> restore controlfile from '/u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/ctrl_1psvrt00_1_1'; Starting restore at 09-APR-18 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=464 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u01/app/oracle/oradata/datastore/TEST/TEST/controlfile/o1_mf_fdlxvwxq_.ctl Finished restore at 09-APR-18 RMAN> alter database mount; Statement processed released channel: ORA_DISK_1 RMAN> run { set newname for datafile 1 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_system_dxoq807o_.dbf'; set newname for datafile 2 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_sysaux_dxoq81r2_.dbf'; set newname for datafile 3 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_undotbs1_dxoq82fc_.dbf'; set newname for datafile 4 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_undotbs2_dxoq87cm_.dbf'; set newname for datafile 5 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_users_dxoq87kr_.dbf'; set newname for datafile 6 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_data01.dbf'; set newname for datafile 7 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_index01.dbf'; set newname for datafile 8 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_archive_data01.dbf'; set newname for datafile 9 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_archive_index01.dbf'; set newname for datafile 10 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_report_data01.dbf'; set newname for datafile 11 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_report_index01.dbf'; set newname for datafile 12 to '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_lob.dbf'; restore database; switch datafile all; } executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 09-APR-18 Starting implicit crosscheck backup at 09-APR-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=464 device type=DISK Crosschecked 46 objects Finished implicit crosscheck backup at 09-APR-18 Starting implicit crosscheck copy at 09-APR-18 using channel ORA_DISK_1 Finished implicit crosscheck copy at 09-APR-18 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_1_fdowgf8t_.arc File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_17_fdp4o9jl_.arc File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_19_fdp8rkc8_.arc File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_20_fdp8rkh4_.arc File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_17_fdp8rkkj_.arc File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_18_fdp8rklk_.arc File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_1_fdp8rwtn_.arc File Name: /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_18_fdpb0jm8_.arc using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00005 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_users_dxoq87kr_.dbf channel ORA_DISK_1: restoring datafile 00007 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_index01.dbf channel ORA_DISK_1: restoring datafile 00012 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_lob.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_49_1 channel ORA_DISK_1: piece handle=/u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_49_1 tag=TAG20180408T221720 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:01:35 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00003 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_undotbs1_dxoq82fc_.dbf channel ORA_DISK_1: restoring datafile 00004 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_undotbs2_dxoq87cm_.dbf channel ORA_DISK_1: restoring datafile 00009 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_archive_index01.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_51_1 channel ORA_DISK_1: piece handle=/u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_51_1 tag=TAG20180408T221720 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_system_dxoq807o_.dbf channel ORA_DISK_1: restoring datafile 00002 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_sysaux_dxoq81r2_.dbf channel ORA_DISK_1: restoring datafile 00011 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_report_index01.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_50_1 channel ORA_DISK_1: piece handle=/u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_50_1 tag=TAG20180408T221720 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:02:25 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00006 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_data01.dbf channel ORA_DISK_1: restoring datafile 00008 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_archive_data01.dbf channel ORA_DISK_1: restoring datafile 00010 to /u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_report_data01.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_52_1 channel ORA_DISK_1: piece handle=/u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/dbf_20180408_52_1 tag=TAG20180408T221720 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:01:15 Finished restore at 09-APR-18 datafile 1 switched to datafile copy input datafile copy RECID=15 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_system_fdpd45op_.dbf datafile 2 switched to datafile copy input datafile copy RECID=16 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_sysaux_fdpd45pf_.dbf datafile 3 switched to datafile copy input datafile copy RECID=17 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_undotbs1_fdpd3ymv_.dbf datafile 4 switched to datafile copy input datafile copy RECID=18 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_undotbs2_fdpd3yno_.dbf datafile 5 switched to datafile copy input datafile copy RECID=19 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/o1_mf_users_fdpd0zm0_.dbf datafile 6 switched to datafile copy input datafile copy RECID=20 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_data01.dbf datafile 7 switched to datafile copy input datafile copy RECID=21 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_index01.dbf datafile 8 switched to datafile copy input datafile copy RECID=22 STAMP=973013089 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_archive_data01.dbf datafile 9 switched to datafile copy input datafile copy RECID=23 STAMP=973013090 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_archive_index01.dbf datafile 10 switched to datafile copy input datafile copy RECID=24 STAMP=973013090 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_report_data01.dbf datafile 11 switched to datafile copy input datafile copy RECID=25 STAMP=973013090 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_report_index01.dbf datafile 12 switched to datafile copy input datafile copy RECID=26 STAMP=973013090 file name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/ifsapp_lob.dbf RMAN> recover database; Starting recover at 09-APR-18 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 18 is already on disk as file /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_18_fdpb0jm8_.arc archived log for thread 2 with sequence 17 is already on disk as file /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_17_fdp4o9jl_.arc archived log for thread 1 with sequence 1 is already on disk as file /u01/app/oracle/oradata/datastore/TRN/TRN/onlinelog/redo01.log archived log for thread 2 with sequence 1 is already on disk as file /u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_1_fdp8rwtn_.arc channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=15 channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=14 channel ORA_DISK_1: reading from backup piece /u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/arch_20180408_55_1 channel ORA_DISK_1: piece handle=/u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/arch_20180408_55_1 tag=TAG20180408T221943 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_15_fdpdcl3n_.arc thread=1 sequence=15 archived log file name=/u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_14_fdpdcl38_.arc thread=2 sequence=14 channel default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_14_fdpdcl38_.arc RECID=44 STAMP=973013106 channel ORA_DISK_1: starting archived log restore to default destination channel ORA_DISK_1: restoring archived log archived log thread=2 sequence=15 channel ORA_DISK_1: restoring archived log archived log thread=1 sequence=16 channel ORA_DISK_1: reading from backup piece /u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/arch_20180408_56_1 channel ORA_DISK_1: piece handle=/u02/app/oracle/oradata/datastore/backup/TRN/2018-04-08/arch_20180408_56_1 tag=TAG20180408T221943 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_2_15_fdpdcmd8_.arc thread=2 sequence=15 channel default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_15_fdpdcl3n_.arc RECID=45 STAMP=973013106 archived log file name=/u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_16_fdpdcmdk_.arc thread=1 sequence=16 channel default: deleting archived log(s) archived log file name=/u01/app/oracle/fast_recovery_area/datastore/TEST/TEST/archivelog/2018_04_09/o1_mf_1_16_fdpdcmdk_.arc RECID=47 STAMP=973013107 unable to find archived log archived log thread=1 sequence=17 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 04/09/2018 17:25:08 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 17 and starting SCN of 95743019 RMAN> exit Recovery Manager complete. SQL> alter database rename file '/u01/app/oracle/oradata/datastore/TRN/TRN/onlinelog/redo02.log' TO '/u01/app/oracle/oradata/datastore/TEST/TEST/onlinelog/redo02.log'; alter database rename file '/u01/app/oracle/oradata/datastore/TRN/TRN/onlinelog/redo01.log' TO '/u01/app/oracle/oradata/datastore/TEST/TEST/onlinelog/redo01.log'; alter database rename file '/u01/app/oracle/oradata/datastore/TRN/TRN/onlinelog/redo03.log' TO '/u01/app/oracle/oradata/datastore/TEST/TEST/onlinelog/redo03.log'; alter database rename file '/u01/app/oracle/oradata/datastore/TRN/TRN/onlinelog/redo04.log' TO '/u01/app/oracle/oradata/datastore/TEST/TEST/onlinelog/redo04.log'; Database altered. SQL> Database altered. SQL> Database altered. SQL> Database altered. SQL> alter database open resetlogs; Database altered. SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/u02/app/oracle/oradata/datastore/.ACFS/snaps/TEST/TEST/datafile/temp01.tmp' SIZE 1000M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M; Tablespace altered. SQL> shu immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 1.7180E+10 bytes Fixed Size 3731384 bytes Variable Size 2550136904 bytes Database Buffers 1.4563E+10 bytes Redo Buffers 63377408 bytes Database mounted. Database opened. SQL>