Duplicate+NFS数据迁移
实验背景：
Server 1：192.168.88.2，NFS服务器，数据源
Server 2：192.168.88.3，NFS客户端，目标主机
Server 1和Server 2都有如下别名：
alias sql='rlwrap sqlplus /nolog'
alias rman='rlwrap rman'
alias dbs='cd $ORACLE_HOME/dbs'
alias rdb='cd $ORACLE_HOME/rdbms/admin'
alias udu='cd $ORACLE_BASE/admin/$ORACLE_SID/udump'
alias bdu='cd $ORACLE_BASE/admin/$ORACLE_SID/bdump'
alias rmalert='rm -f $ORACLE_BASE/admin/$ORACLE_SID/bdump/*;rm -f $ORACLE_BASE/admin/$ORACLE_SID/udump/*'
Server 2：目标主机，在此将Server 1的NFS文件夹挂载到本地的FRA目录（与Server 1中数据备份的文件夹一致即可）下
[oracle@ORA10G2 ~]$ su -
Password:
[root@ORA10G2 ~]# mount -t nfs 192.168.88.2:/oracle/flash_recovery_area /oracle/flash_recovery_area/
[root@ORA10G2 ~]# mount
/dev/sda2 on / type ext3 (rw)
none on /proc type proc (rw)
none on /sys type sysfs (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbfs on /proc/bus/usb type usbfs (rw)
/dev/sda1 on /boot type ext3 (rw)
none on /dev/shm type tmpfs (rw)
/dev/sda3 on /oracle type ext3 (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
none on /proc/fs/vmblock/mountPoint type vmblock (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
192.168.88.2:/oracle/flash_recovery_area on /oracle/flash_recovery_area type nfs (rw,addr=192.168.88.2)
[root@ORA10G2 ~]# exit
logout
[oracle@ORA10G2 ~]$ dbs
[oracle@ORA10G2 dbs]$ ll
total 6952
-rw-rw---- 1 oracle oinstall 1544 Feb 18 10:54 hc_hongye.dat
-rw-r----- 1 oracle oinstall 854 Feb 18 10:52 initcat.ora
-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 854 Feb 18 10:49 inithongye.ora
-rw-r----- 1 oracle oinstall 2469 Feb 11 20:59 init.ora
-rw-rw---- 1 oracle oinstall 24 Feb 18 10:54 lkHONGYE
-rw-r----- 1 oracle oinstall 1536 Feb 18 10:49 orapwdhongye
-rw-r----- 1 oracle oinstall 7061504 Feb 18 11:09 snapcf_hongye.f
-rw-r----- 1 oracle oinstall 694 Feb 17 19:34 sqlnet.log
[oracle@ORA10G2 dbs]$ vi initcat.ora
*.audit_file_dest='/oracle/admin/cat/adump'
*.background_dump_dest='/oracle/admin/cat/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oracle/oradata/cat/control01.ctl'
*.core_dump_dest='/oracle/admin/cat/cdump'
*.db_block_size=8192
*.db_domain='oracle.com'
*.db_file_multiblock_read_count=16
*.db_name='cat'
*.db_recovery_file_dest='/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=catXDB)'
*.job_queue_processes=10
*.nls_date_format='yyyy-mm-dd hh24:mi:ss'
*.open_cursors=30
*.pga_aggregate_target=16777216
*.processes=100
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=70
*.sga_target=80M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/admin/cat/udump'
db_file_name_convert=('hongye','cat')
log_file_name_convert=('hongye','cat')
~
~
~
~
~
"initcat.ora" 25L, 831C written
[oracle@ORA10G2 dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwcat
Enter password for SYS:
[oracle@ORA10G2 dbs]$ ll
total 6956
-rw-rw---- 1 oracle oinstall 1544 Feb 18 10:54 hc_hongye.dat
-rw-r----- 1 oracle oinstall 831 Feb 18 13:34 initcat.ora
-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 854 Feb 18 10:49 inithongye.ora
-rw-r----- 1 oracle oinstall 2469 Feb 11 20:59 init.ora
-rw-rw---- 1 oracle oinstall 24 Feb 18 10:54 lkHONGYE
-rw-r----- 1 oracle oinstall 1536 Feb 18 13:35 orapwcat
-rw-r----- 1 oracle oinstall 1536 Feb 18 10:49 orapwdhongye
-rw-r----- 1 oracle oinstall 7061504 Feb 18 11:09 snapcf_hongye.f
-rw-r----- 1 oracle oinstall 694 Feb 17 19:34 sqlnet.log
[oracle@ORA10G2 dbs]$ export ORACLE_SID=cat
[oracle@ORA10G2 dbs]$ cd ../network/admin/
[oracle@ORA10G2 admin]$ ll
total 48
-rw-r----- 1 oracle oinstall 3673 Feb 15 20:56 listener.ora
drwxr-x--- 2 oracle oinstall 4096 Feb 11 19:03 samples
-rw-r--r-- 1 oracle oinstall 172 Dec 26 2003 shrept.lst
-rw-r--r-- 1 oracle oinstall 31023 Feb 15 20:31 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 3087 Feb 15 20:54 tnsnames.ora
[oracle@ORA10G2 admin]$ vi listener.ora
# This file contains all the parameters for listener.ora,
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.3)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=hongye.oracle.com)
(SID_NAME=hongye)
(ORACLE_HOME=/oracle/product/10.2.0/db_1)
)
(SID_DESC=
(GLOBAL_DBNAME=cat.oracle.com)
(SID_NAME=cat)
(ORACLE_HOME=/oracle/product/10.2.0/db_1)
)
)
[oracle@ORA10G2 admin]$ vi tnsnames.ora
hongye=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=hongye.oracle.com)(SERVER=dedicate))
)
cat=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(CONNECT_DATA=(SID=cat)(SERVER=dedicate))
)
"tnsnames.ora" 103L, 3229C written
[oracle@ORA10G2 admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 18-FEB-2011 13:41:14
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 18-FEB-2011 13:41:14
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "cat.oracle.com" has 1 instance(s).
Instance "cat", status UNKNOWN, has 1 handler(s) for this service...
Service "hongye.oracle.com" has 1 instance(s).
Instance "hongye", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@ORA10G2 admin]$ dbs
[oracle@ORA10G2 dbs]$ echo $ORACLE_SID
cat
[oracle@ORA10G2 dbs]$ cd /oracle/admin/
[oracle@ORA10G2 admin]$ ll
total 4
drwxr-xr-x 7 oracle oinstall 4096 Feb 17 19:29 hongye
[oracle@ORA10G2 admin]$ mkdir cat cat/adump cat/bdump cat/cdump cat/udump
[oracle@ORA10G2 admin]$ ll
total 8
drwxr-xr-x 6 oracle oinstall 4096 Feb 18 13:42 cat
drwxr-xr-x 7 oracle oinstall 4096 Feb 17 19:29 hongye
[oracle@ORA10G2 admin]$ ll cat/
total 16
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 adump
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 bdump
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 cdump
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 udump
[oracle@ORA10G2 admin]$ cd /oracle/oradata/
[oracle@ORA10G2 oradata]$ ll
total 4
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 11:05 hongye
[oracle@ORA10G2 oradata]$ mkdir cat
[oracle@ORA10G2 oradata]$ ll
total 8
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:43 cat
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 11:05 hongye
[oracle@ORA10G2 oradata]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 13:43:38 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn /as sysdba
Connected to an idle instance.
IDLE > startup nomount
ORACLE instance started.
Total System Global Area 83886080 bytes
Fixed Size 1272096 bytes
Variable Size 58722016 bytes
Database Buffers 16777216 bytes
Redo Buffers 7114752 bytes
IDLE > conn sys/hongye50@cat as sysdba
Connected.
SYS:103@cat > exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Server 1：源数据服务器，将在此主机上执行主要的步骤。
[oracle@ORA10G ~]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 13:44:06 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn /as sysdba
Connected.
SYS:158@hongye > select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
SYS:158@hongye > exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ORA10G ~]$ cd $ORACLE_HOME/network/admin
[oracle@ORA10G admin]$ ll
total 48
-rw-r----- 1 oracle oinstall 3673 Feb 15 20:56 listener.ora
drwxr-x--- 2 oracle oinstall 4096 Feb 11 19:03 samples
-rw-r--r-- 1 oracle oinstall 172 Dec 26 2003 shrept.lst
-rw-r--r-- 1 oracle oinstall 31023 Feb 15 20:31 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 3087 Feb 15 20:54 tnsnames.ora
[oracle@ORA10G admin]$ vi tnsnames.ora
hongye=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=hongye.oracle.com)(SERVER=dedicate))
)
cat=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.3)(PORT=1521))
(CONNECT_DATA=(SID=cat)(SERVER=dedicate))
)
"tnsnames.ora" 102L, 3231C written
[oracle@ORA10G admin]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 13:52:20 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn sys/hongye50@cat as sysdba
Connected.
SYS:103@cat > exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ORA10G admin]$ rman
Recovery Manager: Release 10.2.0.5.0 - Production on Fri Feb 18 13:56:52 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: HONGYE (DBID=2424037643)
RMAN> connect auxiliary sys/hongye50@cat
connected to auxiliary database: CAT (not mounted)
RMAN> duplicate target database to cat;
Starting Duplicate Db at 18-FEB-11
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=101 devtype=DISK
contents of Memory Script.:
{
set until scn 1243671;
set newname for datafile 1 to
"/oracle/oradata/cat/system01.dbf";
set newname for datafile 2 to
"/oracle/oradata/cat/undotbs01.dbf";
set newname for datafile 3 to
"/oracle/oradata/cat/sysaux01.dbf";
set newname for datafile 4 to
"/oracle/oradata/cat/users01.dbf";
set newname for datafile 5 to
"/oracle/oradata/cat/example01.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 18-FEB-11
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/cat/system01.dbf
restoring datafile 00002 to /oracle/oradata/cat/undotbs01.dbf
restoring datafile 00003 to /oracle/oradata/cat/sysaux01.dbf
restoring datafile 00004 to /oracle/oradata/cat/users01.dbf
restoring datafile 00005 to /oracle/oradata/cat/example01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_nnndf_TAG20110217T191915_6ot11mbc_.bkp
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_nnndf_TAG20110217T191915_6ot11mbc_.bkp tag=TAG20110217T191915
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:05:04
Finished restore at 18-FEB-11
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CAT" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oracle/oradata/cat/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/cat/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/cat/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/cat/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script.:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=743436244 filename=/oracle/oradata/cat/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=743436244 filename=/oracle/oradata/cat/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=743436244 filename=/oracle/oradata/cat/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=743436244 filename=/oracle/oradata/cat/example01.dbf
contents of Memory Script.:
{
set until scn 1243671;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 18-FEB-11
using channel ORA_AUX_DISK_1
starting media recovery
archive log thread 1 sequence 3 is already on disk as file /oracle/flash_recovery_area/HONGYE/archivelog/2011_02_18/o1_mf_1_3_6ovroxxv_.arc
channel ORA_AUX_DISK_1: starting archive log restore to default destination
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=2
channel ORA_AUX_DISK_1: reading from backup piece /oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_annnn_TAG20110217T192041_6ot14bjm_.bkp
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_annnn_TAG20110217T192041_6ot14bjm_.bkp tag=TAG20110217T192041
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/oracle/flash_recovery_area/CAT/archivelog/2011_02_18/o1_mf_1_2_6ow2yw8s_.arc thread=1 sequence=2
channel clone_default: deleting archive log(s)
archive log filename=/oracle/flash_recovery_area/CAT/archivelog/2011_02_18/o1_mf_1_2_6ow2yw8s_.arc recid=1 stamp=743436252
archive log filename=/oracle/flash_recovery_area/HONGYE/archivelog/2011_02_18/o1_mf_1_3_6ovroxxv_.arc thread=1 sequence=3
media recovery complete, elapsed time: 00:00:13
Finished recover at 18-FEB-11
contents of Memory Script.:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 83886080 bytes
Fixed Size 1272096 bytes
Variable Size 58722016 bytes
Database Buffers 16777216 bytes
Redo Buffers 7114752 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CAT" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oracle/oradata/cat/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/cat/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/cat/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/cat/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script.:
{
set newname for tempfile 1 to
"/oracle/oradata/cat/temp01.dbf";
set newname for tempfile 2 to
"/oracle/oradata/cat/temp02.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/oracle/oradata/cat/undotbs01.dbf";
catalog clone datafilecopy "/oracle/oradata/cat/sysaux01.dbf";
catalog clone datafilecopy "/oracle/oradata/cat/users01.dbf";
catalog clone datafilecopy "/oracle/oradata/cat/example01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed temporary file 1 to /oracle/oradata/cat/temp01.dbf in control file
renamed temporary file 2 to /oracle/oradata/cat/temp02.dbf in control file
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/undotbs01.dbf recid=1 stamp=743436292
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/sysaux01.dbf recid=2 stamp=743436292
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/users01.dbf recid=3 stamp=743436292
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/example01.dbf recid=4 stamp=743436292
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=743436292 filename=/oracle/oradata/cat/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=743436292 filename=/oracle/oradata/cat/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=743436292 filename=/oracle/oradata/cat/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=743436292 filename=/oracle/oradata/cat/example01.dbf
contents of Memory Script.:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 18-FEB-11
RMAN> exit
Recovery Manager complete.
[oracle@ORA10G admin]$
Server 2：检查结果：
[oracle@ORA10G2 ~]$ ls /oracle/oradata/cat/
control01.ctl redo01.log redo03.log system01.dbf temp02.dbf users01.dbf
example01.dbf redo02.log sysaux01.dbf temp01.dbf undotbs01.dbf
[oracle@ORA10G2 ~]$ export ORACLE_SID=cat
[oracle@ORA10G2 ~]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 14:06:29 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn /as sysdba
Connected.
SYS:87@cat > select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
SYS:87@cat > conn scott/tiger
Connected.
SCOTT:87@cat > select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 1980-12-17 00:00:00 800 20
7499 ALLEN SALESMAN 7698 1981-02-20 00:00:00 1600 300 30
7521 WARD SALESMAN 7698 1981-02-22 00:00:00 1250 500 30
7566 JONES MANAGER 7839 1981-04-02 00:00:00 2975 20
7654 MARTIN SALESMAN 7698 1981-09-28 00:00:00 1250 1400 30
7698 BLAKE MANAGER 7839 1981-05-01 00:00:00 2850 30
7782 CLARK MANAGER 7839 1981-06-09 00:00:00 2450 10
7788 SCOTT ANALYST 7566 1987-04-19 00:00:00 3000 20
7839 KING PRESIDENT 1981-11-17 00:00:00 5000 10
7844 TURNER SALESMAN 7698 1981-09-08 00:00:00 1500 0 30
7876 ADAMS CLERK 7788 1987-05-23 00:00:00 1100 20
7900 JAMES CLERK 7698 1981-12-03 00:00:00 950 30
7902 FORD ANALYST 7566 1981-12-03 00:00:00 3000 20
7934 MILLER CLERK 7782 1982-01-23 00:00:00 1300 10
14 rows selected.
SCOTT:87@cat >
实验背景：
Server 1：192.168.88.2，NFS服务器，数据源
Server 2：192.168.88.3，NFS客户端，目标主机
Server 1和Server 2都有如下别名：
alias sql='rlwrap sqlplus /nolog'
alias rman='rlwrap rman'
alias dbs='cd $ORACLE_HOME/dbs'
alias rdb='cd $ORACLE_HOME/rdbms/admin'
alias udu='cd $ORACLE_BASE/admin/$ORACLE_SID/udump'
alias bdu='cd $ORACLE_BASE/admin/$ORACLE_SID/bdump'
alias rmalert='rm -f $ORACLE_BASE/admin/$ORACLE_SID/bdump/*;rm -f $ORACLE_BASE/admin/$ORACLE_SID/udump/*'
Server 2：目标主机，在此将Server 1的NFS文件夹挂载到本地的FRA目录（与Server 1中数据备份的文件夹一致即可）下
[oracle@ORA10G2 ~]$ su -
Password:
[root@ORA10G2 ~]# mount -t nfs 192.168.88.2:/oracle/flash_recovery_area /oracle/flash_recovery_area/
[root@ORA10G2 ~]# mount
/dev/sda2 on / type ext3 (rw)
none on /proc type proc (rw)
none on /sys type sysfs (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbfs on /proc/bus/usb type usbfs (rw)
/dev/sda1 on /boot type ext3 (rw)
none on /dev/shm type tmpfs (rw)
/dev/sda3 on /oracle type ext3 (rw)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
none on /proc/fs/vmblock/mountPoint type vmblock (rw)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)
192.168.88.2:/oracle/flash_recovery_area on /oracle/flash_recovery_area type nfs (rw,addr=192.168.88.2)
[root@ORA10G2 ~]# exit
logout
[oracle@ORA10G2 ~]$ dbs
[oracle@ORA10G2 dbs]$ ll
total 6952
-rw-rw---- 1 oracle oinstall 1544 Feb 18 10:54 hc_hongye.dat
-rw-r----- 1 oracle oinstall 854 Feb 18 10:52 initcat.ora
-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 854 Feb 18 10:49 inithongye.ora
-rw-r----- 1 oracle oinstall 2469 Feb 11 20:59 init.ora
-rw-rw---- 1 oracle oinstall 24 Feb 18 10:54 lkHONGYE
-rw-r----- 1 oracle oinstall 1536 Feb 18 10:49 orapwdhongye
-rw-r----- 1 oracle oinstall 7061504 Feb 18 11:09 snapcf_hongye.f
-rw-r----- 1 oracle oinstall 694 Feb 17 19:34 sqlnet.log
[oracle@ORA10G2 dbs]$ vi initcat.ora
*.audit_file_dest='/oracle/admin/cat/adump'
*.background_dump_dest='/oracle/admin/cat/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oracle/oradata/cat/control01.ctl'
*.core_dump_dest='/oracle/admin/cat/cdump'
*.db_block_size=8192
*.db_domain='oracle.com'
*.db_file_multiblock_read_count=16
*.db_name='cat'
*.db_recovery_file_dest='/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=catXDB)'
*.job_queue_processes=10
*.nls_date_format='yyyy-mm-dd hh24:mi:ss'
*.open_cursors=30
*.pga_aggregate_target=16777216
*.processes=100
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=70
*.sga_target=80M
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/admin/cat/udump'
db_file_name_convert=('hongye','cat')
log_file_name_convert=('hongye','cat')
~
~
~
~
~
"initcat.ora" 25L, 831C written
[oracle@ORA10G2 dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwcat
Enter password for SYS:
[oracle@ORA10G2 dbs]$ ll
total 6956
-rw-rw---- 1 oracle oinstall 1544 Feb 18 10:54 hc_hongye.dat
-rw-r----- 1 oracle oinstall 831 Feb 18 13:34 initcat.ora
-rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 854 Feb 18 10:49 inithongye.ora
-rw-r----- 1 oracle oinstall 2469 Feb 11 20:59 init.ora
-rw-rw---- 1 oracle oinstall 24 Feb 18 10:54 lkHONGYE
-rw-r----- 1 oracle oinstall 1536 Feb 18 13:35 orapwcat
-rw-r----- 1 oracle oinstall 1536 Feb 18 10:49 orapwdhongye
-rw-r----- 1 oracle oinstall 7061504 Feb 18 11:09 snapcf_hongye.f
-rw-r----- 1 oracle oinstall 694 Feb 17 19:34 sqlnet.log
[oracle@ORA10G2 dbs]$ export ORACLE_SID=cat
[oracle@ORA10G2 dbs]$ cd ../network/admin/
[oracle@ORA10G2 admin]$ ll
total 48
-rw-r----- 1 oracle oinstall 3673 Feb 15 20:56 listener.ora
drwxr-x--- 2 oracle oinstall 4096 Feb 11 19:03 samples
-rw-r--r-- 1 oracle oinstall 172 Dec 26 2003 shrept.lst
-rw-r--r-- 1 oracle oinstall 31023 Feb 15 20:31 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 3087 Feb 15 20:54 tnsnames.ora
[oracle@ORA10G2 admin]$ vi listener.ora
# This file contains all the parameters for listener.ora,
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.3)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=hongye.oracle.com)
(SID_NAME=hongye)
(ORACLE_HOME=/oracle/product/10.2.0/db_1)
)
(SID_DESC=
(GLOBAL_DBNAME=cat.oracle.com)
(SID_NAME=cat)
(ORACLE_HOME=/oracle/product/10.2.0/db_1)
)
)
[oracle@ORA10G2 admin]$ vi tnsnames.ora
hongye=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=hongye.oracle.com)(SERVER=dedicate))
)
cat=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(CONNECT_DATA=(SID=cat)(SERVER=dedicate))
)
"tnsnames.ora" 103L, 3229C written
[oracle@ORA10G2 admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.5.0 - Production on 18-FEB-2011 13:41:14
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.5.0 - Production
System parameter file is /oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.5.0 - Production
Start Date 18-FEB-2011 13:41:14
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "cat.oracle.com" has 1 instance(s).
Instance "cat", status UNKNOWN, has 1 handler(s) for this service...
Service "hongye.oracle.com" has 1 instance(s).
Instance "hongye", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@ORA10G2 admin]$ dbs
[oracle@ORA10G2 dbs]$ echo $ORACLE_SID
cat
[oracle@ORA10G2 dbs]$ cd /oracle/admin/
[oracle@ORA10G2 admin]$ ll
total 4
drwxr-xr-x 7 oracle oinstall 4096 Feb 17 19:29 hongye
[oracle@ORA10G2 admin]$ mkdir cat cat/adump cat/bdump cat/cdump cat/udump
[oracle@ORA10G2 admin]$ ll
total 8
drwxr-xr-x 6 oracle oinstall 4096 Feb 18 13:42 cat
drwxr-xr-x 7 oracle oinstall 4096 Feb 17 19:29 hongye
[oracle@ORA10G2 admin]$ ll cat/
total 16
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 adump
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 bdump
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 cdump
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:42 udump
[oracle@ORA10G2 admin]$ cd /oracle/oradata/
[oracle@ORA10G2 oradata]$ ll
total 4
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 11:05 hongye
[oracle@ORA10G2 oradata]$ mkdir cat
[oracle@ORA10G2 oradata]$ ll
total 8
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 13:43 cat
drwxr-xr-x 2 oracle oinstall 4096 Feb 18 11:05 hongye
[oracle@ORA10G2 oradata]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 13:43:38 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn /as sysdba
Connected to an idle instance.
IDLE > startup nomount
ORACLE instance started.
Total System Global Area 83886080 bytes
Fixed Size 1272096 bytes
Variable Size 58722016 bytes
Database Buffers 16777216 bytes
Redo Buffers 7114752 bytes
IDLE > conn sys/hongye50@cat as sysdba
Connected.
SYS:103@cat > exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Server 1：源数据服务器，将在此主机上执行主要的步骤。
[oracle@ORA10G ~]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 13:44:06 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn /as sysdba
Connected.
SYS:158@hongye > select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
SYS:158@hongye > exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ORA10G ~]$ cd $ORACLE_HOME/network/admin
[oracle@ORA10G admin]$ ll
total 48
-rw-r----- 1 oracle oinstall 3673 Feb 15 20:56 listener.ora
drwxr-x--- 2 oracle oinstall 4096 Feb 11 19:03 samples
-rw-r--r-- 1 oracle oinstall 172 Dec 26 2003 shrept.lst
-rw-r--r-- 1 oracle oinstall 31023 Feb 15 20:31 sqlnet.ora
-rw-r--r-- 1 oracle oinstall 3087 Feb 15 20:54 tnsnames.ora
[oracle@ORA10G admin]$ vi tnsnames.ora
hongye=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=hongye.oracle.com)(SERVER=dedicate))
)
cat=
( DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.3)(PORT=1521))
(CONNECT_DATA=(SID=cat)(SERVER=dedicate))
)
"tnsnames.ora" 102L, 3231C written
[oracle@ORA10G admin]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 13:52:20 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn sys/hongye50@cat as sysdba
Connected.
SYS:103@cat > exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ORA10G admin]$ rman
Recovery Manager: Release 10.2.0.5.0 - Production on Fri Feb 18 13:56:52 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN> connect target /
connected to target database: HONGYE (DBID=2424037643)
RMAN> connect auxiliary sys/hongye50@cat
connected to auxiliary database: CAT (not mounted)
RMAN> duplicate target database to cat;
Starting Duplicate Db at 18-FEB-11
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=101 devtype=DISK
contents of Memory Script.:
{
set until scn 1243671;
set newname for datafile 1 to
"/oracle/oradata/cat/system01.dbf";
set newname for datafile 2 to
"/oracle/oradata/cat/undotbs01.dbf";
set newname for datafile 3 to
"/oracle/oradata/cat/sysaux01.dbf";
set newname for datafile 4 to
"/oracle/oradata/cat/users01.dbf";
set newname for datafile 5 to
"/oracle/oradata/cat/example01.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 18-FEB-11
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/cat/system01.dbf
restoring datafile 00002 to /oracle/oradata/cat/undotbs01.dbf
restoring datafile 00003 to /oracle/oradata/cat/sysaux01.dbf
restoring datafile 00004 to /oracle/oradata/cat/users01.dbf
restoring datafile 00005 to /oracle/oradata/cat/example01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_nnndf_TAG20110217T191915_6ot11mbc_.bkp
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_nnndf_TAG20110217T191915_6ot11mbc_.bkp tag=TAG20110217T191915
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:05:04
Finished restore at 18-FEB-11
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CAT" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oracle/oradata/cat/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/cat/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/cat/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/cat/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script.:
{
switch clone datafile all;
}
executing Memory Script
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=743436244 filename=/oracle/oradata/cat/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=743436244 filename=/oracle/oradata/cat/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=743436244 filename=/oracle/oradata/cat/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=743436244 filename=/oracle/oradata/cat/example01.dbf
contents of Memory Script.:
{
set until scn 1243671;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 18-FEB-11
using channel ORA_AUX_DISK_1
starting media recovery
archive log thread 1 sequence 3 is already on disk as file /oracle/flash_recovery_area/HONGYE/archivelog/2011_02_18/o1_mf_1_3_6ovroxxv_.arc
channel ORA_AUX_DISK_1: starting archive log restore to default destination
channel ORA_AUX_DISK_1: restoring archive log
archive log thread=1 sequence=2
channel ORA_AUX_DISK_1: reading from backup piece /oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_annnn_TAG20110217T192041_6ot14bjm_.bkp
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/oracle/flash_recovery_area/HONGYE/backupset/2011_02_17/o1_mf_annnn_TAG20110217T192041_6ot14bjm_.bkp tag=TAG20110217T192041
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/oracle/flash_recovery_area/CAT/archivelog/2011_02_18/o1_mf_1_2_6ow2yw8s_.arc thread=1 sequence=2
channel clone_default: deleting archive log(s)
archive log filename=/oracle/flash_recovery_area/CAT/archivelog/2011_02_18/o1_mf_1_2_6ow2yw8s_.arc recid=1 stamp=743436252
archive log filename=/oracle/flash_recovery_area/HONGYE/archivelog/2011_02_18/o1_mf_1_3_6ovroxxv_.arc thread=1 sequence=3
media recovery complete, elapsed time: 00:00:13
Finished recover at 18-FEB-11
contents of Memory Script.:
{
shutdown clone;
startup clone nomount ;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 83886080 bytes
Fixed Size 1272096 bytes
Variable Size 58722016 bytes
Database Buffers 16777216 bytes
Redo Buffers 7114752 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CAT" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oracle/oradata/cat/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/cat/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/cat/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/cat/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script.:
{
set newname for tempfile 1 to
"/oracle/oradata/cat/temp01.dbf";
set newname for tempfile 2 to
"/oracle/oradata/cat/temp02.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/oracle/oradata/cat/undotbs01.dbf";
catalog clone datafilecopy "/oracle/oradata/cat/sysaux01.dbf";
catalog clone datafilecopy "/oracle/oradata/cat/users01.dbf";
catalog clone datafilecopy "/oracle/oradata/cat/example01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed temporary file 1 to /oracle/oradata/cat/temp01.dbf in control file
renamed temporary file 2 to /oracle/oradata/cat/temp02.dbf in control file
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/undotbs01.dbf recid=1 stamp=743436292
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/sysaux01.dbf recid=2 stamp=743436292
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/users01.dbf recid=3 stamp=743436292
cataloged datafile copy
datafile copy filename=/oracle/oradata/cat/example01.dbf recid=4 stamp=743436292
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=743436292 filename=/oracle/oradata/cat/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=743436292 filename=/oracle/oradata/cat/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=743436292 filename=/oracle/oradata/cat/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=743436292 filename=/oracle/oradata/cat/example01.dbf
contents of Memory Script.:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 18-FEB-11
RMAN> exit
Recovery Manager complete.
[oracle@ORA10G admin]$
Server 2：检查结果：
[oracle@ORA10G2 ~]$ ls /oracle/oradata/cat/
control01.ctl redo01.log redo03.log system01.dbf temp02.dbf users01.dbf
example01.dbf redo02.log sysaux01.dbf temp01.dbf undotbs01.dbf
[oracle@ORA10G2 ~]$ export ORACLE_SID=cat
[oracle@ORA10G2 ~]$ sql
SQL*Plus: Release 10.2.0.5.0 - Production on Fri Feb 18 14:06:29 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
IDLE > conn /as sysdba
Connected.
SYS:87@cat > select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
SYS:87@cat > conn scott/tiger
Connected.
SCOTT:87@cat > select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- ------------------- ---------- ---------- ----------
7369 SMITH CLERK 7902 1980-12-17 00:00:00 800 20
7499 ALLEN SALESMAN 7698 1981-02-20 00:00:00 1600 300 30
7521 WARD SALESMAN 7698 1981-02-22 00:00:00 1250 500 30
7566 JONES MANAGER 7839 1981-04-02 00:00:00 2975 20
7654 MARTIN SALESMAN 7698 1981-09-28 00:00:00 1250 1400 30
7698 BLAKE MANAGER 7839 1981-05-01 00:00:00 2850 30
7782 CLARK MANAGER 7839 1981-06-09 00:00:00 2450 10
7788 SCOTT ANALYST 7566 1987-04-19 00:00:00 3000 20
7839 KING PRESIDENT 1981-11-17 00:00:00 5000 10
7844 TURNER SALESMAN 7698 1981-09-08 00:00:00 1500 0 30
7876 ADAMS CLERK 7788 1987-05-23 00:00:00 1100 20
7900 JAMES CLERK 7698 1981-12-03 00:00:00 950 30
7902 FORD ANALYST 7566 1981-12-03 00:00:00 3000 20
7934 MILLER CLERK 7782 1982-01-23 00:00:00 1300 10
14 rows selected.
SCOTT:87@cat >
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24465008/viewspace-688036/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
使用 NFS 的数据迁移实验过程
下一篇：
Duplicate 复制数据库实验过程
请登录后发表评论
登录
全部评论
