Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038
Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038故障
網路服務名配置如下(csdbs為主庫，csdb為備庫):
csdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.10.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = csdb) ) ) csdbs = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.10.108)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.10.109)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = csdb)(UR=A) ) )
執行復制命令:
[oracle@dbst1 ~]$ rman target sys/abcd1234@csdbs auxiliary sys/abcd1234@csdb
Recovery Manager: Release 11.2.0.4.0 - Production on Sun Sep 18 22:06:27 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: csdb (DBID=4138492706)
connected to auxiliary database: csdb (not mounted)
RMAN> duplicate target database for standby from active database nofilenamecheck;
Starting Duplicate Db at 18-SEP-22
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1700 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0.4/db/dbs/orapwcsdb1' auxiliary format
'/u01/app/oracle/product/11.2.0.4/db/dbs/orapwcsdb' ;
}
executing Memory Script
Starting backup at 18-SEP-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4121 instance=csdb1 device type=DISK
Finished backup at 18-SEP-22
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/csdb/control01.ctl';
restore clone controlfile to '/u01/app/oracle/oradata/csdb/control02.ctl' from
'/u01/app/oracle/oradata/csdb/control01.ctl';
}
executing Memory Script
Starting backup at 18-SEP-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0.4/db/dbs/snapcf_csdb1.f tag=TAG20220918T220701 RECID=182 STAMP=1115762822
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 18-SEP-22
Starting restore at 18-SEP-22
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 18-SEP-22
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/csdb/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/csdb/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/csdb/sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/csdb/undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/csdb/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/csdb/example01.dbf";
set newname for datafile 8 to
"/u01/app/oracle/oradata/csdb/swpt01";
set newname for datafile 11 to
"/u01/app/oracle/oradata/csdb/users02.dbf";
set newname for datafile 12 to
"/u01/app/oracle/oradata/csdb/users03.dbf";
set newname for datafile 13 to
"/u01/app/oracle/oradata/csdb/users04.dbf";
set newname for datafile 14 to
"/u01/app/oracle/oradata/csdb/users05.dbf";
set newname for datafile 15 to
"/u01/app/oracle/oradata/csdb/users06.dbf";
set newname for datafile 16 to
"/u01/app/oracle/oradata/csdb/users07.dbf";
set newname for datafile 17 to
"/u01/app/oracle/oradata/csdb/users08.dbf";
set newname for datafile 18 to
"/u01/app/oracle/oradata/csdb/users09.dbf";
set newname for datafile 19 to
"/u01/app/oracle/oradata/csdb/users10.dbf";
set newname for datafile 20 to
"/u01/app/oracle/oradata/csdb/users11.dbf";
set newname for datafile 21 to
"/u01/app/oracle/oradata/csdb/users12.dbf";
set newname for datafile 22 to
"/u01/app/oracle/oradata/csdb/users13.dbf";
set newname for datafile 23 to
"/u01/app/oracle/oradata/csdb/users14.dbf";
set newname for datafile 25 to
"/u01/app/oracle/oradata/csdb/users16.dbf";
set newname for datafile 26 to
"/u01/app/oracle/oradata/csdb/users17.dbf";
set newname for datafile 27 to
"/u01/app/oracle/oradata/csdb/users15.dbf";
set newname for datafile 28 to
"/u01/app/oracle/oradata/csdb/users18.dbf";
set newname for datafile 29 to
"/u01/app/oracle/oradata/csdb/users19.dbf";
set newname for datafile 30 to
"/u01/app/oracle/oradata/csdb/users20.dbf";
set newname for datafile 31 to
"/u01/app/oracle/oradata/csdb/users21.dbf";
set newname for datafile 32 to
"/u01/app/oracle/oradata/csdb/users22.dbf";
set newname for datafile 33 to
"/u01/app/oracle/oradata/csdb/users23.dbf";
set newname for datafile 34 to
"/u01/app/oracle/oradata/csdb/users24.dbf";
set newname for datafile 35 to
"/u01/app/oracle/oradata/csdb/users25.dbf";
set newname for datafile 36 to
"/u01/app/oracle/oradata/csdb/users26.dbf";
set newname for datafile 37 to
"/u01/app/oracle/oradata/csdb/users27.dbf";
set newname for datafile 38 to
"/u01/app/oracle/oradata/csdb/users28.dbf";
set newname for datafile 39 to
"/u01/app/oracle/oradata/csdb/users29.dbf";
set newname for datafile 40 to
"/u01/app/oracle/oradata/csdb/users30.dbf";
set newname for datafile 41 to
"/u01/app/oracle/oradata/csdb/undotbs02.dbf";
set newname for datafile 42 to
"/u01/app/oracle/oradata/csdb/undotbs03.dbf";
set newname for datafile 49 to
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.262.1109177757";
set newname for datafile 50 to
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.263.1109178111";
set newname for datafile 51 to
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.264.1109178457";
set newname for datafile 52 to
"/u01/app/oracle/oradata/csdb/datafile/users.284.1109186395";
set newname for datafile 53 to
"/u01/app/oracle/oradata/csdb/datafile/users.285.1109186791";
set newname for datafile 54 to
"/u01/app/oracle/oradata/csdb/datafile/users.286.1109187157";
set newname for datafile 55 to
"/u01/app/oracle/oradata/csdb/datafile/users.287.1109187493";
set newname for datafile 56 to
"/u01/app/oracle/oradata/csdb/users31.dbf";
set newname for datafile 57 to
"/u01/app/oracle/oradata/csdb/users32.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/csdb/system01.dbf" datafile
2 auxiliary format
"/u01/app/oracle/oradata/csdb/sysaux01.dbf" datafile
3 auxiliary format
"/u01/app/oracle/oradata/csdb/undotbs01.dbf" datafile
4 auxiliary format
"/u01/app/oracle/oradata/csdb/users01.dbf" datafile
5 auxiliary format
"/u01/app/oracle/oradata/csdb/example01.dbf" datafile
8 auxiliary format
"/u01/app/oracle/oradata/csdb/swpt01" datafile
11 auxiliary format
"/u01/app/oracle/oradata/csdb/users02.dbf" datafile
12 auxiliary format
"/u01/app/oracle/oradata/csdb/users03.dbf" datafile
13 auxiliary format
"/u01/app/oracle/oradata/csdb/users04.dbf" datafile
14 auxiliary format
"/u01/app/oracle/oradata/csdb/users05.dbf" datafile
15 auxiliary format
"/u01/app/oracle/oradata/csdb/users06.dbf" datafile
16 auxiliary format
"/u01/app/oracle/oradata/csdb/users07.dbf" datafile
17 auxiliary format
"/u01/app/oracle/oradata/csdb/users08.dbf" datafile
18 auxiliary format
"/u01/app/oracle/oradata/csdb/users09.dbf" datafile
19 auxiliary format
"/u01/app/oracle/oradata/csdb/users10.dbf" datafile
20 auxiliary format
"/u01/app/oracle/oradata/csdb/users11.dbf" datafile
21 auxiliary format
"/u01/app/oracle/oradata/csdb/users12.dbf" datafile
22 auxiliary format
"/u01/app/oracle/oradata/csdb/users13.dbf" datafile
23 auxiliary format
"/u01/app/oracle/oradata/csdb/users14.dbf" datafile
25 auxiliary format
"/u01/app/oracle/oradata/csdb/users16.dbf" datafile
26 auxiliary format
"/u01/app/oracle/oradata/csdb/users17.dbf" datafile
27 auxiliary format
"/u01/app/oracle/oradata/csdb/users15.dbf" datafile
28 auxiliary format
"/u01/app/oracle/oradata/csdb/users18.dbf" datafile
29 auxiliary format
"/u01/app/oracle/oradata/csdb/users19.dbf" datafile
30 auxiliary format
"/u01/app/oracle/oradata/csdb/users20.dbf" datafile
31 auxiliary format
"/u01/app/oracle/oradata/csdb/users21.dbf" datafile
32 auxiliary format
"/u01/app/oracle/oradata/csdb/users22.dbf" datafile
33 auxiliary format
"/u01/app/oracle/oradata/csdb/users23.dbf" datafile
34 auxiliary format
"/u01/app/oracle/oradata/csdb/users24.dbf" datafile
35 auxiliary format
"/u01/app/oracle/oradata/csdb/users25.dbf" datafile
36 auxiliary format
"/u01/app/oracle/oradata/csdb/users26.dbf" datafile
37 auxiliary format
"/u01/app/oracle/oradata/csdb/users27.dbf" datafile
38 auxiliary format
"/u01/app/oracle/oradata/csdb/users28.dbf" datafile
39 auxiliary format
"/u01/app/oracle/oradata/csdb/users29.dbf" datafile
40 auxiliary format
"/u01/app/oracle/oradata/csdb/users30.dbf" datafile
41 auxiliary format
"/u01/app/oracle/oradata/csdb/undotbs02.dbf" datafile
42 auxiliary format
"/u01/app/oracle/oradata/csdb/undotbs03.dbf" datafile
49 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.262.1109177757" datafile
50 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.263.1109178111" datafile
51 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.264.1109178457" datafile
52 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.284.1109186395" datafile
53 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.285.1109186791" datafile
54 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.286.1109187157" datafile
55 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.287.1109187493" datafile
56 auxiliary format
"/u01/app/oracle/oradata/csdb/users31.dbf" datafile
57 auxiliary format
"/u01/app/oracle/oradata/csdb/users32.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/csdb/temp01.dbf in control file
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
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
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
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 backup at 18-SEP-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+JHK/csdbs/system01.dbf
output file name=/u01/app/oracle/oradata/csdb/system01.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+JHK/csdbs/sysaux01.dbf
output file name=/u01/app/oracle/oradata/csdb/sysaux01.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+JHK/csdbs/undotbs01.dbf
output file name=/u01/app/oracle/oradata/csdb/undotbs01.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00049 name=+JHK/csdbs/datafile/undotbs2.262.1109177757
output file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.262.1109177757 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:06:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00050 name=+JHK/csdbs/datafile/undotbs2.263.1109178111
output file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.263.1109178111 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00051 name=+JHK/csdbs/datafile/undotbs2.264.1109178457
output file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.264.1109178457 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00025 name=+JHK/csdbs/users16.dbf
output file name=/u01/app/oracle/oradata/csdb/users16.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00026 name=+JHK/csdbs/users17.dbf
output file name=/u01/app/oracle/oradata/csdb/users17.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00027 name=+JHK/csdbs/users15.dbf
output file name=/u01/app/oracle/oradata/csdb/users15.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00028 name=+JHK/csdbs/users18.dbf
output file name=/u01/app/oracle/oradata/csdb/users18.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00029 name=+JHK/csdbs/users19.dbf
output file name=/u01/app/oracle/oradata/csdb/users19.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00030 name=+JHK/csdbs/users20.dbf
output file name=/u01/app/oracle/oradata/csdb/users20.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00031 name=+JHK/csdbs/users21.dbf
output file name=/u01/app/oracle/oradata/csdb/users21.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00032 name=+JHK/csdbs/users22.dbf
output file name=/u01/app/oracle/oradata/csdb/users22.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00033 name=+JHK/csdbs/users23.dbf
output file name=/u01/app/oracle/oradata/csdb/users23.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00034 name=+JHK/csdbs/users24.dbf
output file name=/u01/app/oracle/oradata/csdb/users24.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00035 name=+JHK/csdbs/users25.dbf
output file name=/u01/app/oracle/oradata/csdb/users25.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00036 name=+JHK/csdbs/users26.dbf
output file name=/u01/app/oracle/oradata/csdb/users26.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00037 name=+JHK/csdbs/users27.dbf
output file name=/u01/app/oracle/oradata/csdb/users27.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00038 name=+JHK/csdbs/users28.dbf
output file name=/u01/app/oracle/oradata/csdb/users28.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00039 name=+JHK/csdbs/users29.dbf
output file name=/u01/app/oracle/oradata/csdb/users29.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00040 name=+JHK/csdbs/users30.dbf
output file name=/u01/app/oracle/oradata/csdb/users30.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00041 name=+JHK/csdbs/undotbs02.dbf
output file name=/u01/app/oracle/oradata/csdb/undotbs02.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00042 name=+JHK/csdbs/undotbs03.dbf
output file name=/u01/app/oracle/oradata/csdb/undotbs03.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00052 name=+JHK/csdbs/datafile/users.284.1109186395
output file name=/u01/app/oracle/oradata/csdb/datafile/users.284.1109186395 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00053 name=+JHK/csdbs/datafile/users.285.1109186791
output file name=/u01/app/oracle/oradata/csdb/datafile/users.285.1109186791 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00054 name=+JHK/csdbs/datafile/users.286.1109187157
output file name=/u01/app/oracle/oradata/csdb/datafile/users.286.1109187157 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00055 name=+JHK/csdbs/datafile/users.287.1109187493
output file name=/u01/app/oracle/oradata/csdb/datafile/users.287.1109187493 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00056 name=+JHK/csdbs/users31.dbf
output file name=/u01/app/oracle/oradata/csdb/users31.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00057 name=+JHK/csdbs/users32.dbf
output file name=/u01/app/oracle/oradata/csdb/users32.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+JHK/csdbs/users01.dbf
output file name=/u01/app/oracle/oradata/csdb/users01.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=+JHK/csdbs/users02.dbf
output file name=/u01/app/oracle/oradata/csdb/users02.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=+JHK/csdbs/users03.dbf
output file name=/u01/app/oracle/oradata/csdb/users03.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=+JHK/csdbs/users04.dbf
output file name=/u01/app/oracle/oradata/csdb/users04.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00014 name=+JHK/csdbs/users05.dbf
output file name=/u01/app/oracle/oradata/csdb/users05.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00023 name=+JHK/csdbs/users14.dbf
output file name=/u01/app/oracle/oradata/csdb/users14.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00019 name=+JHK/csdbs/users10.dbf
output file name=/u01/app/oracle/oradata/csdb/users10.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00020 name=+JHK/csdbs/users11.dbf
output file name=/u01/app/oracle/oradata/csdb/users11.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00021 name=+JHK/csdbs/users12.dbf
output file name=/u01/app/oracle/oradata/csdb/users12.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00022 name=+JHK/csdbs/users13.dbf
output file name=/u01/app/oracle/oradata/csdb/users13.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00015 name=+JHK/csdbs/users06.dbf
output file name=/u01/app/oracle/oradata/csdb/users06.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00016 name=+JHK/csdbs/users07.dbf
output file name=/u01/app/oracle/oradata/csdb/users07.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00018 name=+JHK/csdbs/users09.dbf
output file name=/u01/app/oracle/oradata/csdb/users09.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00017 name=+JHK/csdbs/users08.dbf
output file name=/u01/app/oracle/oradata/csdb/users08.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=+JHK/csdbs/swpt01
output file name=/u01/app/oracle/oradata/csdb/swpt01 tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+JHK/csdbs/example01.dbf
output file name=/u01/app/oracle/oradata/csdb/example01.dbf tag=TAG20220918T220713
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 19-SEP-22
sql statement: alter system archive log current
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/19/2022 01:26:50
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on ORA_AUX_DISK_1 channel at 09/19/2022 01:26:50
RMAN-10038: database session for channel ORA_AUX_DISK_1 terminated unexpectedly
出現了通道異常終止的錯誤，根本原因是在執行rman命令時連線主庫配置的tns服務名不是指向單例項
修改網路服務名:
csdb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.10.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = csdb) ) ) csdbs = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.10.108)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = csdb)(UR=A) ) )
再次執行復制命令
[oracle@csdb admin]$ rman target sys/abcd1234@csdbs1 auxiliary sys/abcd1234@csdb
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Sep 19 12:45:00 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: csdb (DBID=4138492706)
connected to auxiliary database: csdb (not mounted)
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 19-SEP-22
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=1982 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0.4/db/dbs/orapwcsdb1' auxiliary format
'/u01/app/oracle/product/11.2.0.4/db/dbs/orapwcsdb' ;
}
executing Memory Script
Starting backup at 19-SEP-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3126 instance=csdb1 device type=DISK
Finished backup at 19-SEP-22
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/csdb/control01.ctl';
restore clone controlfile to '/u01/app/oracle/oradata/csdb/control02.ctl' from
'/u01/app/oracle/oradata/csdb/control01.ctl';
}
executing Memory Script
Starting backup at 19-SEP-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=+JHK/csdbs/snapcf_csdb1.f tag=TAG20220919T124512 RECID=185 STAMP=1115815514
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 19-SEP-22
Starting restore at 19-SEP-22
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 19-SEP-22
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/csdb/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/csdb/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/csdb/sysaux01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/csdb/undotbs01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/csdb/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/csdb/example01.dbf";
set newname for datafile 8 to
"/u01/app/oracle/oradata/csdb/swpt01";
set newname for datafile 11 to
"/u01/app/oracle/oradata/csdb/users02.dbf";
set newname for datafile 12 to
"/u01/app/oracle/oradata/csdb/users03.dbf";
set newname for datafile 13 to
"/u01/app/oracle/oradata/csdb/users04.dbf";
set newname for datafile 14 to
"/u01/app/oracle/oradata/csdb/users05.dbf";
set newname for datafile 15 to
"/u01/app/oracle/oradata/csdb/users06.dbf";
set newname for datafile 16 to
"/u01/app/oracle/oradata/csdb/users07.dbf";
set newname for datafile 17 to
"/u01/app/oracle/oradata/csdb/users08.dbf";
set newname for datafile 18 to
"/u01/app/oracle/oradata/csdb/users09.dbf";
set newname for datafile 19 to
"/u01/app/oracle/oradata/csdb/users10.dbf";
set newname for datafile 20 to
"/u01/app/oracle/oradata/csdb/users11.dbf";
set newname for datafile 21 to
"/u01/app/oracle/oradata/csdb/users12.dbf";
set newname for datafile 22 to
"/u01/app/oracle/oradata/csdb/users13.dbf";
set newname for datafile 23 to
"/u01/app/oracle/oradata/csdb/users14.dbf";
set newname for datafile 25 to
"/u01/app/oracle/oradata/csdb/users16.dbf";
set newname for datafile 26 to
"/u01/app/oracle/oradata/csdb/users17.dbf";
set newname for datafile 27 to
"/u01/app/oracle/oradata/csdb/users15.dbf";
set newname for datafile 28 to
"/u01/app/oracle/oradata/csdb/users18.dbf";
set newname for datafile 29 to
"/u01/app/oracle/oradata/csdb/users19.dbf";
set newname for datafile 30 to
"/u01/app/oracle/oradata/csdb/users20.dbf";
set newname for datafile 31 to
"/u01/app/oracle/oradata/csdb/users21.dbf";
set newname for datafile 32 to
"/u01/app/oracle/oradata/csdb/users22.dbf";
set newname for datafile 33 to
"/u01/app/oracle/oradata/csdb/users23.dbf";
set newname for datafile 34 to
"/u01/app/oracle/oradata/csdb/users24.dbf";
set newname for datafile 35 to
"/u01/app/oracle/oradata/csdb/users25.dbf";
set newname for datafile 36 to
"/u01/app/oracle/oradata/csdb/users26.dbf";
set newname for datafile 37 to
"/u01/app/oracle/oradata/csdb/users27.dbf";
set newname for datafile 38 to
"/u01/app/oracle/oradata/csdb/users28.dbf";
set newname for datafile 39 to
"/u01/app/oracle/oradata/csdb/users29.dbf";
set newname for datafile 40 to
"/u01/app/oracle/oradata/csdb/users30.dbf";
set newname for datafile 41 to
"/u01/app/oracle/oradata/csdb/undotbs02.dbf";
set newname for datafile 42 to
"/u01/app/oracle/oradata/csdb/undotbs03.dbf";
set newname for datafile 49 to
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.262.1109177757";
set newname for datafile 50 to
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.263.1109178111";
set newname for datafile 51 to
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.264.1109178457";
set newname for datafile 52 to
"/u01/app/oracle/oradata/csdb/datafile/users.284.1109186395";
set newname for datafile 53 to
"/u01/app/oracle/oradata/csdb/datafile/users.285.1109186791";
set newname for datafile 54 to
"/u01/app/oracle/oradata/csdb/datafile/users.286.1109187157";
set newname for datafile 55 to
"/u01/app/oracle/oradata/csdb/datafile/users.287.1109187493";
set newname for datafile 56 to
"/u01/app/oracle/oradata/csdb/users31.dbf";
set newname for datafile 57 to
"/u01/app/oracle/oradata/csdb/users32.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/app/oracle/oradata/csdb/system01.dbf" datafile
2 auxiliary format
"/u01/app/oracle/oradata/csdb/sysaux01.dbf" datafile
3 auxiliary format
"/u01/app/oracle/oradata/csdb/undotbs01.dbf" datafile
4 auxiliary format
"/u01/app/oracle/oradata/csdb/users01.dbf" datafile
5 auxiliary format
"/u01/app/oracle/oradata/csdb/example01.dbf" datafile
8 auxiliary format
"/u01/app/oracle/oradata/csdb/swpt01" datafile
11 auxiliary format
"/u01/app/oracle/oradata/csdb/users02.dbf" datafile
12 auxiliary format
"/u01/app/oracle/oradata/csdb/users03.dbf" datafile
13 auxiliary format
"/u01/app/oracle/oradata/csdb/users04.dbf" datafile
14 auxiliary format
"/u01/app/oracle/oradata/csdb/users05.dbf" datafile
15 auxiliary format
"/u01/app/oracle/oradata/csdb/users06.dbf" datafile
16 auxiliary format
"/u01/app/oracle/oradata/csdb/users07.dbf" datafile
17 auxiliary format
"/u01/app/oracle/oradata/csdb/users08.dbf" datafile
18 auxiliary format
"/u01/app/oracle/oradata/csdb/users09.dbf" datafile
19 auxiliary format
"/u01/app/oracle/oradata/csdb/users10.dbf" datafile
20 auxiliary format
"/u01/app/oracle/oradata/csdb/users11.dbf" datafile
21 auxiliary format
"/u01/app/oracle/oradata/csdb/users12.dbf" datafile
22 auxiliary format
"/u01/app/oracle/oradata/csdb/users13.dbf" datafile
23 auxiliary format
"/u01/app/oracle/oradata/csdb/users14.dbf" datafile
25 auxiliary format
"/u01/app/oracle/oradata/csdb/users16.dbf" datafile
26 auxiliary format
"/u01/app/oracle/oradata/csdb/users17.dbf" datafile
27 auxiliary format
"/u01/app/oracle/oradata/csdb/users15.dbf" datafile
28 auxiliary format
"/u01/app/oracle/oradata/csdb/users18.dbf" datafile
29 auxiliary format
"/u01/app/oracle/oradata/csdb/users19.dbf" datafile
30 auxiliary format
"/u01/app/oracle/oradata/csdb/users20.dbf" datafile
31 auxiliary format
"/u01/app/oracle/oradata/csdb/users21.dbf" datafile
32 auxiliary format
"/u01/app/oracle/oradata/csdb/users22.dbf" datafile
33 auxiliary format
"/u01/app/oracle/oradata/csdb/users23.dbf" datafile
34 auxiliary format
"/u01/app/oracle/oradata/csdb/users24.dbf" datafile
35 auxiliary format
"/u01/app/oracle/oradata/csdb/users25.dbf" datafile
36 auxiliary format
"/u01/app/oracle/oradata/csdb/users26.dbf" datafile
37 auxiliary format
"/u01/app/oracle/oradata/csdb/users27.dbf" datafile
38 auxiliary format
"/u01/app/oracle/oradata/csdb/users28.dbf" datafile
39 auxiliary format
"/u01/app/oracle/oradata/csdb/users29.dbf" datafile
40 auxiliary format
"/u01/app/oracle/oradata/csdb/users30.dbf" datafile
41 auxiliary format
"/u01/app/oracle/oradata/csdb/undotbs02.dbf" datafile
42 auxiliary format
"/u01/app/oracle/oradata/csdb/undotbs03.dbf" datafile
49 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.262.1109177757" datafile
50 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.263.1109178111" datafile
51 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/undotbs2.264.1109178457" datafile
52 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.284.1109186395" datafile
53 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.285.1109186791" datafile
54 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.286.1109187157" datafile
55 auxiliary format
"/u01/app/oracle/oradata/csdb/datafile/users.287.1109187493" datafile
56 auxiliary format
"/u01/app/oracle/oradata/csdb/users31.dbf" datafile
57 auxiliary format
"/u01/app/oracle/oradata/csdb/users32.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/csdb/temp01.dbf in control file
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
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
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
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 backup at 19-SEP-22
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+JHK/csdbs/system01.dbf
output file name=/u01/app/oracle/oradata/csdb/system01.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+JHK/csdbs/sysaux01.dbf
output file name=/u01/app/oracle/oradata/csdb/sysaux01.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+JHK/csdbs/undotbs01.dbf
output file name=/u01/app/oracle/oradata/csdb/undotbs01.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00049 name=+JHK/csdbs/datafile/undotbs2.262.1109177757
output file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.262.1109177757 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00050 name=+JHK/csdbs/datafile/undotbs2.263.1109178111
output file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.263.1109178111 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00051 name=+JHK/csdbs/datafile/undotbs2.264.1109178457
output file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.264.1109178457 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00025 name=+JHK/csdbs/users16.dbf
output file name=/u01/app/oracle/oradata/csdb/users16.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00026 name=+JHK/csdbs/users17.dbf
output file name=/u01/app/oracle/oradata/csdb/users17.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00027 name=+JHK/csdbs/users15.dbf
output file name=/u01/app/oracle/oradata/csdb/users15.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00028 name=+JHK/csdbs/users18.dbf
output file name=/u01/app/oracle/oradata/csdb/users18.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00029 name=+JHK/csdbs/users19.dbf
output file name=/u01/app/oracle/oradata/csdb/users19.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00030 name=+JHK/csdbs/users20.dbf
output file name=/u01/app/oracle/oradata/csdb/users20.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00031 name=+JHK/csdbs/users21.dbf
output file name=/u01/app/oracle/oradata/csdb/users21.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00032 name=+JHK/csdbs/users22.dbf
output file name=/u01/app/oracle/oradata/csdb/users22.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00033 name=+JHK/csdbs/users23.dbf
output file name=/u01/app/oracle/oradata/csdb/users23.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00034 name=+JHK/csdbs/users24.dbf
output file name=/u01/app/oracle/oradata/csdb/users24.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:36
channel ORA_DISK_1: starting datafile copy
input datafile file number=00035 name=+JHK/csdbs/users25.dbf
output file name=/u01/app/oracle/oradata/csdb/users25.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00036 name=+JHK/csdbs/users26.dbf
output file name=/u01/app/oracle/oradata/csdb/users26.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00037 name=+JHK/csdbs/users27.dbf
output file name=/u01/app/oracle/oradata/csdb/users27.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00038 name=+JHK/csdbs/users28.dbf
output file name=/u01/app/oracle/oradata/csdb/users28.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00039 name=+JHK/csdbs/users29.dbf
output file name=/u01/app/oracle/oradata/csdb/users29.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00040 name=+JHK/csdbs/users30.dbf
output file name=/u01/app/oracle/oradata/csdb/users30.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00041 name=+JHK/csdbs/undotbs02.dbf
output file name=/u01/app/oracle/oradata/csdb/undotbs02.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00042 name=+JHK/csdbs/undotbs03.dbf
output file name=/u01/app/oracle/oradata/csdb/undotbs03.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:36
channel ORA_DISK_1: starting datafile copy
input datafile file number=00052 name=+JHK/csdbs/datafile/users.284.1109186395
output file name=/u01/app/oracle/oradata/csdb/datafile/users.284.1109186395 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00053 name=+JHK/csdbs/datafile/users.285.1109186791
output file name=/u01/app/oracle/oradata/csdb/datafile/users.285.1109186791 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00054 name=+JHK/csdbs/datafile/users.286.1109187157
output file name=/u01/app/oracle/oradata/csdb/datafile/users.286.1109187157 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting datafile copy
input datafile file number=00055 name=+JHK/csdbs/datafile/users.287.1109187493
output file name=/u01/app/oracle/oradata/csdb/datafile/users.287.1109187493 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00056 name=+JHK/csdbs/users31.dbf
output file name=/u01/app/oracle/oradata/csdb/users31.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00057 name=+JHK/csdbs/users32.dbf
output file name=/u01/app/oracle/oradata/csdb/users32.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:05:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+JHK/csdbs/users01.dbf
output file name=/u01/app/oracle/oradata/csdb/users01.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=+JHK/csdbs/users02.dbf
output file name=/u01/app/oracle/oradata/csdb/users02.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:16
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=+JHK/csdbs/users03.dbf
output file name=/u01/app/oracle/oradata/csdb/users03.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=+JHK/csdbs/users04.dbf
output file name=/u01/app/oracle/oradata/csdb/users04.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:07:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00014 name=+JHK/csdbs/users05.dbf
output file name=/u01/app/oracle/oradata/csdb/users05.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:06:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00023 name=+JHK/csdbs/users14.dbf
output file name=/u01/app/oracle/oradata/csdb/users14.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00019 name=+JHK/csdbs/users10.dbf
output file name=/u01/app/oracle/oradata/csdb/users10.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00020 name=+JHK/csdbs/users11.dbf
output file name=/u01/app/oracle/oradata/csdb/users11.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00021 name=+JHK/csdbs/users12.dbf
output file name=/u01/app/oracle/oradata/csdb/users12.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00022 name=+JHK/csdbs/users13.dbf
output file name=/u01/app/oracle/oradata/csdb/users13.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:26
channel ORA_DISK_1: starting datafile copy
input datafile file number=00015 name=+JHK/csdbs/users06.dbf
output file name=/u01/app/oracle/oradata/csdb/users06.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00016 name=+JHK/csdbs/users07.dbf
output file name=/u01/app/oracle/oradata/csdb/users07.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00018 name=+JHK/csdbs/users09.dbf
output file name=/u01/app/oracle/oradata/csdb/users09.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00017 name=+JHK/csdbs/users08.dbf
output file name=/u01/app/oracle/oradata/csdb/users08.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=+JHK/csdbs/swpt01
output file name=/u01/app/oracle/oradata/csdb/swpt01 tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:26
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+JHK/csdbs/example01.dbf
output file name=/u01/app/oracle/oradata/csdb/example01.dbf tag=TAG20220919T124526
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 19-SEP-22
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=185 STAMP=1115827367 file name=/u01/app/oracle/oradata/csdb/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=186 STAMP=1115827367 file name=/u01/app/oracle/oradata/csdb/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=187 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=188 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=189 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/example01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=190 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/swpt01
datafile 11 switched to datafile copy
input datafile copy RECID=191 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users02.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=192 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users03.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=193 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users04.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=194 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users05.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=195 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users06.dbf
datafile 16 switched to datafile copy
input datafile copy RECID=196 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users07.dbf
datafile 17 switched to datafile copy
input datafile copy RECID=197 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users08.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=198 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users09.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=199 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users10.dbf
datafile 20 switched to datafile copy
input datafile copy RECID=200 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users11.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=201 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users12.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=202 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users13.dbf
datafile 23 switched to datafile copy
input datafile copy RECID=203 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users14.dbf
datafile 25 switched to datafile copy
input datafile copy RECID=204 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users16.dbf
datafile 26 switched to datafile copy
input datafile copy RECID=205 STAMP=1115827368 file name=/u01/app/oracle/oradata/csdb/users17.dbf
datafile 27 switched to datafile copy
input datafile copy RECID=206 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users15.dbf
datafile 28 switched to datafile copy
input datafile copy RECID=207 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users18.dbf
datafile 29 switched to datafile copy
input datafile copy RECID=208 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users19.dbf
datafile 30 switched to datafile copy
input datafile copy RECID=209 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users20.dbf
datafile 31 switched to datafile copy
input datafile copy RECID=210 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users21.dbf
datafile 32 switched to datafile copy
input datafile copy RECID=211 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users22.dbf
datafile 33 switched to datafile copy
input datafile copy RECID=212 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users23.dbf
datafile 34 switched to datafile copy
input datafile copy RECID=213 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users24.dbf
datafile 35 switched to datafile copy
input datafile copy RECID=214 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users25.dbf
datafile 36 switched to datafile copy
input datafile copy RECID=215 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users26.dbf
datafile 37 switched to datafile copy
input datafile copy RECID=216 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users27.dbf
datafile 38 switched to datafile copy
input datafile copy RECID=217 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users28.dbf
datafile 39 switched to datafile copy
input datafile copy RECID=218 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users29.dbf
datafile 40 switched to datafile copy
input datafile copy RECID=219 STAMP=1115827369 file name=/u01/app/oracle/oradata/csdb/users30.dbf
datafile 41 switched to datafile copy
input datafile copy RECID=220 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/undotbs02.dbf
datafile 42 switched to datafile copy
input datafile copy RECID=221 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/undotbs03.dbf
datafile 49 switched to datafile copy
input datafile copy RECID=222 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.262.1109177757
datafile 50 switched to datafile copy
input datafile copy RECID=223 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.263.1109178111
datafile 51 switched to datafile copy
input datafile copy RECID=224 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/datafile/undotbs2.264.1109178457
datafile 52 switched to datafile copy
input datafile copy RECID=225 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/datafile/users.284.1109186395
datafile 53 switched to datafile copy
input datafile copy RECID=226 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/datafile/users.285.1109186791
datafile 54 switched to datafile copy
input datafile copy RECID=227 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/datafile/users.286.1109187157
datafile 55 switched to datafile copy
input datafile copy RECID=228 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/datafile/users.287.1109187493
datafile 56 switched to datafile copy
input datafile copy RECID=229 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/users31.dbf
datafile 57 switched to datafile copy
input datafile copy RECID=230 STAMP=1115827370 file name=/u01/app/oracle/oradata/csdb/users32.dbf
Finished Duplicate Db at 19-SEP-22
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-2916127/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle 11g duplicate database基於備份複製資料庫(六)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(五)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(四)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(三)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(二)OracleDatabase資料庫
- oracle 11g duplicate database基於備份複製資料庫(一)OracleDatabase資料庫
- duplicate複製資料庫（rac-rac）資料庫
- Oracle 11g RAC查詢物理備庫延遲情況Oracle
- oracle sqldeveloper選擇性複製備份資料庫OracleSQLDeveloper資料庫
- oracle 11g duplicate from active database 複製資料庫(四)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(三)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(二)OracleDatabase資料庫
- oracle 11g duplicate from active database 複製資料庫(一)OracleDatabase資料庫
- [zt] 高階複製、流複製（Streams）、備庫區別
- Oracle備份與恢復系列（四）複製資料庫 續 手工複製資料庫的最簡操作Oracle資料庫
- Oracle活動資料庫複製Oracle資料庫
- oracle rman複製資料庫Oracle資料庫
- xtrabackup 不用lock tables來複製備庫
- 11g從活動資料庫複製資料庫資料庫
- rman duplicate target database RMAN-03002 RMAN-03015 RMAN-06136Database
- oracle 11g RAC 安裝前準備指令碼Oracle指令碼
- duplicate複製資料庫（rac-單例項）資料庫單例
- Oracle 11g RAC DG備庫gv$dataguard_stats apply lag值較大OracleAPP
- oracle 11g之物理備庫管理Oracle
- Oracle 之 Duplicate 複製資料庫Oracle資料庫
- oracle實驗-資料庫複製Oracle資料庫
- Oracle 11g GoldenGate單向複製配置（DML）OracleGo
- Oracle備份與恢復系列（四）續 RMAN Duplicate複製資料庫Oracle資料庫
- Oracle 12c 使用RMAN搭建物理備庫(RAC to RAC)Oracle
- oracle之 RAC 11G ASM下控制檔案多路複用OracleASM
- 【DataGuard】手工冷備搭建 Oracle 11g DataGuard 物理備庫Oracle
- oracle複製Oracle
- Redis主備複製Redis
- oracle rac 備份Oracle
- Oracle goldengate 11g （二）【DML and DDL單向複製】OracleGo
- oracle 11G RAC 安裝前準備和注意事項Oracle
- ORACLE使用者管理方式下備份資料和複製資料庫Oracle資料庫
- Oracle備份與恢復系列 五 續 EXP/IMP遷移、複製資料庫Oracle資料庫