RMAN duplicate搭建辅助数据库

于 2023-03-18 23:47:40 发布
阅读量893 收藏
点赞数
文章标签： 数据库 oracle rman duplicate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mengxiangfeiyang/article/details/129645076
版权

RMAN duplicate搭建辅助数据库

使用RMAN DUPLICATE命令可以在保留目标数据库的基础上依靠目标数据库(TargetDatabase)的备份创建一个副本数据库(DuplicateDatabase)，目标数据库和辅助数据库可以在同一台机器上，辅助数据库是目标数据库的一个拷贝。

复制新库步骤
1）将辅助库上安装数据库软件，不建库，建立Oracle Home
2）为辅助库建立口令文件，Active方式下与源数据库口令相同
3）确保到辅助实例的网络连通性（辅助库建立静态监听）
4）为辅助实例创建参数文件
5）以nomount方式启动辅助实例（启动静态监听）
6）生产数据库处于mount或open模式下
7）创建备份或将备份和归档日志文件复制到辅助库实例可以访问的某个位置，或者使用活动（active）数据库复制
8）如果有必要分配辅助通道
9）运行rman duplicate命令
10）使用resetlogs打开辅助数据库
duplicate是个不完全恢复，因为current log没有办法通过RMAN备份

实战演示：
数据库ASM - > ASM

配置本地新数据库的环境：

export ORACLE_SID=newdkf
vi /tmp/initnewdkf.ora
*.db_name='newdkf'
*.enable_pluggable_database=true

配置本地新数据库的密码文件：

[oracle@dkf dbs]$ ls -al orapw*
-rw-r----- 1 oracle oinstall 2048 Apr  4  2022 orapwdkf006
-rw-r----- 1 oracle oinstall 2048 Mar 18 19:09 orapwnewdkf
[oracle@dkf dbs]$

启动新的目标数据库：

SQL> startup nomount pfile='/tmp/initnewdkf.ora'
ORACLE instance started.

Total System Global Area  297795128 bytes
Fixed Size                  9133624 bytes
Variable Size             234881024 bytes
Database Buffers           50331648 bytes
Redo Buffers                3448832 bytes
SQL>

配置静态监听：

[oracle@dkf admin]$ cat listener.ora 
dkf=
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.19)(PORT = 1522))
)

SID_LIST_dkf=
    (SID_LIST =
        (SID_DESC =
            (GLOBAL_DBNAME = dkf006)
            (ORACLE_HOME =/u01/app/oracle/product/19.3.0/dbhome_1)
            (SID_NAME = dkf006)
        )
        (SID_DESC =
            (GLOBAL_DBNAME = newdkf)
            (ORACLE_HOME =/u01/app/oracle/product/19.3.0/dbhome_1)
            (SID_NAME = newdkf)
        )
    )

监听状态

[oracle@dkf admin]$ lsnrctl start dkf

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 18-MAR-2023 19:15:09

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/19.3.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/dkf/dkf/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.19)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.19)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     dkf
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                18-MAR-2023 19:15:09
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.3.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/dkf/dkf/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.19)(PORT=1522)))
Services Summary...
Service "dkf006" has 1 instance(s).
  Instance "dkf006", status UNKNOWN, has 1 handler(s) for this service...
Service "newdkf" has 1 instance(s).
  Instance "newdkf", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

连接现有数据库和目标数据库实例：

 rman target sys/oracle auxiliary sys/oracle@newdkf

通过duplicate target database 命令创建新的数据库；

RMAN通过网络（active方式）在本地复制用于新的数据库，
如果duplicate在复制时，位置不同的时候，我们会用參数db_file_name_convert 对文件位置进行转换， 本地复制样例中我们用的是同样的位置， 所以这里必须加上nofilenamecheck參数，该參数通知复制操作不必在运行还原操作前确认文件名称是不同的，如果没有指定nofilenamecheck參数，rman会给出例如以下错误：

RMAN-05001: auxiliary filename  /DBSoft/oracle/oradata/woo/users01.dbf conflicts with a file used by the target database

