Oracle 11gR2 使用RMAN Duplicate复制数据库_oracle duplicate必须使用spfile启动到nomount吗

最新推荐文章于 2024-06-13 21:12:59 发布

2024面试大全

最新推荐文章于 2024-06-13 21:12:59 发布

阅读量902

点赞数 30

文章标签：数据库 oracle

本文链接：https://blog.csdn.net/m0_60567908/article/details/138236670

版权

Oldest online log sequence 978
Next log sequence to archive 979
Current log sequence 979
SQL> alter system switch logfile;
alter system switch logfile;

System altered.

SQL>

System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA001/archive
Oldest online log sequence 980
Next log sequence to archive 981
Current log sequence 981


  



六、配置静态监听


   RAC节点监听信息如下:

$ cd $ORACLE_HOME/network/admin
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.woo.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = woo.com)
(ORACLE_HOME = /DBSoft/oracle/product/11.2.0/db_1)
(SID_NAME = woo)
)
)
ADR_BASE_LISTENER = /DBSoft/oracle


  


单节点监听信息如下:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.55)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = woo.com)
(ORACLE_HOME = /DBSoft/oracle/product/11.2.0/db_1)
(SID_NAME = woo)
)
)
ADR_BASE_LISTENER = /DBSoft/oracle


  


配置所有节点tnsname信息如下:

WOO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.woo.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = woo)
)
)

DUPLICATE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.7.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = woo)
)
)


  

六、启动数据库到nomount状态

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 954155008 bytes
Fixed Size 1368632 bytes
Variable Size 306187720 bytes
Database Buffers 641728512 bytes
Redo Buffers 4870144 bytes
SQL>exit ---------必须退出
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options


  



七、 在RAC端任意节点通过RMAN连接到目标实例和辅助实例，执行duplicate命令复制数据库：

[oracle@db01 ~]$ rman target sys/oracle@woo auxiliary sys/oracle@standby

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jun 3 19:39:00 2015

connected to target database: WOO (DBID=4218366793)
connected to auxiliary database: WOO (not mounted)

RMAN>
RMAN> duplicate target database to woo from active database nofilenamecheck;

Starting Duplicate Db at 03-JUN-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK

