--检查源端版本
SYS@ORCLCDB> select BANNER_FULL from v$version;
BANNER_FULL
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
--2.源端备份
[oracle@oracle19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Mar 11 17:58:24 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCLCDB (DBID=2814923791)
RMAN> run{
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> allocate channel c3 device type disk;
5> backup database filesperset 3 format '/home/oracle/db_%d_%T_%U';
6> backup archivelog all format '/home/oracle/arc_%t_%s';
7> backup current controlfile format '/home/oracle/cntrl_%s_%p_%s';
8> release channel c1;
9> release channel c2;
10> release channel c3;
11> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=853 device type=DISK
allocated channel: c2
channel c2: SID=877 device type=DISK
allocated channel: c3
channel c3: SID=874 device type=DISK
Starting backup at 2022-03-11 17:58:32
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/opt/oracle/oradata/ORCLCDB/system01.dbf
input datafile file number=00004 name=/opt/oracle/oradata/ORCLCDB/undotbs01.dbf
channel c1: starting piece 1 at 2022-03-11 17:58:33
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00003 name=/opt/oracle/oradata/ORCLCDB/sysaux01.dbf
input datafile file number=00007 name=/opt/oracle/oradata/ORCLCDB/users01.dbf
channel c2: starting piece 1 at 2022-03-11 17:58:33
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00010 name=/opt/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf
input datafile file number=00011 name=/opt/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf
channel c3: starting piece 1 at 2022-03-11 17:58:33
channel c1: finished piece 1 at 2022-03-11 17:58:40
piece handle=/home/oracle/db_ORCLCDB_20220311_0j0o5169_1_1 tag=TAG20220311T175833 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:07
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=/opt/oracle/oradata/ORCLCDB/pdbseed/sysaux01.dbf
channel c1: starting piece 1 at 2022-03-11 17:58:40
channel c2: finished piece 1 at 2022-03-11 17:58:40
piece handle=/home/oracle/db_ORCLCDB_20220311_0k0o5169_1_1 tag=TAG20220311T175833 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:07
channel c2: starting full datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00009 name=/opt/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf
input datafile file number=00012 name=/opt/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf
channel c2: starting piece 1 at 2022-03-11 17:58:40
channel c3: finished piece 1 at 2022-03-11 17:58:40
piece handle=/home/oracle/db_ORCLCDB_20220311_0l0o5169_1_1 tag=TAG20220311T175833 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:07
channel c3: starting full datafile backup set
channel c3: specifying datafile(s) in backup set
input datafile file number=00005 name=/opt/oracle/oradata/ORCLCDB/pdbseed/system01.dbf
channel c3: starting piece 1 at 2022-03-11 17:58:41
channel c1: finished piece 1 at 2022-03-11 17:58:44
piece handle=/home/oracle/db_ORCLCDB_20220311_0m0o516g_1_1 tag=TAG20220311T175833 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:04
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00008 name=/opt/oracle/oradata/ORCLCDB/pdbseed/undotbs01.dbf
channel c1: starting piece 1 at 2022-03-11 17:58:44
channel c2: finished piece 1 at 2022-03-11 17:58:44
piece handle=/home/oracle/db_ORCLCDB_20220311_0n0o516g_1_1 tag=TAG20220311T175833 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:04
channel c3: finished piece 1 at 2022-03-11 17:58:44
piece handle=/home/oracle/db_ORCLCDB_20220311_0o0o516h_1_1 tag=TAG20220311T175833 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:03
channel c1: finished piece 1 at 2022-03-11 17:58:45
piece handle=/home/oracle/db_ORCLCDB_20220311_0p0o516k_1_1 tag=TAG20220311T175833 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 2022-03-11 17:58:45
Starting backup at 2022-03-11 17:58:46
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=14 RECID=5 STAMP=1099072726
channel c1: starting piece 1 at 2022-03-11 17:58:47
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=3 STAMP=1049274683
channel c2: starting piece 1 at 2022-03-11 17:58:47
channel c3: starting archived log backup set
channel c3: specifying archived log(s) in backup set
input archived log thread=1 sequence=13 RECID=4 STAMP=1049274683
channel c3: starting piece 1 at 2022-03-11 17:58:47
channel c1: finished piece 1 at 2022-03-11 17:58:48
piece handle=/home/oracle/arc_1099072727_26 tag=TAG20220311T175846 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
channel c2: finished piece 1 at 2022-03-11 17:58:48
piece handle=/home/oracle/arc_1099072727_27 tag=TAG20220311T175846 comment=NONE
channel c2: backup set complete, elapsed time: 00:00:01
channel c3: finished piece 1 at 2022-03-11 17:58:48
piece handle=/home/oracle/arc_1099072727_28 tag=TAG20220311T175846 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:01
Finished backup at 2022-03-11 17:58:48
Starting backup at 2022-03-11 17:58:48
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 2022-03-11 17:58:49
channel c1: finished piece 1 at 2022-03-11 17:58:50
piece handle=/home/oracle/cntrl_29_1_29 tag=TAG20220311T175848 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 2022-03-11 17:58:50
Starting Control File and SPFILE Autobackup at 2022-03-11 17:58:50
piece handle=/opt/oracle/flash_recovery_area/ORCLCDB/autobackup/2022_03_11/o1_mf_s_1099072730_k2p7btkz_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2022-03-11 17:58:51
released channel: c1
released channel: c2
released channel: c3
RMAN> exit
Recovery Manager complete.
[oracle@oracle19c ~]$ ll
total 2386140
-rw-r----- 1 oracle oinstall 8196608 Mar 11 17:58 arc_1099072727_26
-rw-r----- 1 oracle oinstall 8192 Mar 11 17:58 arc_1099072727_27
-rw-r----- 1 oracle oinstall 4096 Mar 11 17:58 arc_1099072727_28
-rw-r----- 1 oracle oinstall 18808832 Mar 11 17:58 cntrl_29_1_29
-rw-r----- 1 oracle oinstall 827875328 Mar 11 17:58 db_ORCLCDB_20220311_0j0o5169_1_1
-rw-r----- 1 oracle oinstall 496746496 Mar 11 17:58 db_ORCLCDB_20220311_0k0o5169_1_1
-rw-r----- 1 oracle oinstall 272039936 Mar 11 17:58 db_ORCLCDB_20220311_0l0o5169_1_1
-rw-r----- 1 oracle oinstall 263225344 Mar 11 17:58 db_ORCLCDB_20220311_0m0o516g_1_1
-rw-r----- 1 oracle oinstall 238166016 Mar 11 17:58 db_ORCLCDB_20220311_0n0o516g_1_1
-rw-r----- 1 oracle oinstall 228524032 Mar 11 17:58 db_ORCLCDB_20220311_0o0o516h_1_1
-rw-r----- 1 oracle oinstall 89808896 Mar 11 17:58 db_ORCLCDB_20220311_0p0o516k_1_1
-3.将备份拷贝至目标端
[oracle@oracle19c ~]$ scp * oracle@172.17.0.2:/home/oracle/
The authenticity of host '172.17.0.2 (172.17.0.2)' can't be established.
ECDSA key fingerprint is SHA256:wewKfumj4gUhgs3YB/5N2EEjG36yv7TL2fpyphQ3udQ.
ECDSA key fingerprint is MD5:f0:5d:27:86:93:8f:72:6c:7e:4f:a5:0e:40:58:23:be.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.17.0.2' (ECDSA) to the list of known hosts.
oracle@172.17.0.2's password:
arc_1099072727_26 100% 8005KB 69.8MB/s 00:00
arc_1099072727_27 100% 8192 4.3MB/s 00:00
arc_1099072727_28 100% 4096 3.7MB/s 00:00
cntrl_29_1_29 100% 18MB 76.7MB/s 00:00
db_ORCLCDB_20220311_0j0o5169_1_1 100% 790MB 61.1MB/s 00:12
db_ORCLCDB_20220311_0k0o5169_1_1 100% 474MB 67.7MB/s 00:07
db_ORCLCDB_20220311_0l0o5169_1_1 100% 259MB 65.1MB/s 00:03
db_ORCLCDB_20220311_0m0o516g_1_1 100% 251MB 72.5MB/s 00:03
db_ORCLCDB_20220311_0n0o516g_1_1 100% 227MB 68.7MB/s 00:03
db_ORCLCDB_20220311_0o0o516h_1_1 100% 218MB 68.1MB/s 00:03
db_ORCLCDB_20220311_0p0o516k_1_1 100% 86MB 66.3MB/s 00:01
-----------------------------------------------------------------------------------------------------
--4. 目标端恢复
[oracle@ora19c dbs]$ strings spfileORCLCDB.ora
*.audit_file_dest='/opt/oracle/admin/ORCLCDB/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='/opt/oracle/oradata/ORCLCDB/control01.ctl','/opt/oracle/oradata/ORCLCDB/control02.ctl'
*.db_block_size=8192
*.db_name='ORCLCDB'
*.db_recovery_file_dest_size=4294967296
*.db_recovery_file_dest='/opt/oracle/flash_recovery_area'
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLCDBXDB)'
*.enable_pluggable_database=true
*.local_listener='LISTENER_ORCLCDB'
*.nls_la
nguage='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=100m
*.processes=640
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1024m
*.undo_tablespace='UNDOTBS1'
[oracle@ora19c dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Mar 11 18:14:28 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to an idle instance.
SYS@ORCLCDB> startup nomount
ORACLE instance started.
Total System Global Area 1073739160 bytes
Fixed Size 9143704 bytes
Variable Size 381681664 bytes
Database Buffers 679477248 bytes
Redo Buffers 3436544 bytes
SYS@ORCLCDB> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
[oracle@ora19c dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Mar 11 18:16:02 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCLCDB (not mounted)
RMAN> restore controlfile from '/home/oracle/cntrl_29_1_29';
Starting restore at 2022-03-11 18:16:06
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=815 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/opt/oracle/oradata/ORCLCDB/control01.ctl
output file name=/opt/oracle/oradata/ORCLCDB/control02.ctl
Finished restore at 2022-03-11 18:16:08
RMAN> alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> restore database;
Starting restore at 2022-03-11 18:16:26
Starting implicit crosscheck backup at 2022-03-11 18:16:26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=815 device type=DISK
Crosschecked 17 objects
Finished implicit crosscheck backup at 2022-03-11 18:16:31
Starting implicit crosscheck copy at 2022-03-11 18:16:31
using channel ORA_DISK_1
Finished implicit crosscheck copy at 2022-03-11 18:16:32
searching for all files in the recovery area
cataloging files...
no files cataloged
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 00010 to /opt/oracle/oradata/ORCLCDB/ORCLPDB1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /opt/oracle/oradata/ORCLCDB/ORCLPDB1/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_ORCLCDB_20220311_0l0o5169_1_1
channel ORA_DISK_1: piece handle=/home/oracle/db_ORCLCDB_20220311_0l0o5169_1_1 tag=TAG20220311T175833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 /opt/oracle/oradata/ORCLCDB/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /opt/oracle/oradata/ORCLCDB/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_ORCLCDB_20220311_0k0o5169_1_1
channel ORA_DISK_1: piece handle=/home/oracle/db_ORCLCDB_20220311_0k0o5169_1_1 tag=TAG20220311T175833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 /opt/oracle/oradata/ORCLCDB/system01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /opt/oracle/oradata/ORCLCDB/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_ORCLCDB_20220311_0j0o5169_1_1
channel ORA_DISK_1: piece handle=/home/oracle/db_ORCLCDB_20220311_0j0o5169_1_1 tag=TAG20220311T175833
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 00005 to /opt/oracle/oradata/ORCLCDB/pdbseed/system01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_ORCLCDB_20220311_0o0o516h_1_1
channel ORA_DISK_1: piece handle=/home/oracle/db_ORCLCDB_20220311_0o0o516h_1_1 tag=TAG20220311T175833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 /opt/oracle/oradata/ORCLCDB/pdbseed/sysaux01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_ORCLCDB_20220311_0m0o516g_1_1
channel ORA_DISK_1: piece handle=/home/oracle/db_ORCLCDB_20220311_0m0o516g_1_1 tag=TAG20220311T175833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00009 to /opt/oracle/oradata/ORCLCDB/ORCLPDB1/system01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /opt/oracle/oradata/ORCLCDB/ORCLPDB1/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_ORCLCDB_20220311_0n0o516g_1_1
channel ORA_DISK_1: piece handle=/home/oracle/db_ORCLCDB_20220311_0n0o516g_1_1 tag=TAG20220311T175833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
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 00008 to /opt/oracle/oradata/ORCLCDB/pdbseed/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/db_ORCLCDB_20220311_0p0o516k_1_1
channel ORA_DISK_1: piece handle=/home/oracle/db_ORCLCDB_20220311_0p0o516k_1_1 tag=TAG20220311T175833
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 2022-03-11 18:16:57
RMAN> recover database;
Starting recover at 2022-03-11 18:17:17
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=14
channel ORA_DISK_1: reading from backup piece /home/oracle/arc_1099072727_26
channel ORA_DISK_1: piece handle=/home/oracle/arc_1099072727_26 tag=TAG20220311T175846
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/opt/oracle/flash_recovery_area/ORCLCDB/archivelog/2022_03_11/o1_mf_1_14_k2p8fg1p_.arc thread=1 sequence=14
channel default: deleting archived log(s)
archived log file name=/opt/oracle/flash_recovery_area/ORCLCDB/archivelog/2022_03_11/o1_mf_1_14_k2p8fg1p_.arc RECID=6 STAMP=1099073838
unable to find archived log
archived log thread=1 sequence=15
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/11/2022 18:17:19
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 15 and starting SCN of 2553293
--open resetlogs提示我们当前的SYS.DBMS_BACKUP_RESTORE以及SYS.DBMS_RCVMAN的版本信息是19.03，在当前数据库环境下并不是最新的。
--但是也成功执行完成，并且cdb、pdb状态正常
RMAN> alter database open resetlogs;
Statement processed
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 in TARGET database is not current
SYS@ORCLCDB> select open_mode from v$database;
OPEN_MODE
----------------------------------------
READ WRITE
SYS@ORCLCDB> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
SYS@ORCLCDB> select BANNER_FULL from v$version;
BANNER_FULL
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
[oracle@ora19c dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Mar 11 18:21:04 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.03.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 19.03.00.00 in TARGET database is not current
connected to target database: ORCLCDB (DBID=2814923791)
RMAN> exit
--5.解决办法，更新SYS.DBMS_BACKUP_RESTORE以及SYS.DBMS_RCVMAN
@$ORACLE_HOME/rdbms/admin/dbmsrman.sql
@$ORACLE_HOME/rdbms/admin/prvtrmns.plb
@$ORACLE_HOME/rdbms/admin/dbmsbkrs.sql
@$ORACLE_HOME/rdbms/admin/prvtbkrs.plb
--再次执行rman 正常
[oracle@ora19c dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Fri Mar 11 18:27:08 2022
Version 19.13.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCLCDB (DBID=2814923791)
RMAN>
