服务器端:
[root@zydb]/zyhome/oracle/rodman#vi /etc/hosts
"/etc/hosts" 67 lines, 2137 characters
# @(#)47 1.1 src/bos/usr/sbin/netstart/hosts, cmdnet, bos530 7/24/91 10:00:46
# IBM_PROLOG_BEGIN_TAG
# This is an automatically generated prolog.
#
# bos530 src/bos/usr/sbin/netstart/hosts 1.1
#
# Licensed Materials - Property of IBM
#
# (C) COPYRIGHT International Business Machines Corp. 1985,1989
# All Rights Reserved
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# IBM_PROLOG_END_TAG
#
# COMPONENT_NAME: TCPIP hosts
#
# FUNCTIONS: loopback
#
# ORIGINS: 26 27
#
# (C) COPYRIGHT International Business Machines Corp. 1985, 1989
# All Rights Reserved
# Licensed Materials - Property of IBM
#
# US Government Users Restricted Rights - Use, duplication or
# disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
#
# /etc/hosts
#
# This file contains the hostnames and their address for hosts in the
# network. This file is used to resolve a hostname into an Internet
# address.
#
# At minimum, this file must contain the name and address for each
# device defined for TCP in your /etc/net file. It may also contain
# entries for well-known (reserved) names such as timeserver
# and printserver as well as any other host name and address.
#
"/etc/hosts" 67 lines, 2137 characters
# Internet Address Hostname # Comments
# 192.9.200.1 net0sample # ethernet name/address
# 128.100.0.1 token0sample # token ring name/address
# 10.2.0.2 x25sample # x.25 name/address
127.0.0.1 loopback localhost # loopback (lo0) name/address
172.18.20.100 zydeve
"/etc/hosts" 68 lines, 2158 characters
[root@zydb]/zyhome/oracle/rodman#ping zydeve
PING zydeve: (172.18.20.100): 56 data bytes
64 bytes from 172.18.20.100: icmp_seq=0 ttl=128 time=0 ms
64 bytes from 172.18.20.100: icmp_seq=1 ttl=128 time=0 ms
^C
[root@zydb]/zyhome/oracle/rodman#exportfs -a
[root@zydb]/zyhome/oracle/rodman#showmount -e
zydb: RPC: 1832-019 Program not registered
[root@zydb]/zyhome/oracle/rodman#/usr/sbin/mknfs '-N'
0513-029 The portmap Subsystem is already active.
Multiple instances are not supported.
Starting NFS services:
0513-029 The biod Subsystem is already active.
Multiple instances are not supported.
0513-059 The nfsd Subsystem has been started. Subsystem PID is 733424.
0513-059 The rpc.mountd Subsystem has been started. Subsystem PID is 872588.
0513-029 The rpc.statd Subsystem is already active.
Multiple instances are not supported.
0513-029 The rpc.lockd Subsystem is already active.
Multiple instances are not supported.
Completed NFS services.
[root@zydb]/zyhome/oracle/rodman#showmount -e
export list for zydb:
/zyhome/oracle/rodman zydeve
客户端:172.18.20.100
mkdir -p /dmp
mount 172.18.20.33:/zyhome/oracle/rodman /dmp
chown -R oracle:dba /dmp
导入用完后记得:
umount /dmp
查询shell
[root@zydeve dmp]# env | grep SHELL
SHELL=/bin/bash
写全库导入脚本加入到crontab后台执行
#!/bin/bash
su - oracle -c "
export ORACLE_SID=zydeve
cd /dmp
imp system/netscape buffer=209715200 recordlength=65535 feedback=200000 full=y file=exp_full.dmp log=imp_full.log commit=y
"
设置时间后验证
ps -ef | grep /bin/sh
ps -ef | grep imp
导入用完后记得:
umount /dmp
grep ORA *.log