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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 使用 NFS 的資料遷移實驗過程NFS
- Mongo資料遷移實驗Go
- Oracle遷移資料庫過程記錄Oracle資料庫
- 資料庫遷移之資料泵實驗資料庫
- 達夢資料庫資料檔案遷移過程資料庫
- 使用SQL SERVER儲存過程實現歷史資料遷移SQLServer儲存過程
- Mysql百萬級資料遷移,怎麼遷移?實戰過沒?MySql
- oracle遷移資料經驗Oracle
- 企業資訊系統在遷移過程中,資料遷移要注意什麼?
- 資料遷移(1)——通過資料泵表結構批量遷移
- MySQL 8.0.20 MGR資料遷移過程以及注意事項MySql
- 用bulk 實現超快遷移審計表AUD$資料過程一個
- Duplicate 複製資料庫實驗過程資料庫
- 達夢資料庫系統表空間資料檔案遷移過程資料庫
- kafka資料遷移實踐Kafka
- Oracle行遷移實驗Oracle
- 【實驗】【外部表】以資料泵檔案格式抽取and遷移資料演示
- 安全警示錄---記一次oracle資料檔案遷移過程Oracle
- 遷移資料.
- 【遷移】使用rman遷移資料庫資料庫
- Win環境至Linux環境Oracle資料庫遷移全過程LinuxOracle資料庫
- 一次利用mv線上遷移資料、切換系統的過程
- 海量資料遷移之透過shell估算資料量
- 海量資料遷移之通過shell估算資料量
- 【資料遷移】使用傳輸表空間遷移資料
- ORM實操之資料庫遷移ORM資料庫
- 線上資料遷移,數字化時代的必修課 —— 京東雲資料遷移實踐
- Kafka資料遷移Kafka
- 資料庫遷移資料庫
- redis資料遷移Redis
- 轉資料遷移
- ORACLE 資料遷移Oracle
- DXWB 資料遷移
- 資料的遷移
- 【資料遷移】RMAN遷移資料庫到ASM(三)遷移onlinelog等到ASM資料庫ASM
- 模擬11G單例項到12C的資料遷移過程單例
- 記一次 GitLab 的遷移過程Gitlab
- 如何遷移RDS中的加密儲存過程加密儲存過程