数据库duplicate日志输出：

[oracle@dkf admin]$ rman target sys/oracle auxiliary sys/oracle@newdkf

Recovery Manager: Release 19.0.0.0.0 - Production on Sat Mar 18 19:20:59 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DKF006 (DBID=2651711443)
connected to auxiliary database: NEWDKF (not mounted)
RMAN> 
RMAN> duplicate target database to newdkf from active database nofilenamecheck;

Starting Duplicate Db at 2023:03:1819:21:12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=40 device type=DISK
current log archived

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     297795128 bytes

Fixed Size                     9133624 bytes
Variable Size                234881024 bytes
Database Buffers              50331648 bytes
Redo Buffers                   3448832 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''DKF006'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name = 
 ''newdkf'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   backup as copy current controlfile auxiliary format  '/u01/app/oracle/product/19.3.0/dbhome_1/dbs/cntrlnewdkf.dbf';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''DKF006'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''newdkf'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area     297795128 bytes

Fixed Size                     9133624 bytes
Variable Size                234881024 bytes
Database Buffers              50331648 bytes
Redo Buffers                   3448832 bytes

Starting backup at 2023:03:1819:22:26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=125 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/awrdump/snapcf_%f tag=TAG20230318T192226
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2023:03:1819:22:27

database mounted
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DATAFILE/system.257.1101088487 conflicts with a file used by the target database
RMAN-05529: warning: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DATAFILE/sysaux.258.1101088521 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DATAFILE/undotbs1.259.1101088537 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.266.1101088791 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.267.1101088791 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DATAFILE/users.260.1101088537 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.268.1101088791 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/system.272.1101089437 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/sysaux.273.1101089437 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/undotbs1.271.1101089437 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/users.275.1101089451 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DATAFILE/test.280.1107398373 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name +DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/dkftest.281.1131796673 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name +DATA/DKF006/TEMPFILE/temp.265.1101088603 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name +DATA/DKF006/DBCED86261CB7148E0550A002762E1A4/TEMPFILE/temp.269.1101088829 conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name +DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/TEMPFILE/temp.274.1101089439 conflicts with a file used by the target database

contents of Memory Script:
{
   set newname for datafile  1 to 
 "+DATA";
   set newname for datafile  3 to 
 "+DATA";
   set newname for datafile  4 to 
 "+DATA";
   set newname for datafile  5 to 
 "+DATA";
   set newname for datafile  6 to 
 "+DATA";
   set newname for datafile  7 to 
 "+DATA";
   set newname for datafile  8 to 
 "+DATA";
   set newname for datafile  9 to 
 "+DATA";
   set newname for datafile  10 to 
 "+DATA";
   set newname for datafile  11 to 
 "+DATA";
   set newname for datafile  12 to 
 "+DATA";
   set newname for datafile  13 to 
 "+DATA";
   set newname for datafile  14 to 
 "+DATA";
   backup as copy reuse
   datafile  1 auxiliary format 
 "+DATA"   datafile 
 3 auxiliary format 
 "+DATA"   datafile 
 4 auxiliary format 
 "+DATA"   datafile 
 5 auxiliary format 
 "+DATA"   datafile 
 6 auxiliary format 
 "+DATA"   datafile 
 7 auxiliary format 
 "+DATA"   datafile 
 8 auxiliary format 
 "+DATA"   datafile 
 9 auxiliary format 
 "+DATA"   datafile 
 10 auxiliary format 
 "+DATA"   datafile 
 11 auxiliary format 
 "+DATA"   datafile 
 12 auxiliary format 
 "+DATA"   datafile 
 13 auxiliary format 
 "+DATA"   datafile 
 14 auxiliary format 
 "+DATA"   ;
   sql 'alter system archive log current';
}
executing Memory Script

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 2023:03:1819:22:37
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00013 name=+DATA/DKF006/DATAFILE/test.280.1107398373
output file name=+DATA/NEWDKF/DATAFILE/test.286.1131823357 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00010 name=+DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/sysaux.273.1101089437
output file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/sysaux.285.1131823373 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+DATA/DKF006/DATAFILE/sysaux.258.1101088521
output file name=+DATA/NEWDKF/DATAFILE/sysaux.284.1131823381 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/DKF006/DATAFILE/system.257.1101088487
output file name=+DATA/NEWDKF/DATAFILE/system.283.1131823383 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=+DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/undotbs1.271.1101089437
output file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/undotbs1.282.1131823387 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATA/DKF006/DATAFILE/undotbs1.259.1101088537
output file name=+DATA/NEWDKF/DATAFILE/undotbs1.289.1131823391 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=+DATA/DKF006/86B637B62FE07A65E053F706E80A27CA/DATAFILE/sysaux.267.1101088791
output file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/sysaux.288.1131823393 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=+DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/system.272.1101089437
output file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/system.287.1131823397 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+DATA/DKF006/86B637B62FE07A65E053F706E80A27CA/DATAFILE/system.266.1101088791
output file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/system.294.1131823397 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=+DATA/DKF006/86B637B62FE07A65E053F706E80A27CA/DATAFILE/undotbs1.268.1101088791
output file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/undotbs1.293.1131823401 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00014 name=+DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/dkftest.281.1131796673
output file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/dkftest.292.1131823403 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=+DATA/DKF006/DATAFILE/users.260.1101088537
output file name=+DATA/NEWDKF/DATAFILE/users.291.1131823403 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
input datafile file number=00012 name=+DATA/DKF006/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/users.275.1101089451
output file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/users.290.1131823405 tag=TAG20230318T192237
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2023:03:1819:23:25