contents of Memory Script:
{
sql clone “alter system set db_name =
‘‘WOO’’ comment=
‘‘Modified by RMAN duplicate’’ scope=spfile”;
sql clone “alter system set db_unique_name =
‘‘WOO’’ comment=
‘‘Modified by RMAN duplicate’’ scope=spfile”;
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format ‘/DBSoft/oracle/oradata/woo/control01.ctl’;
restore clone controlfile to ‘/DBSoft/oracle/fast_recovery_area/woo/control02.ctl’ from
‘/DBSoft/oracle/oradata/woo/control01.ctl’;
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ‘‘WOO’’ comment= ‘‘Modified by RMAN duplicate’’ scope=spfile

sql statement: alter system set db_unique_name = ‘‘WOO’’ comment= ‘‘Modified by RMAN duplicate’’ scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 954155008 bytes

Fixed Size 1368632 bytes
Variable Size 306187720 bytes
Database Buffers 641728512 bytes
Redo Buffers 4870144 bytes

Starting backup at 03-JUN-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/DBSoft/oracle/product/11.2.4/dbhome_1/dbs/snapcf_woo.f tag=TAG20150603T194000 RECID=3 STAMP=881437202
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:08
Finished backup at 03-JUN-15

Starting restore at 03-JUN-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK

channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 03-JUN-15

database mounted

contents of Memory Script:
{
sql clone ‘alter database flashback off’;
set newname for datafile 1 to
“/DBSoft/oracle/oradata/woo/system01.dbf”;
set newname for datafile 2 to
“/DBSoft/oracle/oradata/woo/sysaux01.dbf”;
set newname for datafile 3 to
“/DBSoft/oracle/oradata/woo/undotbs01.dbf”;
set newname for datafile 4 to
“/DBSoft/oracle/oradata/woo/users01.dbf”;
backup as copy reuse
datafile 1 auxiliary format
“/DBSoft/oracle/oradata/woo/system01.dbf” datafile
2 auxiliary format
“/DBSoft/oracle/oradata/woo/sysaux01.dbf” datafile
3 auxiliary format
“/DBSoft/oracle/oradata/woo/undotbs01.dbf” datafile
4 auxiliary format
“/DBSoft/oracle/oradata/woo/users01.dbf” ;
sql ‘alter system archive log current’;
}
executing Memory Script

sql statement: alter database flashback off

executing command: SET NEWNAME

executing command: SET NEWNAME
Starting backup at 03-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/DBSoft/oracle/oradata/woo/system01.dbf
output file name=/DBSoft/oracle/oradata/woo/system01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:04:47
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
output file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
output file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/DBSoft/oracle/oradata/woo/users01.dbf
output file name=/DBSoft/oracle/oradata/woo/users01.dbf tag=TAG20150603T194019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 03-JUN-15

sql statement: alter system archive log current

contents of Memory Script:
{
backup as copy reuse
archivelog like “/DBArchive/archive/1_63_878860684.dbf” auxiliary format
“/DBArchive2/archive/1_63_878860684.dbf” ;
catalog clone archivelog “/DBArchive2/archive/1_63_878860684.dbf”;
switch clone datafile all;
}
executing Memory Script

Starting backup at 03-JUN-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=63 RECID=38 STAMP=881437711
output file name=/DBArchive2/archive/1_63_878860684.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 03-JUN-15

cataloged archived log
archived log file name=/DBArchive2/archive/1_63_878860684.dbf RECID=38 STAMP=881437696

datafile 1 switched to datafile copy
input datafile copy RECID=3 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=4 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=881437696 file name=/DBSoft/oracle/oradata/woo/users01.dbf

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

executing command: SET until clause

Starting recover at 03-JUN-15
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 63 is already on disk as file /DBArchive2/archive/1_63_878860684.dbf
archived log file name=/DBArchive2/archive/1_63_878860684.dbf thread=1 sequence=63
media recovery complete, elapsed time: 00:00:00
Finished recover at 03-JUN-15
Oracle instance started

Total System Global Area 954155008 bytes

Fixed Size 1368632 bytes
Variable Size 306187720 bytes
Database Buffers 641728512 bytes
Redo Buffers 4870144 bytes

contents of Memory Script:
{
sql clone “alter system set db_name =
‘‘WOO’’ comment=
‘‘Reset to original value by RMAN’’ scope=spfile”;
sql clone “alter system reset db_unique_name scope=spfile”;
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

sql statement: alter system set db_name = ‘‘WOO’’ comment= ‘‘Reset to original value by RMAN’’ scope=spfile

sql statement: alter system reset db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 954155008 bytes

Fixed Size 1368632 bytes
Variable Size 306187720 bytes
Database Buffers 641728512 bytes
Redo Buffers 4870144 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “WOO” RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( ‘/DBSoft/oracle/oradata/woo/redo01.log’ ) SIZE 50 M REUSE,
GROUP 2 ( ‘/DBSoft/oracle/oradata/woo/redo02.log’ ) SIZE 50 M REUSE,
GROUP 3 ( ‘/DBSoft/oracle/oradata/woo/redo03.log’ ) SIZE 50 M REUSE
DATAFILE
‘/DBSoft/oracle/oradata/woo/system01.dbf’
CHARACTER SET WE8MSWIN1252

contents of Memory Script:
{
set newname for tempfile 1 to
“/DBSoft/oracle/oradata/woo/temp01.dbf”;
switch clone tempfile all;
catalog clone datafilecopy “/DBSoft/oracle/oradata/woo/sysaux01.dbf”,
“/DBSoft/oracle/oradata/woo/undotbs01.dbf”,
“/DBSoft/oracle/oradata/woo/users01.dbf”;
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /DBSoft/oracle/oradata/woo/temp01.dbf in control file

cataloged datafile copy
datafile copy file name=/DBSoft/oracle/oradata/woo/sysaux01.dbf RECID=1 STAMP=881437718
cataloged datafile copy
datafile copy file name=/DBSoft/oracle/oradata/woo/undotbs01.dbf RECID=2 STAMP=881437718

最后的话

最近很多小伙伴找我要Linux学习资料，于是我翻箱倒柜，整理了一些优质资源，涵盖视频、电子书、PPT等共享给大家！

资料预览

给大家整理的视频资料：

给大家整理的电子书资料：

如果本文对你有帮助，欢迎点赞、收藏、转发给朋友，让我有持续创作的动力！

网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。

需要这份系统化的资料的朋友，可以点击这里获取！

一个人可以走的很快，但一群人才能走的更远！不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！
理了一些优质资源，涵盖视频、电子书、PPT等共享给大家！

资料预览

给大家整理的视频资料：

[外链图片转存中…(img-k1HbQgul-1714161175837)]

给大家整理的电子书资料：

[外链图片转存中…(img-P0pGfDUV-1714161175837)]

如果本文对你有帮助，欢迎点赞、收藏、转发给朋友，让我有持续创作的动力！

网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。

需要这份系统化的资料的朋友，可以点击这里获取！

一个人可以走的很快，但一群人才能走的更远！不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！

2024面试大全

关注

30
点赞
踩
30

收藏

觉得还不错? 一键收藏
1
评论
Oracle 11gR2 使用RMAN Duplicate复制数据库_oracle duplicate必须使用spfile启动到nomount吗

最近很多小伙伴找我要Linux学习资料，于是我翻箱倒柜，整理了一些优质资源，涵盖视频、电子书、PPT等共享给大家！
复制链接

扫一扫