Duplicate+NFS資料遷移實驗過程
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部落格 ” ，連結：http://blog.itpub.net/24465008/viewspace-688036/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 達夢資料庫資料檔案遷移過程資料庫
- 使用SQL SERVER儲存過程實現歷史資料遷移SQLServer儲存過程
- Mysql百萬級資料遷移，怎麼遷移？實戰過沒？MySql
- 企業資訊系統在遷移過程中，資料遷移要注意什麼？
- MySQL 8.0.20 MGR資料遷移過程以及注意事項MySql
- 13TB的StarRocks大資料庫遷移過程大資料資料庫
- 資料遷移（1）——通過資料泵表結構批量遷移
- 達夢資料庫系統表空間資料檔案遷移過程資料庫
- Win環境至Linux環境Oracle資料庫遷移全過程LinuxOracle資料庫
- 頭歌資料庫實驗六：儲存過程資料庫儲存過程
- 記一次 GitLab 的遷移過程Gitlab
- Hadoop資料遷移MaxCompute最佳實踐Hadoop
- ORM實操之資料庫遷移ORM資料庫
- Jenkins搭建與資料遷移實踐Jenkins
- 金倉資料庫資料遷移實戰：從MySQL到KES的順利遷移資料庫MySql
- Kafka資料遷移Kafka
- Harbor資料遷移
- gitlab資料遷移Gitlab
- 資料庫遷移資料庫
- cassandra百億級資料庫遷移實踐資料庫
- Mysql資料遷移方法MySql
- 【Hive】hive資料遷移Hive
- 【Redis】 redis資料遷移Redis
- redis資料庫遷移Redis資料庫
- congregate遷移gitlab資料Gitlab
- 系統資料遷移
- 資料庫遷移 ：理解資料庫
- laravel資料庫遷移Laravel資料庫
- Fastdfs資料遷移方案AST
- 【Redis 技術探索】「資料遷移實戰」手把手教你如何實現線上 + 離線模式進行遷移 Redis 資料實戰指南（scan模式遷移）Redis模式
- 伺服器資料遷移的方法-硬體不同如何遷移資料伺服器
- 線上資料遷移，數字化時代的必修課 —— 京東雲資料遷移實踐
- 攜程MySQL遷移OceanBase最佳實踐｜分享MySql
- Mysql百萬級資料遷移實戰筆記MySql筆記
- 資料庫平滑遷移方案與實踐分享資料庫
- 資料庫課程作業筆記 - 編寫資料庫遷移檔案資料庫筆記
- 記一次MySQL資料遷移到SQLServer全過程MySqlServer
- linux mysql資料庫遷移LinuxMySql資料庫
- django資料庫遷移-15Django資料庫