sql statement: alter system archive log current
current log archived

contents of Memory Script:
{
   backup as copy reuse
   archivelog like  "/u01/app/oracle/arch/1_167_1101088597.arch" auxiliary format 
 "/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_167_1101088597.dbf"   archivelog like 
 "/u01/app/oracle/arch/1_168_1101088597.arch" auxiliary format 
 "/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_168_1101088597.dbf"   ;
   catalog clone archivelog  "/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_167_1101088597.dbf";
   catalog clone archivelog  "/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_168_1101088597.dbf";
   switch clone datafile all;
}
executing Memory Script

Starting backup at 2023:03:1819:23:26
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=167 RECID=228 STAMP=1131823405
output file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_167_1101088597.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=168 RECID=229 STAMP=1131823405
output file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_168_1101088597.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 2023:03:1819:23:29

cataloged archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_167_1101088597.dbf RECID=1 STAMP=1131823409

cataloged archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_168_1101088597.dbf RECID=2 STAMP=1131823409

datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=1131823409 file name=+DATA/NEWDKF/DATAFILE/system.283.1131823383
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=1131823409 file name=+DATA/NEWDKF/DATAFILE/sysaux.284.1131823381
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=1131823409 file name=+DATA/NEWDKF/DATAFILE/undotbs1.289.1131823391
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=1131823409 file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/system.294.1131823397
datafile 6 switched to datafile copy
input datafile copy RECID=8 STAMP=1131823409 file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/sysaux.288.1131823393
datafile 7 switched to datafile copy
input datafile copy RECID=9 STAMP=1131823409 file name=+DATA/NEWDKF/DATAFILE/users.291.1131823403
datafile 8 switched to datafile copy
input datafile copy RECID=10 STAMP=1131823409 file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/undotbs1.293.1131823401
datafile 9 switched to datafile copy
input datafile copy RECID=11 STAMP=1131823409 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/system.287.1131823397
datafile 10 switched to datafile copy
input datafile copy RECID=12 STAMP=1131823409 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/sysaux.285.1131823373
datafile 11 switched to datafile copy
input datafile copy RECID=13 STAMP=1131823409 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/undotbs1.282.1131823387
datafile 12 switched to datafile copy
input datafile copy RECID=14 STAMP=1131823409 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/users.290.1131823405
datafile 13 switched to datafile copy
input datafile copy RECID=15 STAMP=1131823409 file name=+DATA/NEWDKF/DATAFILE/test.286.1131823357
datafile 14 switched to datafile copy
input datafile copy RECID=16 STAMP=1131823409 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/dkftest.292.1131823403

