因为要被审计的数据库有10T大小，用逻辑导出导入方式复制一份数据用于审计满足不了时间要求，而且生产环境没有空间用于执行逻辑备份或物理备份，所以执行rman物理备份时只能通过nfs将备份文件直接存储在目标主机上。但我这里的测试还是在生产环境中执行rman备份，这个只是测试可行性。下面是将生产库通过rman备份在异机上执行恢复的具体步骤:
1.对源库执行全库备份脚本
vi backup.sh backtime=`date +"20%y%m%d%H%M%S"` rman target / log=/rmanbak/dadb_backupall_$backtime.log <2.执行备份脚本对源库执行备份
[oracle@dbs1 rmanbak]$ ./jy.sh RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> using target database control file instead of recovery catalog allocated channel: c1 channel c1: SID=3694 instance=dadb1 device type=DISK allocated channel: c2 channel c2: SID=1849 instance=dadb1 device type=DISK Starting backup at 06-MAR-24 channel c1: starting compressed full datafile backup set channel c1: specifying datafile(s) in backup set input datafile file number=00002 name=+DA/dadbp/datafile/sysaux.260.1109022421 input datafile file number=00007 name=+DA/dadbp/datafile/system001.dbf input datafile file number=00010 name=+DA/dadbp/datafile/test.288.1109026503 input datafile file number=00004 name=+DA/dadbp/datafile/users.267.1109022873 input datafile file number=00006 name=+DA/dadbp/datafile/hygeia.261.1109022717 channel c1: starting piece 1 at 06-MAR-24 channel c2: starting compressed full datafile backup set channel c2: specifying datafile(s) in backup set input datafile file number=00008 name=+DA/dadbp/datafile/sysaux.259.1109022127 input datafile file number=00001 name=+DA/dadbp/datafile/system.263.1109022847 input datafile file number=00005 name=+DA/dadbp/datafile/undotbs2.264.1109022863 input datafile file number=00003 name=+DA/dadbp/datafile/undotbs1.265.1109022869 input datafile file number=00009 name=+DA/dadbp/datafile/cs01.bdf channel c2: starting piece 1 at 06-MAR-24 channel c2: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_DADB_20240306_vv2l0hog_1_1 tag=DA_FULL_BAK comment=NONE channel c2: backup set complete, elapsed time: 00:14:35 channel c2: starting compressed full datafile backup set channel c2: specifying datafile(s) in backup set including current control file in backup set channel c2: starting piece 1 at 06-MAR-24 channel c2: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_DADB_20240306_002l0ijr_1_1 tag=DA_FULL_BAK comment=NONE channel c2: backup set complete, elapsed time: 00:00:03 channel c2: starting compressed full datafile backup set channel c2: specifying datafile(s) in backup set including current SPFILE in backup set channel c2: starting piece 1 at 06-MAR-24 channel c2: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_DADB_20240306_012l0ijv_1_1 tag=DA_FULL_BAK comment=NONE channel c2: backup set complete, elapsed time: 00:00:01 channel c1: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_DADB_20240306_vu2l0hog_1_1 tag=DA_FULL_BAK comment=NONE channel c1: backup set complete, elapsed time: 00:18:24 Finished backup at 06-MAR-24 sql statement: alter system archive log current Starting backup at 06-MAR-24 current log archived channel c1: starting archived log backup set channel c1: specifying archived log(s) in backup set input archived log thread=1 sequence=36171 RECID=12088 STAMP=1162596765 input archived log thread=2 sequence=27786 RECID=12094 STAMP=1162628068 input archived log thread=1 sequence=36172 RECID=12090 STAMP=1162625683 input archived log thread=1 sequence=36173 RECID=12092 STAMP=1162628067 input archived log thread=1 sequence=36174 RECID=12096 STAMP=1162645216 input archived log thread=2 sequence=27787 RECID=12098 STAMP=1162663210 input archived log thread=1 sequence=36175 RECID=12101 STAMP=1162679311 input archived log thread=2 sequence=27788 RECID=12102 STAMP=1162679311 input archived log thread=1 sequence=36176 RECID=12104 STAMP=1162679313 input archived log thread=2 sequence=27789 RECID=12106 STAMP=1162679314 input archived log thread=1 sequence=36177 RECID=12108 STAMP=1162683167 input archived log thread=2 sequence=27790 RECID=12114 STAMP=1162714548 input archived log thread=1 sequence=36178 RECID=12110 STAMP=1162713627 input archived log thread=1 sequence=36179 RECID=12112 STAMP=1162714545 input archived log thread=1 sequence=36180 RECID=12116 STAMP=1162750588 input archived log thread=2 sequence=27791 RECID=12120 STAMP=1162765758 channel c1: starting piece 1 at 06-MAR-24 channel c2: starting archived log backup set channel c2: specifying archived log(s) in backup set input archived log thread=1 sequence=36181 RECID=12118 STAMP=1162765756 input archived log thread=1 sequence=36182 RECID=12124 STAMP=1162765763 input archived log thread=2 sequence=27792 RECID=12122 STAMP=1162765761 input archived log thread=2 sequence=27793 RECID=12130 STAMP=1162800019 input archived log thread=1 sequence=36183 RECID=12126 STAMP=1162769575 input archived log thread=1 sequence=36184 RECID=12128 STAMP=1162800017 input archived log thread=1 sequence=36185 RECID=12132 STAMP=1162801020 input archived log thread=2 sequence=27794 RECID=12136 STAMP=1162850453 input archived log thread=1 sequence=36186 RECID=12134 STAMP=1162846806 input archived log thread=1 sequence=36187 RECID=12138 STAMP=1162852076 input archived log thread=2 sequence=27795 RECID=12140 STAMP=1162852078 input archived log thread=1 sequence=36188 RECID=12144 STAMP=1162852082 input archived log thread=2 sequence=27796 RECID=12142 STAMP=1162852080 input archived log thread=2 sequence=27797 RECID=12150 STAMP=1162887460 input archived log thread=1 sequence=36189 RECID=12146 STAMP=1162855991 input archived log thread=1 sequence=36190 RECID=12148 STAMP=1162887457 input archived log thread=1 sequence=36191 RECID=12154 STAMP=1162890083 input archived log thread=2 sequence=27798 RECID=12152 STAMP=1162890082 channel c2: starting piece 1 at 06-MAR-24 channel c1: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_arc_1162890092_21506 tag=DA_ARC_BAK comment=NONE channel c1: backup set complete, elapsed time: 00:00:15 channel c1: starting archived log backup set channel c1: specifying archived log(s) in backup set input archived log thread=2 sequence=27799 RECID=12158 STAMP=1162890088 input archived log thread=1 sequence=36192 RECID=12156 STAMP=1162890086 channel c1: starting piece 1 at 06-MAR-24 channel c2: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_arc_1162890092_21507 tag=DA_ARC_BAK comment=NONE channel c2: backup set complete, elapsed time: 00:00:15 channel c1: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_arc_1162890107_21508 tag=DA_ARC_BAK comment=NONE channel c1: backup set complete, elapsed time: 00:00:01 Finished backup at 06-MAR-24 Starting backup at 06-MAR-24 channel c1: starting full datafile backup set channel c1: specifying datafile(s) in backup set including current control file in backup set channel c1: starting piece 1 at 06-MAR-24 channel c1: finished piece 1 at 06-MAR-24 piece handle=/rmanbak/dadb_cntrl_21509_1_21509 tag=DA_CONTROL_BAK comment=NONE channel c1: backup set complete, elapsed time: 00:00:01 Finished backup at 06-MAR-24 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_02/thread_1_seq_36171.938.1162596765 RECID=12088 STAMP=1162596765 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_1_seq_36172.317.1162625683 RECID=12090 STAMP=1162625683 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_1_seq_36173.2388.1162628067 RECID=12092 STAMP=1162628067 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_1_seq_36174.1976.1162645215 RECID=12096 STAMP=1162645216 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_1_seq_36175.370.1162679311 RECID=12101 STAMP=1162679311 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_1_seq_36176.962.1162679313 RECID=12104 STAMP=1162679313 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_1_seq_36177.2719.1162683167 RECID=12108 STAMP=1162683167 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_1_seq_36178.2575.1162713627 RECID=12110 STAMP=1162713627 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_1_seq_36179.2282.1162714545 RECID=12112 STAMP=1162714545 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_1_seq_36180.1884.1162750589 RECID=12116 STAMP=1162750588 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_1_seq_36181.973.1162765757 RECID=12118 STAMP=1162765756 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_1_seq_36182.2148.1162765763 RECID=12124 STAMP=1162765763 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_1_seq_36183.1132.1162769575 RECID=12126 STAMP=1162769575 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_1_seq_36184.2397.1162800017 RECID=12128 STAMP=1162800017 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_1_seq_36185.1359.1162801021 RECID=12132 STAMP=1162801020 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_1_seq_36186.2488.1162846805 RECID=12134 STAMP=1162846806 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_1_seq_36187.2068.1162852077 RECID=12138 STAMP=1162852076 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_1_seq_36188.2513.1162852083 RECID=12144 STAMP=1162852082 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_1_seq_36189.2592.1162855991 RECID=12146 STAMP=1162855991 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_06/thread_1_seq_36190.287.1162887457 RECID=12148 STAMP=1162887457 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_06/thread_1_seq_36191.2276.1162890083 RECID=12154 STAMP=1162890083 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_06/thread_1_seq_36192.1168.1162890087 RECID=12156 STAMP=1162890086 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_2_seq_27786.2448.1162628069 RECID=12094 STAMP=1162628068 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_2_seq_27787.1182.1162663211 RECID=12098 STAMP=1162663210 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_2_seq_27788.567.1162679311 RECID=12102 STAMP=1162679311 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_03/thread_2_seq_27789.2305.1162679315 RECID=12106 STAMP=1162679314 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_2_seq_27790.2769.1162714549 RECID=12114 STAMP=1162714548 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_2_seq_27791.2742.1162765757 RECID=12120 STAMP=1162765758 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_04/thread_2_seq_27792.1811.1162765761 RECID=12122 STAMP=1162765761 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_2_seq_27793.1189.1162800019 RECID=12130 STAMP=1162800019 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_2_seq_27794.1140.1162850449 RECID=12136 STAMP=1162850453 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_2_seq_27795.2058.1162852077 RECID=12140 STAMP=1162852078 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_05/thread_2_seq_27796.2345.1162852081 RECID=12142 STAMP=1162852080 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_06/thread_2_seq_27797.1391.1162887461 RECID=12150 STAMP=1162887460 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_06/thread_2_seq_27798.2100.1162890083 RECID=12152 STAMP=1162890082 validation succeeded for archived log archived log file name=+ARCH/dadbp/archivelog/2024_03_06/thread_2_seq_27799.2212.1162890089 RECID=12158 STAMP=1162890088 Crosschecked 36 objects crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240303_v62kq4gm_1_1 RECID=21314 STAMP=1162678806 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240303_v72kq4uk_1_1 RECID=21315 STAMP=1162679259 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240303_v52kq4gm_1_1 RECID=21317 STAMP=1162678806 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162679319_21482 RECID=21318 STAMP=1162679319 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162679319_21481 RECID=21319 STAMP=1162679319 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162679326_21483 RECID=21320 STAMP=1162679326 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/cntrl_21484_1_21484 RECID=21321 STAMP=1162679331 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240304_ve2ksoso_1_1 RECID=21322 STAMP=1162765208 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240304_vf2kspbt_1_1 RECID=21323 STAMP=1162765719 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240304_vg2kspco_1_1 RECID=21324 STAMP=1162765720 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240304_vd2ksoso_1_1 RECID=21325 STAMP=1162765208 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162765766_21490 RECID=21326 STAMP=1162765767 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162765766_21489 RECID=21327 STAMP=1162765766 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/cntrl_21491_1_21491 RECID=21328 STAMP=1162765777 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240305_vl2kvd8m_1_1 RECID=21329 STAMP=1162851606 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240305_vm2kvdll_1_1 RECID=21330 STAMP=1162852028 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240305_vn2kvdlt_1_1 RECID=21331 STAMP=1162852029 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/db_DADB_20240305_vk2kvd8m_1_1 RECID=21332 STAMP=1162851606 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162852086_21496 RECID=21333 STAMP=1162852086 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162852086_21497 RECID=21334 STAMP=1162852086 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/arc_1162852093_21498 RECID=21335 STAMP=1162852093 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dangan/cntrl_21499_1_21499 RECID=21336 STAMP=1162852098 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_DADB_20240306_vv2l0hog_1_1 RECID=21337 STAMP=1162888976 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_DADB_20240306_002l0ijr_1_1 RECID=21338 STAMP=1162889852 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_DADB_20240306_012l0ijv_1_1 RECID=21339 STAMP=1162889855 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_DADB_20240306_vu2l0hog_1_1 RECID=21340 STAMP=1162888976 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_arc_1162890092_21506 RECID=21341 STAMP=1162890092 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_arc_1162890092_21507 RECID=21342 STAMP=1162890092 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_arc_1162890107_21508 RECID=21343 STAMP=1162890107 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/rmanbak/dadb_cntrl_21509_1_21509 RECID=21344 STAMP=1162890110 Crosschecked 30 objects specification does not match any backup in the repository RMAN retention policy will be applied to the command RMAN retention policy is set to recovery window of 7 days no obsolete backups found released channel: c1 released channel: c2 RMAN> Recovery Manager complete.3.将备份文件拷贝到目标主机上
[root@dbs1 rmanbak]# scp dadb* 10.18.10.101:/databak/dadb/ root@10.18.10.101's password: dadb_arc_1162890092_21506 100% 970MB 88.2MB/s 00:11 dadb_arc_1162890092_21507 100% 854MB 85.4MB/s 00:10 dadb_arc_1162890107_21508 100% 20KB 20.0KB/s 00:00 dadb_backupall_20240306084252.log 100% 17KB 16.7KB/s 00:00 dadb_cntrl_21509_1_21509 100% 85MB 85.4MB/s 00:00 dadb_DADB_20240306_002l0ijr_1_1 100% 5344KB 5.2MB/s 00:01 dadb_DADB_20240306_012l0ijv_1_1 100% 96KB 96.0KB/s 00:00 dadb_DADB_20240306_vu2l0hog_1_1 100% 5794MB 90.5MB/s 01:04 dadb_DADB_20240306_vv2l0hog_1_1 100% 4626MB 94.4MB/s 00:49 [root@dbs1 rmanbak]#4.将源库的密码文件复制到目标主机上
[root@dbs1 rmanbak]# scp /u01/app/oracle/product/11.2.0.4/db/dbs/orapwdadb1 10.18.10.101:/u01/app/oracle/product/11.2.0.4/db/dbs/ root@10.18.10.101's password: orapwdadb1 100% 1536 1.5KB/s 00:00 [root@dbs1 rmanbak]#5.恢复初始化参数文件(这里需要找到包含初始化参数文件的备份集,在源端数据库可以通过list backup可以找到包含参数文件的备份集)
[oracle@sjjh dbs]$ rman target/ Recovery Manager: Release 11.2.0.4.0 - Production on Wed Mar 6 09:39:47 2024 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database (not started) RMAN> startup nomount startup failed: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0.4/db/dbs/initdadb.ora' starting Oracle instance without parameter file for retrieval of spfile Oracle instance started Total System Global Area 1068937216 bytes Fixed Size 2260088 bytes Variable Size 327156616 bytes Database Buffers 734003200 bytes Redo Buffers 5517312 bytes RMAN> restore spfile to pfile '/u01/app/oracle/product/11.2.0.4/db/dbs/initdadb.ora' from '/databak/dadb/dadb_DADB_20240306_012l0ijv_1_1'; Starting restore at 06-MAR-24 using channel ORA_DISK_1 channel ORA_DISK_1: restoring spfile from AUTOBACKUP /databak/dadb/dadb_DADB_20240306_012l0ijv_1_1 channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete Finished restore at 06-MAR-246.修改控制文件
[oracle@sjjh dbs]$ cat initdadb.ora dadb1.__db_cache_size=5133828096 dadb2.__db_cache_size=6442450944 dadb1.__java_pool_size=234881024 dadb2.__java_pool_size=234881024 dadb1.__large_pool_size=268435456 dadb2.__large_pool_size=268435456 dadb1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment dadb1.__pga_aggregate_target=5368709120 dadb2.__pga_aggregate_target=5368709120 dadb1.__sga_target=10737418240 dadb2.__sga_target=10737418240 dadb1.__shared_io_pool_size=536870912 dadb2.__shared_io_pool_size=0 dadb1.__shared_pool_size=4429185024 dadb2.__shared_pool_size=3724541952 dadb1.__streams_pool_size=67108864 dadb2.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/dadb/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_files='/oradata/dadb/controlfile/control01.ctl','/oradata/dadb/controlfile/control02.ctl' *.db_block_size=8192 *.db_create_file_dest='/oradata/dadb' *.db_domain='' *.db_file_name_convert='+da/dadbs/','/oradata/dadb/' *.db_name='dadb' *.db_unique_name='dadbp' *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=dadbXDB)' dadb2.instance_number=2 dadb1.instance_number=1 *.log_archive_dest_1='location=/oradata/arch valid_for=(all_logfiles,all_roles) db_unique_name=dadb' *.log_archive_dest_2='' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='enable' *.log_archive_format='%t_%s_%r.arch' *.log_file_name_convert='+da/dadbs/','/oradata/dadb/' *.open_cursors=300 *.pga_aggregate_target=5368709120 *.processes=3000 *.remote_login_passwordfile='exclusive' *.service_names='dadb' *.sessions=3305 *.sga_max_size=10737418240 *.sga_target=10737418240 dadb2.thread=2 dadb1.thread=1 dadb1.undo_tablespace='UNDOTBS1' dadb2.undo_tablespace='UNDOTBS2' [oracle@sjjh dbs]$ mkdir -p /u01/app/oracle/admin/dadb/adump7.使用恢复的初始化参数文件nomount数据库
RMAN> shutdown immediate Oracle instance shut down RMAN> startup nomount pfile='/u01/app/oracle/product/11.2.0.4/db/dbs/initdadb.ora' Oracle instance started Total System Global Area 10689474560 bytes Fixed Size 2262656 bytes Variable Size 2785020288 bytes Database Buffers 7885291520 bytes Redo Buffers 16900096 bytes8.恢复控制文件
RMAN> restore controlfile from '/databak/dadb/dadb_DADB_20240306_002l0ijr_1_1'; Starting restore at 06-MAR-24 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1982 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:03 output file name=/oradata/dadb/controlfile/control01.ctl output file name=/oradata/dadb/controlfile/control02.ctl Finished restore at 06-MAR-249.启动数据库到mount状态
RMAN> alter database mount; database mounted released channel: ORA_DISK_110.将备份集的信息加入到catalog,使目前的控制文件记录有目前的备份信息,以便用户恢复.从远端数据库拷贝过来的备份集存放于目录/databak/dadb/
RMAN> catalog start with '/databak/dadb/'; searching for all files that match the pattern /databak/dadb/ List of Files Unknown to the Database ===================================== File Name: /databak/dadb/dadb_cntrl_21509_1_21509 File Name: /databak/dadb/dadb_DADB_20240306_vu2l0hog_1_1 File Name: /databak/dadb/dadb_DADB_20240306_002l0ijr_1_1 File Name: /databak/dadb/dadb_arc_1162890092_21506 File Name: /databak/dadb/dadb_DADB_20240306_012l0ijv_1_1 File Name: /databak/dadb/dadb_arc_1162890092_21507 File Name: /databak/dadb/dadb_arc_1162890107_21508 File Name: /databak/dadb/dadb_DADB_20240306_vv2l0hog_1_1 Do you really want to catalog the above files (enter YES or NO)? YES cataloging files... cataloging done List of Cataloged Files ======================= File Name: /databak/dadb/dadb_cntrl_21509_1_21509 File Name: /databak/dadb/dadb_DADB_20240306_vu2l0hog_1_1 File Name: /databak/dadb/dadb_DADB_20240306_002l0ijr_1_1 File Name: /databak/dadb/dadb_arc_1162890092_21506 File Name: /databak/dadb/dadb_DADB_20240306_012l0ijv_1_1 File Name: /databak/dadb/dadb_arc_1162890092_21507 File Name: /databak/dadb/dadb_arc_1162890107_21508 File Name: /databak/dadb/dadb_DADB_20240306_vv2l0hog_1_111.还原数据文件
RMAN> run{ 2> allocate channel c1 device type disk; 3> allocate channel c2 device type disk; 4> set newname for datafile '+DA/dadbp/datafile/cs01.bdf' to '/oradata/dadb/cs01.dbf'; 5> set newname for datafile '+DA/dadbp/datafile/hygeia.261.1109022717' to '/oradata/dadb/hygeia.dbf'; 6> set newname for datafile '+DA/dadbp/datafile/sysaux.260.1109022421' to '/oradata/dadb/sysaux01.dbf'; 7> set newname for datafile '+DA/dadbp/datafile/sysaux.259.1109022127' to '/oradata/dadb/sysaux.dbf'; 8> set newname for datafile '+DA/dadbp/datafile/system.263.1109022847' to '/oradata/dadb/system.dbf'; 9> set newname for datafile '+DA/dadbp/datafile/system001.dbf' to '/oradata/dadb/system001.dbf'; 10> set newname for datafile '+DA/dadbp/datafile/test.288.1109026503' to '/oradata/dadb/test.dbf'; 11> set newname for datafile '+DA/dadbp/datafile/undotbs1.265.1109022869' to '/oradata/dadb/undotbs1.dbf'; 12> set newname for datafile '+DA/dadbp/datafile/undotbs2.264.1109022863' to '/oradata/dadb/undotbs2.dbf'; 13> set newname for datafile '+DA/dadbp/datafile/users.267.1109022873' to '/oradata/dadb/users.dbf'; 14> restore database; 15> switch datafile all; 16> release channel c1; 17> release channel c2; 18> } released channel: ORA_DISK_1 allocated channel: c1 channel c1: SID=1982 device type=DISK allocated channel: c2 channel c2: SID=2266 device type=DISK 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 06-MAR-24 channel c1: starting datafile backup set restore channel c1: specifying datafile(s) to restore from backup set channel c1: restoring datafile 00002 to /oradata/dadb/sysaux01.dbf channel c1: restoring datafile 00004 to /oradata/dadb/users.dbf channel c1: restoring datafile 00006 to /oradata/dadb/hygeia.dbf channel c1: restoring datafile 00007 to /oradata/dadb/system001.dbf channel c1: restoring datafile 00010 to /oradata/dadb/test.dbf channel c1: reading from backup piece /databak/dadb/dadb_DADB_20240306_vu2l0hog_1_1 channel c2: starting datafile backup set restore channel c2: specifying datafile(s) to restore from backup set channel c2: restoring datafile 00001 to /oradata/dadb/system.dbf channel c2: restoring datafile 00003 to /oradata/dadb/undotbs1.dbf channel c2: restoring datafile 00005 to /oradata/dadb/undotbs2.dbf channel c2: restoring datafile 00008 to /oradata/dadb/sysaux.dbf channel c2: restoring datafile 00009 to /oradata/dadb/cs01.dbf channel c2: reading from backup piece /databak/dadb/dadb_DADB_20240306_vv2l0hog_1_1 channel c2: piece handle=/databak/dadb/dadb_DADB_20240306_vv2l0hog_1_1 tag=DA_FULL_BAK channel c2: restored backup piece 1 channel c2: restore complete, elapsed time: 00:20:26 channel c1: piece handle=/databak/dadb/dadb_DADB_20240306_vu2l0hog_1_1 tag=DA_FULL_BAK channel c1: restored backup piece 1 channel c1: restore complete, elapsed time: 00:25:36 Finished restore at 06-MAR-24 released channel: c1 released channel: c212.还原归档日志文件
RMAN> run{ 2> allocate channel c1 device type disk; 3> allocate channel c2 device type disk; 4> set archivelog destination to '/oradata/arch/'; 5> restore archivelog from logseq 36171 until logseq 36192 thread 1; 6> restore archivelog from logseq 27786 until logseq 27799 thread 2; 7> release channel c1; 8> release channel c2; 9> } allocated channel: c1 channel c1: SID=1700 device type=DISK allocated channel: c2 channel c2: SID=1982 device type=DISK executing command: SET ARCHIVELOG DESTINATION Starting restore at 06-MAR-24 channel c1: starting archived log restore to user-specified destination archived log destination=/oradata/arch/ channel c1: restoring archived log archived log thread=1 sequence=36171 channel c1: restoring archived log archived log thread=1 sequence=36172 channel c1: restoring archived log archived log thread=1 sequence=36173 channel c1: restoring archived log archived log thread=1 sequence=36174 channel c1: restoring archived log archived log thread=1 sequence=36175 channel c1: restoring archived log archived log thread=1 sequence=36176 channel c1: restoring archived log archived log thread=1 sequence=36177 channel c1: restoring archived log archived log thread=1 sequence=36178 channel c1: restoring archived log archived log thread=1 sequence=36179 channel c1: restoring archived log archived log thread=1 sequence=36180 channel c1: reading from backup piece /databak/dadb/dadb_arc_1162890092_21506 channel c2: starting archived log restore to user-specified destination archived log destination=/oradata/arch/ channel c2: restoring archived log archived log thread=1 sequence=36181 channel c2: restoring archived log archived log thread=1 sequence=36182 channel c2: restoring archived log archived log thread=1 sequence=36183 channel c2: restoring archived log archived log thread=1 sequence=36184 channel c2: restoring archived log archived log thread=1 sequence=36185 channel c2: restoring archived log archived log thread=1 sequence=36186 channel c2: restoring archived log archived log thread=1 sequence=36187 channel c2: restoring archived log archived log thread=1 sequence=36188 channel c2: restoring archived log archived log thread=1 sequence=36189 channel c2: restoring archived log archived log thread=1 sequence=36190 channel c2: restoring archived log archived log thread=1 sequence=36191 channel c2: reading from backup piece /databak/dadb/dadb_arc_1162890092_21507 channel c2: piece handle=/databak/dadb/dadb_arc_1162890092_21507 tag=DA_ARC_BAK channel c2: restored backup piece 1 channel c2: restore complete, elapsed time: 00:00:15 channel c2: starting archived log restore to user-specified destination archived log destination=/oradata/arch/ channel c2: restoring archived log archived log thread=1 sequence=36192 channel c2: reading from backup piece /databak/dadb/dadb_arc_1162890107_21508 channel c1: piece handle=/databak/dadb/dadb_arc_1162890092_21506 tag=DA_ARC_BAK channel c1: restored backup piece 1 channel c1: restore complete, elapsed time: 00:00:16 channel c2: piece handle=/databak/dadb/dadb_arc_1162890107_21508 tag=DA_ARC_BAK channel c2: restored backup piece 1 channel c2: restore complete, elapsed time: 00:00:01 Finished restore at 06-MAR-24 Starting restore at 06-MAR-24 channel c1: starting archived log restore to user-specified destination archived log destination=/oradata/arch/ channel c1: restoring archived log archived log thread=2 sequence=27786 channel c1: restoring archived log archived log thread=2 sequence=27787 channel c1: restoring archived log archived log thread=2 sequence=27788 channel c1: restoring archived log archived log thread=2 sequence=27789 channel c1: restoring archived log archived log thread=2 sequence=27790 channel c1: restoring archived log archived log thread=2 sequence=27791 channel c1: reading from backup piece /databak/dadb/dadb_arc_1162890092_21506 channel c2: starting archived log restore to user-specified destination archived log destination=/oradata/arch/ channel c2: restoring archived log archived log thread=2 sequence=27792 channel c2: restoring archived log archived log thread=2 sequence=27793 channel c2: restoring archived log archived log thread=2 sequence=27794 channel c2: restoring archived log archived log thread=2 sequence=27795 channel c2: restoring archived log archived log thread=2 sequence=27796 channel c2: restoring archived log archived log thread=2 sequence=27797 channel c2: restoring archived log archived log thread=2 sequence=27798 channel c2: reading from backup piece /databak/dadb/dadb_arc_1162890092_21507 channel c2: piece handle=/databak/dadb/dadb_arc_1162890092_21507 tag=DA_ARC_BAK channel c2: restored backup piece 1 channel c2: restore complete, elapsed time: 00:00:07 channel c2: starting archived log restore to user-specified destination archived log destination=/oradata/arch/ channel c2: restoring archived log archived log thread=2 sequence=27799 channel c2: reading from backup piece /databak/dadb/dadb_arc_1162890107_21508 channel c1: piece handle=/databak/dadb/dadb_arc_1162890092_21506 tag=DA_ARC_BAK channel c1: restored backup piece 1 channel c1: restore complete, elapsed time: 00:00:09 channel c2: piece handle=/databak/dadb/dadb_arc_1162890107_21508 tag=DA_ARC_BAK channel c2: restored backup piece 1 channel c2: restore complete, elapsed time: 00:00:01 Finished restore at 06-MAR-24 released channel: c1 released channel: c213.执行恢复操作
RMAN> recover database; Starting recover at 06-MAR-24 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=1700 device type=DISK starting media recovery archived log for thread 1 with sequence 36191 is already on disk as file /oradata/arch/1_36191_939387772.arch archived log for thread 1 with sequence 36192 is already on disk as file /oradata/arch/1_36192_939387772.arch archived log for thread 2 with sequence 27798 is already on disk as file /oradata/arch/2_27798_939387772.arch archived log for thread 2 with sequence 27799 is already on disk as file /oradata/arch/2_27799_939387772.arch archived log file name=/oradata/arch/1_36191_939387772.arch thread=1 sequence=36191 archived log file name=/oradata/arch/2_27798_939387772.arch thread=2 sequence=27798 archived log file name=/oradata/arch/2_27799_939387772.arch thread=2 sequence=27799 archived log file name=/oradata/arch/1_36192_939387772.arch thread=1 sequence=36192 unable to find archived log archived log thread=1 sequence=36193 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 03/06/2024 12:21:52 RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 36193 and starting SCN of 18518339722150上面提示需要日志序号为36193的归档日志文件，因为我的备份只备到日志序号为36192的归档日志。
RMAN> list backup; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 21345 Full 85.42M DISK 00:00:00 06-MAR-24 BP Key: 21346 Status: AVAILABLE Compressed: NO Tag: DA_CONTROL_BAK Piece Name: /databak/dadb/dadb_cntrl_21509_1_21509 Control File Included: Ckp SCN: 18518339722264 Ckp time: 06-MAR-24 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 21346 Full 5.66G DISK 00:00:00 06-MAR-24 BP Key: 21347 Status: AVAILABLE Compressed: YES Tag: DA_FULL_BAK Piece Name: /databak/dadb/dadb_DADB_20240306_vu2l0hog_1_1 List of Datafiles in backup set 21346 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 2 Full 18518339718516 06-MAR-24 /oradata/dadb/sysaux01.dbf 4 Full 18518339718516 06-MAR-24 /oradata/dadb/users.dbf 6 Full 18518339718516 06-MAR-24 /oradata/dadb/hygeia.dbf 7 Full 18518339718516 06-MAR-24 /oradata/dadb/system001.dbf 10 Full 18518339718516 06-MAR-24 /oradata/dadb/test.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 21347 Full 5.20M DISK 00:00:00 06-MAR-24 BP Key: 21348 Status: AVAILABLE Compressed: YES Tag: DA_FULL_BAK Piece Name: /databak/dadb/dadb_DADB_20240306_002l0ijr_1_1 Control File Included: Ckp SCN: 18518339720451 Ckp time: 06-MAR-24 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 21348 970.06M DISK 00:00:00 06-MAR-24 BP Key: 21349 Status: AVAILABLE Compressed: NO Tag: DA_ARC_BAK Piece Name: /databak/dadb/dadb_arc_1162890092_21506 List of Archived Logs in backup set 21348 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 36171 18518338674292 02-MAR-24 18518338689793 02-MAR-24 1 36172 18518338689793 02-MAR-24 18518338799839 03-MAR-24 1 36173 18518338799839 03-MAR-24 18518338813263 03-MAR-24 1 36174 18518338813263 03-MAR-24 18518338884449 03-MAR-24 1 36175 18518338884449 03-MAR-24 18518338974024 03-MAR-24 1 36176 18518338974024 03-MAR-24 18518338974039 03-MAR-24 1 36177 18518338974039 03-MAR-24 18518338993139 03-MAR-24 1 36178 18518338993139 03-MAR-24 18518339079673 04-MAR-24 1 36179 18518339079673 04-MAR-24 18518339088612 04-MAR-24 1 36180 18518339088612 04-MAR-24 18518339193641 04-MAR-24 2 27786 18518338674296 02-MAR-24 18518338813706 03-MAR-24 2 27787 18518338813706 03-MAR-24 18518338929221 03-MAR-24 2 27788 18518338929221 03-MAR-24 18518338974028 03-MAR-24 2 27789 18518338974028 03-MAR-24 18518338974042 03-MAR-24 2 27790 18518338974042 03-MAR-24 18518339090540 04-MAR-24 2 27791 18518339090540 04-MAR-24 18518339290871 04-MAR-24 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 21349 Full 80.00K DISK 00:00:00 06-MAR-24 BP Key: 21350 Status: AVAILABLE Compressed: YES Tag: DA_FULL_BAK Piece Name: /databak/dadb/dadb_DADB_20240306_012l0ijv_1_1 SPFILE Included: Modification time: 05-MAR-24 SPFILE db_unique_name: DADBP BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 21350 854.23M DISK 00:00:00 06-MAR-24 BP Key: 21351 Status: AVAILABLE Compressed: NO Tag: DA_ARC_BAK Piece Name: /databak/dadb/dadb_arc_1162890092_21507 List of Archived Logs in backup set 21350 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 36181 18518339193641 04-MAR-24 18518339290866 04-MAR-24 1 36182 18518339290866 04-MAR-24 18518339290887 04-MAR-24 1 36183 18518339290887 04-MAR-24 18518339307311 04-MAR-24 1 36184 18518339307311 04-MAR-24 18518339398770 05-MAR-24 1 36185 18518339398770 05-MAR-24 18518339409567 05-MAR-24 1 36186 18518339409567 05-MAR-24 18518339534019 05-MAR-24 1 36187 18518339534019 05-MAR-24 18518339592978 05-MAR-24 1 36188 18518339592978 05-MAR-24 18518339593000 05-MAR-24 1 36189 18518339593000 05-MAR-24 18518339609217 05-MAR-24 1 36190 18518339609217 05-MAR-24 18518339708119 06-MAR-24 1 36191 18518339708119 06-MAR-24 18518339722138 06-MAR-24 2 27792 18518339290871 04-MAR-24 18518339290882 04-MAR-24 2 27793 18518339290882 04-MAR-24 18518339398968 05-MAR-24 2 27794 18518339398968 05-MAR-24 18518339548475 05-MAR-24 2 27795 18518339548475 05-MAR-24 18518339592982 05-MAR-24 2 27796 18518339592982 05-MAR-24 18518339592995 05-MAR-24 2 27797 18518339592995 05-MAR-24 18518339709370 06-MAR-24 2 27798 18518339709370 06-MAR-24 18518339722134 06-MAR-24 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 21351 19.50K DISK 00:00:00 06-MAR-24 BP Key: 21352 Status: AVAILABLE Compressed: NO Tag: DA_ARC_BAK Piece Name: /databak/dadb/dadb_arc_1162890107_21508 List of Archived Logs in backup set 21351 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 36192 18518339722138 06-MAR-24 18518339722150 06-MAR-24 2 27799 18518339722134 06-MAR-24 18518339722196 06-MAR-24 BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 21352 Full 4.52G DISK 00:00:00 06-MAR-24 BP Key: 21353 Status: AVAILABLE Compressed: YES Tag: DA_FULL_BAK Piece Name: /databak/dadb/dadb_DADB_20240306_vv2l0hog_1_1 List of Datafiles in backup set 21352 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 18518339718518 06-MAR-24 /oradata/dadb/system.dbf 3 Full 18518339718518 06-MAR-24 /oradata/dadb/undotbs1.dbf 5 Full 18518339718518 06-MAR-24 /oradata/dadb/undotbs2.dbf 8 Full 18518339718518 06-MAR-24 /oradata/dadb/sysaux.dbf 9 Full 18518339718518 06-MAR-24 /oradata/dadb/cs01.dbf执行按时间点或scn号的恢复操作。因为日志序号为36193的归档日志文件的scn号是从18518339722150开始，所以我们可以执行恢复到scn号=18518339722150为止。
RMAN> recover database until scn 18518339722150; Starting recover at 06-MAR-24 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:01 Finished recover at 06-MAR-2414.打开数据库。
RMAN> alter database open resetlogs; database opened [oracle@sjjh oradata]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Mar 6 12:25:01 2024 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ dadb OPEN