在同一个机器上复制数据库

程序员文章站 2024-01-01 13:48:22

...

将IBS库复制为orcl1库。在两个库上创建密码文件： set Oracle_sid=ibs orapwd file=F:\BBCLDB\ORCL1\PWDibs1.ora password=sys

将IBS库复制为orcl1库。

在两个库上创建密码文件：

set Oracle_sid=ibs

orapwd file=F:\BBCLDB\ORCL1\PWDibs1.ora password=system entries=30

set oracle_sid=orcl1

orapwd file=F:\BBCLDB\ORCL1\PWDorcl1.ora password=system entries=30

创建一个新的服务

oradim -NEW -SID orcl1

修改主库、辅助数据库的监听 tnsname.ora文件

IBS 的参数文件：

ibs.__db_cache_size=18253611008
ibs.__java_pool_size=134217728
ibs.__large_pool_size=134217728
ibs.__oracle_base='e:\app\Administrator'#ORACLE_BASE set from environment
ibs.__pga_aggregate_target=15971909632
ibs.__sga_target=22951231488
ibs.__shared_io_pool_size=0
ibs.__shared_pool_size=4026531840
ibs.__streams_pool_size=134217728
*.audit_file_dest='e:\app\Administrator\admin\IBS\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='F:\BBCLDB\IBS\IBS\control01.ctl','e:\app\Administrator\flash_recovery_area\IBS\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='IBS'
*.db_recovery_file_dest='e:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=536870912000
*.diagnostic_dest='e:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=IBSXDB)'
*.memory_target=8848692224
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
*.log_archive_format='ARC%S_%R.%T'
*.log_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'
*.db_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'

orcl1的参数文件：

orcl1.__db_cache_size=25769803776
orcl1.__java_pool_size=134217728
orcl1.__large_pool_size=134217728
orcl1.__oracle_base='e:\app\Administrator'#ORACLE_BASE set from environment
orcl1.__pga_aggregate_target=31406948352
orcl1.__sga_target=30467424256
orcl1.__shared_io_pool_size=0
orcl1.__shared_pool_size=3758096384
orcl1.__streams_pool_size=268435456
*.audit_file_dest='e:\app\Administrator\admin\ORCL1\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='e:\app\Administrator\oradata\ORCL1\control01.ctl','e:\app\Administrator\flash_recovery_area\ORCL1\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='ORCL1'
*.db_recovery_file_dest='e:\app\Administrator\flash_recovery_area'
*.db_recovery_file_dest_size=4102029312
*.diagnostic_dest='e:\app\Administrator'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCL1XDB)'
*.memory_target=9842915328
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=FALSE
*.undo_tablespace='UNDOTBS1'
*.log_archive_format='ARC%S_%R.%T'
*.log_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'
*.db_file_name_convert='F:\BBCLDB\IBS\IBS','F:\BBCLDB\ORCL1'

两个文件中主要是这三行要加上。

set oracle_sid=ibs

C:\Users\Administrator>rman target sys/system auxiliary sys/system@orcl1

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 30 18:09:41 2011

connected to target database: IBS (DBID=623540487)
connected to auxiliary database: ORCL1 (not mounted)

RMAN> DUPLICATE TARGET DATABASE TO orcl1 from active database nofilenamecheck;

Starting Duplicate Db at 30-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=201 device type=DISK

contents of Memory Script:
{
sql clone "alter system set db_name =
''IBS'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''ORCL1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format 'E:\APP\ADMINISTRATOR\OR
ADATA\ORCL1\CONTROL01.CTL';
restore clone controlfile to 'E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL1
\CONTROL02.CTL' from
'E:\APP\ADMINISTRATOR\ORADATA\ORCL1\CONTROL01.CTL';
alter clone database mount;
}
executing Memory Script

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

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

Oracle instance shut down

Oracle instance started

Total System Global Area 9820950528 bytes

Fixed Size 2184112 bytes
Variable Size 5033167952 bytes
Database Buffers 4764729344 bytes
Redo Buffers 20869120 bytes

Starting backup at 30-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=187 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFIBS.O
RA tag=TAG20111230T181012 RECID=1 STAMP=771271813
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 30-DEC-11

Starting restore at 30-DEC-11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=193 device type=DISK

channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 30-DEC-11

database mounted