contents of Memory Script:
{
   set until scn  7533463;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 2023:03:1819:23:30
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=45 device type=DISK

starting media recovery

archived log for thread 1 with sequence 167 is already on disk as file /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_167_1101088597.dbf
archived log for thread 1 with sequence 168 is already on disk as file /u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_168_1101088597.dbf
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_167_1101088597.dbf thread=1 sequence=167
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_168_1101088597.dbf thread=1 sequence=168
media recovery complete, elapsed time: 00:00:00
Finished recover at 2023:03:1819:23:32

contents of Memory Script:
{
   delete clone force archivelog all;
}
executing Memory Script

released channel: ORA_DISK_1
released channel: ORA_AUX_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=125 device type=DISK
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_167_1101088597.dbf RECID=1 STAMP=1131823409
deleted archived log
archived log file name=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/arch1_168_1101088597.dbf RECID=2 STAMP=1131823409
Deleted 2 objects

Oracle instance started

Total System Global Area     297795128 bytes

Fixed Size                     9133624 bytes
Variable Size                234881024 bytes
Database Buffers              50331648 bytes
Redo Buffers                   3448832 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name = 
 ''NEWDKF'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
}
executing Memory Script

sql statement: alter system set  db_name =  ''NEWDKF'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile
Oracle instance started

Total System Global Area     297795128 bytes

Fixed Size                     9133624 bytes
Variable Size                234881024 bytes
Database Buffers              50331648 bytes
Redo Buffers                   3448832 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "NEWDKF" RESETLOGS ARCHIVELOG 
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES     1024
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP     1 ( '+DATA' ) SIZE 200 M  REUSE,
  GROUP     2 ( '+DATA' ) SIZE 200 M  REUSE,
  GROUP     3 ( '+DATA' ) SIZE 200 M  REUSE
 DATAFILE
  '+DATA/NEWDKF/DATAFILE/system.283.1131823383',
  '+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/system.294.1131823397',
  '+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/system.287.1131823397'
 CHARACTER SET AL32UTF8


