前言：好久没有搞过Oracle了，基本操作都已经忘光了，今天要迁移一台oracle数据库才想起来，折腾了大半天，写个文档当记录下吧。
一、静默安装
1.修改主机名
#sed -i "s/HOSTNAME=localhost.localdomain/HOSTNAME=oracledb.01/" /etc/sysconfig/network
2.添加hosts
192.168.241.245 oracledb.01
3.关闭selinux
sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config
setenforce 0
4.yum安装包
yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686
5.检测安装包是否完整
[root@oracledb ~]# rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat unixODBC unixODBC-devel
binutils-2.27-27.base.el7.x86_64
compat-libcap1-1.10-7.el7.x86_64
compat-libstdc++-33-3.2.3-72.el7.x86_64
compat-libstdc++-33-3.2.3-72.el7.i686
gcc-4.8.5-28.el7_5.1.x86_64
gcc-c++-4.8.5-28.el7_5.1.x86_64
glibc-2.17-222.el7.x86_64
glibc-2.17-222.el7.i686
glibc-devel-2.17-222.el7.x86_64
glibc-devel-2.17-222.el7.i686
ksh-20120801-137.el7.x86_64
libaio-0.3.109-13.el7.x86_64
libaio-0.3.109-13.el7.i686
libaio-devel-0.3.109-13.el7.x86_64
libaio-devel-0.3.109-13.el7.i686
libgcc-4.8.5-28.el7_5.1.x86_64
libgcc-4.8.5-28.el7_5.1.i686
libstdc++-4.8.5-28.el7_5.1.x86_64
libstdc++-4.8.5-28.el7_5.1.i686
libstdc++-devel-4.8.5-28.el7_5.1.x86_64
libstdc++-devel-4.8.5-28.el7_5.1.i686
libXi-1.7.9-1.el7.x86_64
libXi-1.7.9-1.el7.i686
libXtst-1.2.3-1.el7.x86_64
libXtst-1.2.3-1.el7.i686
make-3.82-23.el7.x86_64
sysstat-10.1.5-13.el7.x86_64
unixODBC-2.3.1-11.el7.x86_64
unixODBC-2.3.1-11.el7.i686
unixODBC-devel-2.3.1-11.el7.x86_64
unixODBC-devel-2.3.1-11.el7.i686
6.创建oinstall和dba组
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
7.创建用户
/usr/sbin/useradd -g oinstall -G dba oracle
8.设置账号密码
passwd oracle
9.配置内核参数
[root@oracledb ~]# cat /etc/sysctl.conf
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).
net.ipv4.ip_forward = 0
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.conf.default.rp_filter=0
net.ipv4.conf.default.accept_source_route = 0
net.ipv4.tcp_max_orphans = 3276800
net.ipv4.tcp_max_syn_backlog = 262144
net.ipv4.tcp_max_tw_buckets = 6000
net.ipv4.tcp_timestamps = 1
net.ipv4.tcp_synack_retries = 1
net.ipv4.tcp_syn_retries = 1
net.ipv4.tcp_tw_recycle = 1
net.ipv4.tcp_tw_reuse = 1
net.ipv4.tcp_mem = 94500000 915000000 927000000
net.ipv4.tcp_fin_timeout = 5
net.ipv4.tcp_keepalive_time = 30
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_window_scaling = 1
net.ipv4.tcp_rmem = 4096 87380 4194304
net.ipv4.tcp_wmem = 4096 16384 4194304
net.ipv4.tcp_sack = 1
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.msgmni=16384
kernel.sem="250 32000 100 1024"
net.core.wmem_default = 8388608
net.core.rmem_default = 8388608
net.core.rmem_max = 16777216
net.core.wmem_max = 16777216
net.core.netdev_max_backlog = 262144
net.core.somaxconn = 262144
###
vm.swappiness = 0
net.ipv4.neigh.default.gc_stale_time=120
net.ipv4.conf.all.rp_filter=0
net.ipv4.conf.default.rp_filter=0
net.ipv4.conf.default.arp_announce = 2
net.ipv4.conf.lo.arp_announce=2
net.ipv4.conf.all.arp_announce=2
net.ipv4.tcp_max_tw_buckets = 5000
net.ipv4.tcp_syncookies = 1
net.ipv4.tcp_max_syn_backlog = 1024
net.ipv4.tcp_synack_retries = 2
net.ipv6.conf.all.disable_ipv6 = 1
net.ipv6.conf.default.disable_ipv6 = 1
net.ipv6.conf.lo.disable_ipv6 = 1
fs.inotify.max_user_watches=999999
fs.file-max = 6815744
kernel.panic=30
###################
10.修改用户限制
vim /etc/security/limits.conf
末尾添加
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240
11.修改/etc/pam.d/login
session required /lib/security/pam_limits.so
session required pam_limits.so
12.修改环境变量
#vim /etc/profile
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
#source /etc/profile
13.创建目录
mkdir -p /u01/
chown -R oracle:oinstall /u01/
chmod -R 775 /u01/
14.配置oracle环境变量
#vim ~/.bash_profile
增加
########### oracle 11g #############
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=javadb1
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export LC_CTYPE=en_US.UTF-8
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LANG=AMERICAN_AMERICA.ZHS16GBK
#source ~/.bash_profile
15.解压文件
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
16.复制响应模板
mkdir ~/etc
cp /usr/local/src/database/response/* /home/oracle/etc/
[oracle@oracle-zjol-241 dbs]$ ls ~/etc
db_install.rsp dbca.rsp netca.rsp
[root@oracledb ~]# chmod 700 /home/oracle/etc/*.rsp
17.修改响应模板文件
[oracle@oracledb dbs]$ cat ~/etc/db_install.rsp |grep -v "^#"|grep -v "^$"
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=oracledb.01
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/oraInventory
SELECTED_LANGUAGES=en,zh_CN,zh_TW
ORACLE_HOME=/u01/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.3.0,oracle.oraolap:11.2.0.3.0,oracle.rdbms.dm:11.2.0.3.0,oracle.rdbms.dv:11.2.0.3.0,oracle.rdbms.lbac:11.2.0.3.0,oracle.rdbms.rat:11.2.0.3.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=javadb1
oracle.install.db.config.starterdb.SID=javadb1
oracle.install.db.config.starterdb.characterSet=ZHS16GBK
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=4096
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=oracle
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
18.开始静默安装
./runInstaller -silent -responseFile /home/oracle/etc/db_install.rsp
提示如下表示安装成功
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root scripts to run
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/11.2.0/db_1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
4. Return to this window and hit "Enter" key to continue
Successfully Setup Software.
-----------------------------------------------------------------------------
19.执行脚本
/u01/app/oraInventory/orainstRoot.sh
/u01/oracle/product/11.2.0/dbhome_1/root.sh
数据库软件到此已经安装成功
二、Rman在线拷贝数据库
来源ip：192.168.150.170
sid：javadb
目的ip：192.168.241.245
sid：javadb1
1.拷贝密码文件
从源机拷贝密码文件到目的机并重命名
/u01/oracle/product/11.2.0/dbhome_1/dbs/orapwjavadb1
2.初始化pfile
[oracle@oracle-zjol-241 ~]$ cat initjavadb1.ora
db_name=javadb1
db_block_size=8192
db_file_name_convert=('/u01/oracle/oradata/javadb/','/u01/app/oracle/oradata/javadb1/')
log_file_name_convert=('/u01/oracle/oradata/javadb/','/u01/app/oracle/oradata/javadb1/')
3.目的库配置监听
[oracle@oracle-zjol-241 admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/oracle
[oracle@oracle-zjol-241 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
JAVADB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.150.170)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = javadb)
)
)
4.源库配置tnsnames
[oracle@javadb11g admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
JAVADB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = javadb11g)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = javadb)
)
)
JAVADB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.241.245)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = javadb1)
)
)
5.目的库启动到nomount
# mv ~/initjavadb1.ora /u01/oracle/product/11.2.0/dbhome_1/dbs/
SQL> startup nomount pfile=/u01/oracle/product/11.2.0/dbhome_1/dbs/initjavadb1.ora
ORACLE instance started.
Total System Global Area 271437824 bytes
Fixed Size 2227456 bytes
Variable Size 213910272 bytes
Database Buffers 50331648 bytes
Redo Buffers 4968448 bytes
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 271437824 bytes
Fixed Size 2227456 bytes
Variable Size 213910272 bytes
Database Buffers 50331648 bytes
Redo Buffers 4968448 bytes
SQL>
6.登录源库使用Rman连接
[oracle@javadb11g u01]$ rman target sys/123456@javadb auxiliary sys/123456@javadb1
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Jun 13 19:23:52 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: JAVADB (DBID=3939368814)
connected to auxiliary database: JAVADB1 (not mounted)
RMAN>
7.开始在线拷贝
RMAN> duplicate target database to Javadb1 from active database;
Starting Duplicate Db at 13-JUN-18
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=5 device type=DISK
contents of Memory Script:
{
sql clone "alter system set db_name =
''JAVADB'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''JAVADB1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format '/u01/oracle/product/11.2.0/dbhome_1/dbs/cntrljavadb1.dbf';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''JAVADB'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''JAVADB1'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 271437824 bytes
Fixed Size 2227456 bytes
Variable Size 213910272 bytes
Database Buffers 50331648 bytes
Redo Buffers 4968448 bytes
Starting backup at 13-JUN-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=382 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/oracle/product/11.2.0/dbhome_1/dbs/snapcf_javadb.f tag=TAG20180613T192447 RECID=7 STAMP=978722688
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 13-JUN-18
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"/u01/oracle/oradata/javadb1/system01.dbf";
set newname for datafile 2 to
"/u01/oracle/oradata/javadb1/sysaux01.dbf";
set newname for datafile 3 to
"/u01/oracle/oradata/javadb1/undotbs01.dbf";
set newname for datafile 4 to
"/u01/oracle/oradata/javadb1/users01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/oracle/oradata/javadb1/system01.dbf" datafile
2 auxiliary format
"/u01/oracle/oradata/javadb1/sysaux01.dbf" datafile
3 auxiliary format
"/u01/oracle/oradata/javadb1/undotbs01.dbf" datafile
4 auxiliary format
"/u01/oracle/oradata/javadb1/users01.dbf" ;
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
Starting backup at 13-JUN-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/oracle/oradata/javadb/sysaux01.dbf
output file name=/u01/oracle/oradata/javadb1/sysaux01.dbf tag=TAG20180613T192453
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/oracle/oradata/javadb/system01.dbf
output file name=/u01/oracle/oradata/javadb1/system01.dbf tag=TAG20180613T192453
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/oracle/oradata/javadb/undotbs01.dbf
output file name=/u01/oracle/oradata/javadb1/undotbs01.dbf tag=TAG20180613T192453
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/oracle/oradata/javadb/users01.dbf
output file name=/u01/oracle/oradata/javadb1/users01.dbf tag=TAG20180613T192453
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 13-JUN-18
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "/u01/oracle/oradata/javadb/1_13673_820964590.dbf" auxiliary format
"/u01/oracle/product/11.2.0/dbhome_1/dbs/arch1_13673_820964590.dbf" ;
catalog clone archivelog "/u01/oracle/product/11.2.0/dbhome_1/dbs/arch1_13673_820964590.dbf";
switch clone datafile all;
}
executing Memory Script
Starting backup at 13-JUN-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=13673 RECID=25522 STAMP=978722792
output file name=/u01/oracle/product/11.2.0/dbhome_1/dbs/arch1_13673_820964590.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 13-JUN-18
cataloged archived log
archived log file name=/u01/oracle/product/11.2.0/dbhome_1/dbs/arch1_13673_820964590.dbf RECID=25522 STAMP=978722515
datafile 1 switched to datafile copy
input datafile copy RECID=7 STAMP=978722515 file name=/u01/oracle/oradata/javadb1/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=8 STAMP=978722515 file name=/u01/oracle/oradata/javadb1/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=9 STAMP=978722515 file name=/u01/oracle/oradata/javadb1/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=10 STAMP=978722515 file name=/u01/oracle/oradata/javadb1/users01.dbf
contents of Memory Script:
{
set until scn 410619837;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 13-JUN-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=424 device type=DISK
starting media recovery
archived log for thread 1 with sequence 13673 is already on disk as file /u01/oracle/product/11.2.0/dbhome_1/dbs/arch1_13673_820964590.dbf
archived log file name=/u01/oracle/product/11.2.0/dbhome_1/dbs/arch1_13673_820964590.dbf thread=1 sequence=13673
media recovery complete, elapsed time: 00:00:00
Finished recover at 13-JUN-18
Oracle instance started
Total System Global Area 271437824 bytes
Fixed Size 2227456 bytes
Variable Size 213910272 bytes
Database Buffers 50331648 bytes
Redo Buffers 4968448 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''JAVADB1'' 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 = ''JAVADB1'' 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 271437824 bytes
Fixed Size 2227456 bytes
Variable Size 213910272 bytes
Database Buffers 50331648 bytes
Redo Buffers 4968448 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "JAVADB1" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ( '/u01/oracle/oradata/javadb1/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/oracle/oradata/javadb1/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u01/oracle/oradata/javadb1/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/u01/oracle/oradata/javadb1/system01.dbf'
CHARACTER SET ZHS16GBK
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/oracle/oradata/javadb1/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/oracle/oradata/javadb1/sysaux01.dbf",
"/u01/oracle/oradata/javadb1/undotbs01.dbf",
"/u01/oracle/oradata/javadb1/users01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/oracle/oradata/javadb1/temp01.dbf in control file
cataloged datafile copy
datafile copy file name=/u01/oracle/oradata/javadb1/sysaux01.dbf RECID=1 STAMP=978722528
cataloged datafile copy
datafile copy file name=/u01/oracle/oradata/javadb1/undotbs01.dbf RECID=2 STAMP=978722528
cataloged datafile copy
datafile copy file name=/u01/oracle/oradata/javadb1/users01.dbf RECID=3 STAMP=978722528
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=978722528 file name=/u01/oracle/oradata/javadb1/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=978722528 file name=/u01/oracle/oradata/javadb1/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=978722528 file name=/u01/oracle/oradata/javadb1/users01.dbf
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
Finished Duplicate Db at 13-JUN-18
8.目的库验证
SQL> select dbid, open_mode from v$database;
DBID OPEN_MODE
---------- --------------------
3944274079 READ WRITE
到此Rman在线拷贝已经完成
三、附录
1.配置监听程序
netca /silent /responsefile /home/oracle/etc/netca.rsp
2.DBCA静默建库
vi etc/dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "javadb1"
SID = "javadb1"
TEMPLATENAME = "General_Purpose.dbc"
CHARACTERSET = "ZHS16GBK"
建库
dbca -silent -responseFile etc/dbca.rsp
3.删除实例
[oracle@oracledb dbs]$ dbca -silent -deleteDatabase -sourcedb javadb1
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/u01/oracle/cfgtoollogs/dbca/JAVADB1.log" for further details.
若有收获，就点个赞吧
0 人点赞