contents of Memory Script:
{
set newname for datafile 1 to
"F:\BBCLDB\ORCL1\SYSTEM01.DBF";
set newname for datafile 2 to
"F:\BBCLDB\ORCL1\SYSAUX01.DBF";
set newname for datafile 3 to
"F:\BBCLDB\ORCL1\UNDOTBS01.DBF";
set newname for datafile 4 to
"F:\BBCLDB\ORCL1\USERS01.DBF";
set newname for datafile 5 to
"F:\BBCLDB\ORCL1\CI_DATALRG01.DBF";
set newname for datafile 6 to
"F:\BBCLDB\ORCL1\DATAUSR01.DBF";
set newname for datafile 7 to
"F:\BBCLDB\ORCL1\DATALRG01.DBF";
set newname for datafile 8 to
"F:\BBCLDB\ORCL1\DATASML01.DBF";
set newname for datafile 9 to
"F:\BBCLDB\ORCL1\INDEXLRG01.DBF";
set newname for datafile 10 to
"F:\BBCLDB\ORCL1\INDEXSML.DBF";
set newname for datafile 11 to
"F:\BBCLDB\ORCL1\DATALRG02.DBF";
set newname for datafile 12 to
"F:\BBCLDB\ORCL1\DATALRG03.DBF";
set newname for datafile 13 to
"F:\BBCLDB\ORCL1\DATALRG04.DBF";
set newname for datafile 14 to
"F:\BBCLDB\ORCL1\DATALRG05.DBF";
set newname for datafile 15 to
"F:\BBCLDB\ORCL1\DATALRG06.DBF";
set newname for datafile 16 to
"F:\BBCLDB\ORCL1\DATALRG07.DBF";
set newname for datafile 17 to
"F:\BBCLDB\ORCL1\INDEXLRG02.DBF";
set newname for datafile 18 to
"F:\BBCLDB\ORCL1\INDEXLRG03.DBF";
set newname for datafile 19 to
"F:\BBCLDB\ORCL1\INDEXLRG04.DBF";
set newname for datafile 20 to
"F:\BBCLDB\ORCL1\INDEXLRG05.DBF";
set newname for datafile 21 to
"F:\BBCLDB\ORCL1\INDEXLRG06.DBF";
set newname for datafile 22 to
"F:\BBCLDB\ORCL1\INDEXLRG07.DBF";
set newname for datafile 23 to
"F:\BBCLDB\ORCL1\DATALRG08.DBF";
backup as copy reuse
datafile 1 auxiliary format
"F:\BBCLDB\ORCL1\SYSTEM01.DBF" datafile
2 auxiliary format
"F:\BBCLDB\ORCL1\SYSAUX01.DBF" datafile
3 auxiliary format
"F:\BBCLDB\ORCL1\UNDOTBS01.DBF" datafile
4 auxiliary format
"F:\BBCLDB\ORCL1\USERS01.DBF" datafile
5 auxiliary format
"F:\BBCLDB\ORCL1\CI_DATALRG01.DBF" datafile
6 auxiliary format
"F:\BBCLDB\ORCL1\DATAUSR01.DBF" datafile
7 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG01.DBF" datafile
8 auxiliary format
"F:\BBCLDB\ORCL1\DATASML01.DBF" datafile
9 auxiliary format
"F:\BBCLDB\ORCL1\INDEXLRG01.DBF" datafile
10 auxiliary format
"F:\BBCLDB\ORCL1\INDEXSML.DBF" datafile
11 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG02.DBF" datafile
12 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG03.DBF" datafile
13 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG04.DBF" datafile
14 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG05.DBF" datafile
15 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG06.DBF" datafile
16 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG07.DBF" datafile
17 auxiliary format
"F:\BBCLDB\ORCL1\INDEXLRG02.DBF" datafile
18 auxiliary format
"F:\BBCLDB\ORCL1\INDEXLRG03.DBF" datafile
19 auxiliary format
"F:\BBCLDB\ORCL1\INDEXLRG04.DBF" datafile
20 auxiliary format
"F:\BBCLDB\ORCL1\INDEXLRG05.DBF" datafile
21 auxiliary format
"F:\BBCLDB\ORCL1\INDEXLRG06.DBF" datafile
22 auxiliary format
"F:\BBCLDB\ORCL1\INDEXLRG07.DBF" datafile
23 auxiliary format
"F:\BBCLDB\ORCL1\DATALRG08.DBF" ;
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

Starting backup at 30-DEC-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=F:\BBCLDB\IBS\IBS\DATALRG01.DBF

在同一个机器上复制数据库

，

相关标签：数据库在同一个机器上复制数据库数据库 Oracle Or

在同一个机器上复制数据库

在同一个机器上复制数据库

手把手教你在win10系统上安装、配置MySQL5.7.19数据库

在Linux中通过本地复制的方式创建多一个Oracle数据库

windows下在一台机器上安装两个MYSQL数据库的方法_MySQL

SQL Server与Oracle数据库在安全性上的异同

在CentOS上MySQL数据库服务器配置方法

在CentOS上MySQL数据库服务器配置方法

在windows上安装不同(两个)版本的Mysql数据库的教程详解

SQL高级应用之同服务器上复制表到另一数据库中并实现去重复

在OracleE数据库的字段上建立索引的方法