contents of Memory Script:
{
   set newname for tempfile  1 to 
 "+DATA";
   set newname for tempfile  2 to 
 "+DATA";
   set newname for tempfile  3 to 
 "+DATA";
   switch clone tempfile all;
   catalog clone datafilecopy  "+DATA/NEWDKF/DATAFILE/sysaux.284.1131823381", 
 "+DATA/NEWDKF/DATAFILE/undotbs1.289.1131823391", 
 "+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/sysaux.288.1131823393", 
 "+DATA/NEWDKF/DATAFILE/users.291.1131823403", 
 "+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/undotbs1.293.1131823401", 
 "+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/sysaux.285.1131823373", 
 "+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/undotbs1.282.1131823387", 
 "+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/users.290.1131823405", 
 "+DATA/NEWDKF/DATAFILE/test.286.1131823357", 
 "+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/dkftest.292.1131823403";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to +DATA in control file
renamed tempfile 2 to +DATA in control file
renamed tempfile 3 to +DATA in control file

cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DATAFILE/sysaux.284.1131823381 RECID=1 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DATAFILE/undotbs1.289.1131823391 RECID=2 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/sysaux.288.1131823393 RECID=3 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DATAFILE/users.291.1131823403 RECID=4 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/undotbs1.293.1131823401 RECID=5 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/sysaux.285.1131823373 RECID=6 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/undotbs1.282.1131823387 RECID=7 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/users.290.1131823405 RECID=8 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DATAFILE/test.286.1131823357 RECID=9 STAMP=1131823444
cataloged datafile copy
datafile copy file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/dkftest.292.1131823403 RECID=10 STAMP=1131823444

datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1131823444 file name=+DATA/NEWDKF/DATAFILE/sysaux.284.1131823381
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1131823444 file name=+DATA/NEWDKF/DATAFILE/undotbs1.289.1131823391
datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=1131823444 file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/sysaux.288.1131823393
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1131823444 file name=+DATA/NEWDKF/DATAFILE/users.291.1131823403
datafile 8 switched to datafile copy
input datafile copy RECID=5 STAMP=1131823444 file name=+DATA/NEWDKF/DBCED86261CB7148E0550A002762E1A4/DATAFILE/undotbs1.293.1131823401
datafile 10 switched to datafile copy
input datafile copy RECID=6 STAMP=1131823444 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/sysaux.285.1131823373
datafile 11 switched to datafile copy
input datafile copy RECID=7 STAMP=1131823444 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/undotbs1.282.1131823387
datafile 12 switched to datafile copy
input datafile copy RECID=8 STAMP=1131823444 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/users.290.1131823405
datafile 13 switched to datafile copy
input datafile copy RECID=9 STAMP=1131823444 file name=+DATA/NEWDKF/DATAFILE/test.286.1131823357
datafile 14 switched to datafile copy
input datafile copy RECID=10 STAMP=1131823444 file name=+DATA/NEWDKF/DBCEFC8A3ACE81CBE0550A002762E1A4/DATAFILE/dkftest.292.1131823403
Reenabling controlfile options for auxiliary database
Executing: alter database force logging

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened

contents of Memory Script:
{
   sql clone "alter pluggable database all open";
}
executing Memory Script

sql statement: alter pluggable database all open
Cannot remove created server parameter file
Finished Duplicate Db at 2023:03:1819:24:25

RMAN>

本文完!

====================================================

kuifeng.dong
关注
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库
02-28
Oracle 11gR2 使用 RMAN duplicate from active database 复制数据库
使用Duplicate target database命令恢复线上oracle datagard备库
06-02 334
线上oracle datagard备库由于断电以及误删除从库的归档日志文件，所以导致，备库主库数据不一致，备库需要紧急恢复，下面是大概恢复过程 1，从主库上面备份控制文件 [oracle@localhost rman_r...
RMAN新特性duplicate概述和使用
热门推荐
真水无香，大象无形，做本分的自己，记录技术点滴
06-06 1万+
RMANDUPLICATION复制概述   DUPLICATE命令可以创建完整的运行良好的数据库副本（clone DB）或Physical standby数据库。 DUPLICATE命令自动为duplicate数据库分配不同的DBID，以便它可以注册在与源数据库相同的catalog中。 DUPLICATION可以是数据库级别，也可以指定表空间级别。 RMAN必须执行基于时间点的恢复，即使
rman的duplicate复制数据库
freedompuge的专栏
05-09 4257
duplicate 最近公司准备迁移数据库，迁移的办法有很多，由于考虑到生产系统的安全性和停机时间等其他因素，选择的方案有很多，这里我们谈一下rman的duplicate： 11g的rman duplicate 相比10g先进了很多，10G需要在rman备份的基础上进行复制，使用 RMAN duplicate 创建一个数据完全相同但DBID不同的数据库。而11g的RMAN duplicate
认识duplicate命令
Dillon Oracle博客
08-31 2831
duplicate命令调用非常简单。oracle将实现数据库级复制的大量脚本都进行了封装。 只要准备工作充分，只需要简单的执行一条语句。 除了穿件副本数据库之外，还能用来创建物理standby数据库。 参考文档： duplicate复制数据库 用duplicate创建物理DG     可以看到duplicate的两个用途的命令： duplicate target da
使用RMAN传输数据_复制数据库
jetliu05的博客
01-26 3568
使用RMAN的DUPLICATE命令可以从源数据库复制全部或部分数据到复制数据库。
rman duplicate 搭建dg
04-30
rman duplicate 搭建dg 一步步向你展示如何不停机搭建dg
Oracle RMAN 异机 复制数据库
04-22
运行RMAN的`DUPLICATE`命令来复制数据库，指定源数据库的连接信息、目标目录和口令文件。例如，`RUN { DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE REPLACE; }` 9. **创建spfile文件**： 在复制...
rman冷备全备数据库脚本(本机备份与恢复)-详细文档笔记总结
06-30
rman 冷备全备数据库脚本详解 随着数据库的不断发展，数据的安全性变得越来越重要。作为数据库管理员，我们需要确保数据库的安全性和可靠性。rman 是 Oracle 提供的一种备份恢复工具，通过 rman，我们可以快速备份...
RMAN高级应用之Duplicate复制数据库.docx
最新发布
10-25
RMAN高级应用之Duplicate复制数据库
Oracle DUPLICATE复制数据库
一玩儿家的田地
01-16 1180
一、DUPLICATE复制数据库         1.使用duplicate命令可以在不影响目标数据库（Target/Primary Database）的情况下，依靠目标数         据库的备份集创建一个Duplicate数据库（数据库副本）。         在创建时既可以选择完整复制目标数据库，也可以仅包含目标数据库中的部分表空间，目标数据库         和Dupli
[2022-04-07] 搭建dataguard报 dbms_backup_restore.restoreCancel() failed
m15217321304的博客
04-07 1580
1、备库搭建时报如下错误 [oracle@rac1-adg ~]$ rman target sys/tiger@primary auxiliary sys/tiger@standby Recovery Manager: Release 19.0.0.0.0 - Production on Thu Apr 7 12:44:24 2022 Version 19.7.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rig
RMAN高级应用之Duplicate复制数据库(2)辅助实例
cqbh2011的博客
12-04 287
使用rman的duplicate命令复制数据库系列，本系列可以视为一步一步学RMAN的姊妹篇~~~~ RMAN高级应用之Duplicate复制数据库(1)概述　　辅助实例是创建副本数据库的重要一步，一般而言会有下列几个步骤，有些...
Oracle 19c DataGuard 实践
liuxinglei13的专栏
07-12 1359
Oralce DataGuard 安装与配置
Linux 7.9 平台 Oracle 19.3 物理Data Guard 安装
hbhe0316的专栏
10-10 273
1.环境准备 2台虚拟机，操作系统安装Redhat 7.9。 其他信息规划如下： sourcedb targetdb IP地址 192.168.56.101 192.168.56.102 数据库SID orcl orcl DB_UNIQUE_NAME orcl_p orcl_s 在2台虚拟机分别安装19c数据库软件，主库创建CDB实例orcl，PDB实例：hbhe。 备库只安装数据库软件，不创建实例。 在dg01和dg02服务器上修改
Oracle11g新特性：Active Database Duplicate
weixin_34353714的博客
01-15 189
利用Rman的duplicate命令，可以很方便的将原库复制出一个新库，这在诸如data guard等应用中非常有用。但是在Oracle11g之前，执行duplicate要求首先对原库用rman进行备份，然后将备份复制到复制库，同时连接原库(做为target)和复制库(做为auxiliary)，执行duplicate命令进行复制。在Oracle11g中推出的active da...
Oracle Duplicate database
qq_31144297的博客
12-20 2252
                               Oracle Duplicate database duplicate分为2种模式，1.直接从active状态的库直接复制；2.从目标库的备份文件来复制；现在两种方法都介绍下，直接上干货。 试验环境（2台机器）：         target db：TESTA         aux db：TESTA(db_name可修改） ...
oracle错误1327,Oracle DUPLICATE复制数据库
weixin_42121725的博客
04-03 941
一、DUPLICATE复制数据库1.使用duplicate命令可以在不影响目标数据库(Target/PrimaryDatabase)的情况下，依靠目标数据库的备份集创建一个Duplicate数据库(数据库副本)。在创建时既可以选择完整复制目标数据库，也可以仅包含目标数据库中的部分表空间，目标数据库和Duplicate数据库甚至可以在同一台机器上。2.Duplicate数据库是目标数据库在某个时间点...
使用rman中的duplicate复制数据库
03-19 256
目标库和复制库环境: OS: Linux Red Hat AS 4 DB Version: 10.2.0.1 1.目标库和复制库信息 Rman 中的目标库(t...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

kuifeng.dong

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值