ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Duplicate+NFS数据迁移实验过程

Duplicate+NFS数据迁移实验过程

原创 Linux操作系统 作者:红叶DBA 时间:2011-02-27 17:02:27 0 删除 编辑
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 >

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24465008/viewspace-688036/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-08-19

  • 博文量
    54
  • 访问量
    69631