³£ÓÃÃüÁî

 ²é¿´È«ÎÄ

¹ØÓÚSAPÈÏÖ¤£¬¸Ð¾õÕæÊǹ󰡡£ ²é¿´È«ÎÄ

SAP Ä£¿éÖÐÎĽâÊÍ ²é¿´È«ÎÄ

SAP R/3 Administration Tasks£¬ÈÕ³£µÄ¹ÜÀí¹¤×÷ÒÔ¼°³£ÓÃÃüÁîµÄ½âÊÍ¡£

 ²é¿´È«ÎÄ

Debugging

truss executable
/* Trace doing of given command ( useful debugging ) */

truss -f -p <pid of a shell>
/* Using multiple windows, this can be used to trace setuid/setgid programs */

Arp, ethernet trouble shooting

arp -a .
/* Shows the ethernet address arp table */

arp -d myhost
/* Delete a stale ethernet entry for host myhost */

Disk Commands
du -k .
/* Reports disk space used in Kilobytes */

du -sk .
/* Reports only total disk space used in Kilobytes */

du -ad /var | sort -nr
/* Tells you how big the /var files are in reverse order */

fdformat -d -U
/* Format diskette */

/usr/bin/iostat -E
/* Command to display drives statistics */

/bin/mount -F hsfs -o ro /dev/sr0 /cdrom
/* Mount an ISO 9660 CDROM */

prtvtoc /dev/rdsk/c0t0d0s2
/* Disk geometry and partitioning info */

quot -af
/* How much space is used by users in kilobytes */

Driver Parameters
ndd /dev/ip ?
/* Shows IP variables in the kernel */

ndd /dev/ip ip_forwarding
/* Tells you if forwarding is on (=1) */

ndd -set /dev/ip ip_forwarding 1
/* Enables IP forwarding between interfaces */

File Manipulation

dos2unix | -ascii <filename>
/* Converts DOS file formats to Unix */

split
/* Split files into pieces */

[vi] : %s/existing/new/g
/* Search and Replace text in vi */

[vi] :set nu
/* Set line numbers in vi */

[vi] :set ts=[num]
/* Set tab stops in vi */

File System

cat /dev/null > filename
/* Zero's out the file without breaking pipe */

dd if=/dev/rdsk/... of=/dev/rdsk/... bs=4096
/* Make a mirror image of your boot disk */

df -k | grep dg| awk '{print $6}' |xargs -n 1 umount
/* Unmount all file systems in disk group dg */

fsck -F ufs /dev/rdsk/c0t0d0s0
/* Check a UFS filesystem on c0t0d0s0 */

fsck -F ufs -y /dev/rdsk/c0t0d0s0
/* Check answering yes to all questions */

fsck -F ufs -o b=97472 /dev/rdsk/c0t0d0s0
/* Check using an alternate super block */

gzip -dc file1.tar.gz | tar xf -
/* Unpack .tar.gz files in place */

ln [-fhns] <source file> <destination file>
/* Creating hard links and soft links */

ls -la | awk '{ print $5," ",$9 }' | sort -rn
/* File sizes of current directory */

mount -f pcfs /dev/dsk/c0d0p1 /export/dos
/* Mount DOS fdisk partition from Solaris */

mount -F ufs -o rw,remount /
/* Used to remount root to make it writeable */

mount -o remount,logging /spare
/* Re-mount the ro file system rw and turn on ufs logging */

tar cvf filename.tar
/* Create a tape (tar) archive */

tar xvf filename.tar
/* Extract a tape (tar) archive */

tar cf - . | (cd /newdir ; tar xf -)
/* Recursively copy files and their permissions */

/sbin/uadmin x x
/* Syncs File Systems and Reboots systems fast */

zcat <patch_file.tar.Z | tar xvf -
/* Extract the patch_file that is a compressed tar file */

File Transfer

put "| tar cf - ." filename.tar
/* Undocumented Feature of FTP */

find . -depth | cpio -pdmv /path/tobe/copied/to
/* Fast alternative to cp -pr */

sendport
/* Transferring large numbers of files within the same ftp control session */

General

/usr/bin/catman -w
/* Create windex databases for man page directories */

mailx -H -u <username>
/* List out mail headers for specified user */

set filec
/* Set file-completion for csh */

Hardware

cfgadm
/* Verify reconfigurable hardware resources */

m64config -prconf
/* Print M64 hardware configuration */
m64config -depth 8|24
/* Sets the screen depth of your M64 graphics accelerator */

m64config -res 'video_mode'
/* Change the resolution of your M64 graphics accelerator */

Kernel

/usr/sbin/modinfo
/* Display kernel module information */

/usr/sbin/modload <module>
/* Load a kernel module */

/usr/sbin/modunload -i <module id>
/* Unload a kernel module */

nm -x /dev/ksyms | grep OBJ | more
/* Tuneable kernel parameters */

/usr/sbin/sysdef
/* Show system kernal tunable details */

Memory
prtconf | grep "Memory size"
/* Display Memory Size */

Network Information

ndd /dev/arp arp_cache_report
/* Prints ARP table in cache with IP and MAC address */

netstat -a | grep EST | wc -l
/* Displays number active established connections to the localhost */

netstat -k hme0
/* Undocumented netstat command */

netstat -i
/* Show the TCP/IP network interfaces */
netstat -np

/* Similar to arp -a without name resolution */

netstat -r
/* Show network route table */

netstat -rn
/* Displays routing information but bypasses hostname lookup. */
netstat -a | more
/* Show the state of all sockets */
traceroute <ipaddress>
/* Follow the route to the ipaddress */

Network/Tuning

ifconfig eth0 mtu 1500
/* Change MTU of interface */

ifconfig eth0 10.1.1.1 netmask 255.255.255.255
/* Add an Interface */

/sbin/ifconfig hme0:1 inet 10.210.xx.xxx netmask 255.255.0.0 broadcast 10.210.xxx.xxx
/* Virtual Interfaces */

/sbin/ifconfig hme0:1 up
/* Bring virtual interface up */

/usr/sbin/ndd -set /dev/hme adv_100fdx_cap 1
/* Nailling to 100Mbps */

ndd -set /dev/ip ip_addrs_per_if 1-8192
/* To set more than 256 virtual ip addresses. */

ndd -set /dev/tcp tcp_xmit_hiwat 65535
/* Increase TCP-transmitbuffers */

ndd -set /dev/tcp tcp_recv_hiwat 65535
/* Increase TCP-receivebuffers */

Processes

fuser -uc /var
/* Processes that are running from /var */

kill -HUP `ps -ef | grep [p]roccess | awk '{print $2}'`
/* HUP any related process in one step */

pfiles <pid>
/* Shows processes' current open files */

pkill -n <name>
/* Kill a process by name */

kill `ps -ef | grep program_name | grep -v grep | cut -f8 -d ' '`
/* pkill for solaris 2.6 */

prstat -a
/* An alternative for top command */
/usr/ucb/ps -aux | more
/* Displays CPU % usage for each process in ascending order */

/usr/ucb/ps -auxww | grep <process name>
/* Gives the full listing of the process (long listing) */

ps -ef | grep -i <string> | awk '{ print $2 }'
/* Creates list of running PID by */

ps -ef | grep -v "0:00" | more
/* Gives you a list of any process with CPU time more than 0:00 */

ps -ef | more
/* Show all processes running */

ps -fu oracle|grep pmon
/* See which instances of Oracle are running */

/usr/proc/bin/ptree <pid>
/* Print the parent/child process 'tree' of a process */

/usr/proc/bin/pwdx <pid>
/* Print the working directory of a process */

top -b 1
/* Returns the process utilizing the most cpu and quits */

Resource Management

/usr/bin/ldd [filename]
/* List the dynamic dependencies of executable files */

/usr/proc/bin/pmap pid
/* Report address space map a process occupies */

Route Configuration

route add net 128.50.0.0 128.50.1.6 1
/* Adds route to 128.50 network via 128.50.1.6 */

route delete net 128.50.0.0 128.50.1.6
/* Deletes route to 128.50 network */

route get [hostname]
/* Which interface will be used to contact hostname */

route monitor
/* Monitors traffic to the routes */

route flush
/* Removes all entries in the route table */

Searching Items

egrep "patterna|patternb" <filename>
/* Search for multiple patterns within the same file */

find . -exec egrep -li "str" {} ;
/* Find a string in files starting cwd */

find / -fstype nfs -prune -o fstype autofs -prune -o -name filename -print
/* Find without traversing NFS mounted file systems */

find . -mtime -1 -type f
/* Find recently modified files */

find / -mtime <# of days>
/* Find files modified during the past # of days */

find . ! -mtime -<days> | /usr/bin/xargs rm -rf
/* Finds and removes files older than <days> specified */

find . -type f -exec grep "<sub-string>" {} ; -print
/* Find files containing <sub-string> within directory tree */

find . -type f -print | xargs grep -i [PATTERN]
/* Recursive grep on files */

find / -user <username>
/* Find all files owned by <username> */

find / | grep [file mask]
/* Fast way to search for files */

find <start_path> -name "<file_name>" -exec rm -rf {} ;
/* Recursively finds files by name and automatically removes them */

find /proc/*/fd -links 0 -type f -size +2000 -ls
/* Find large files held open by a process */

ls -lR | grep <sub_string>
/* Fast alternative to find */

Security

echo 'Please go away' > /etc/nologin
/* Stops users logging in */

find / -perm -0777 -type d -ls
/* Find all your writable directories */
find / -type f -perm -2000 -print
/* Find all SGID files */

find / -type f -perm -4000 -print
/* find all SUID files */

Set Terminal Options

stty erase ^H
/* Sets the Backspace Key to erase */

stty erase ^?
/* Sets the Delete Key to erase */

stty sane
/* Rreset terminal after viewing a binary file. */

tput rmacs
/* Reset to standard char set */

Snoop Your Network

snoop -d pcelx0
/* Watch all network packets on device pcelx0 */

snoop -o /tmp/mylog pcelx0
/* Saves packets from device pcelx0 to a file */

snoop -i /tmp/mylog host1 host2
/* View packets from logfile between host1 & host2 */

snoop -i /tmp/mylog -v -p101
/* Show all info on packet number 101 from a logfile */

snoop -i /tmp/mylog -o /tmp/newlog host1
/* Write a new logfile with all host1 packets */

snoop -s 120
/* Return the first 120 bytes in the packet header */

snoop -v arp
/* Capture arp broadcasts on your network */

Swap File
mkfile -v 10m /export/disk1/myswap
/* Makes a 10 Megabyte swapfile in /export/disk */
mkfile -nv 10m /export/disk1/myswap
/* Makes an empty 10 Megabyte swapfile */

Swap Space
swap -s
/* List the amount of swap space available, also see mkfile */

swap -a /export/disk1/swapfile
/* Add a swapfile */

swap -d /dev/dsk/c0t0d0s4
/* Deletes a swap device */

swap -l
/* List the current swap devices */

System Configuration

/usr/sbin/eeprom auto-boot? false
/* Changes eeprom autoboot? setting without going to Ok prompt */

/usr/sbin/eeprom diag-switch? true
/* Set the system to perform diagnostics on the next reboot. */

/usr/sbin/grpck
/* Check /etc/group file syntax */

/usr/sbin/pwck
/* Check /etc/passwd file syntax */

/usr/sbin/sys-unconfig
/* Clear host specific network configuration information */

System Information and Monitoring

coreadm -e log
/* Report global core */

/bin/echo "0t${stamp}>Yn<Y=Y" | adb
/* Convert UNIX timestamp to something human-readable */

/usr/sbin/eeprom
/* Show eeprom parameters */

grep "-root" /var/adm/sulog | grep -v + | tail -25
/* List most recent attempts to switch to superuser account. */

isainfo -bv
/* Quickly checkout if machine is in 32 or 64 bit mode */

last
/* Tells who was or still is on the system */

logger -i
/* Log the process ID */

/usr/sbin/prtconf -vp
/* Show system configuration details */

/usr/platform/`/bin/uname -i`/sbin/prtdiag -v
/* System Diagnostics */

psrinfo | wc -l
/* Display number of processors */

sar -A <time in sec>
/* Provides cumulative system report. */

sar -a <time in sec>
/* Report use of file access system routines. */

sar -u
/* Report CPU Utilization */

uname -a
/* Displays system information */

vmstat 10
/* Displays summary of what the system is doing every 10 seconds */

ypcat hosts | sort -n -t. +0 -1 +1 -2 +2 -3 +3 -4
/* Take the input of "ypcat hosts" or "cat /etc/inet/hosts" and sort by IP. */

Hope you all remember those useful command !

²é¿´½»»»ÇøÐÅÏ¢£º
lsps -a ÏÔʾ½»»»ÇøµÄ·Ö²¼ÐÅÏ¢
lsps -s ÏÔʾ½»»»ÇøµÄʹÓÃÐÅÏ¢
slibclean Çå³ý´¦Àí³ÌÐòÒÅÁôµÄ¾É·ÖÒ³ÐÅÏ¢
smit mkps ½¨Á¢½»»»Çø¿Õ¼äÐÅÏ¢
swapon -a Æô¶¯ËùÓеķÖÒ³¿Õ¼ä
/etc/swapspaces ´æ·Å·ÖÒ³¿Õ¼ä±í¸ñÐÅÏ¢
-------------------------------------------------
ÏÔʾ¾íÐÅÏ¢£º
lsvg ÏÔʾ¾íµÄÃû³Æ
lsvg -l rootvg ÏÔʾrootvg¾íµÄÏêϸÐÅÏ¢

-------------------------------------------------
mount¾íµÄ·½·¨£º
varyonvg datavg ¼ÓÔØdatavg¾í
mount /dev/data1 ¼ÓÔØdatavgϵÄÒ»¸ödata1¾í

ÂãÉ豸ÀàÐÍ£ºraw,jfs jfs¿ÉÒÔת±ä³ÉÎļþϵͳ£¬¶ørawÔò²»ÐÐ
-------------------------------------------------

ÔÚÂãÉ豸ÉÏ°²×°oracleϵͳ£º
ÐÞ¸ÄÂãÉ豸µÄȨÏÞ£¬ÈçÂãÉ豸ÃûΪsystem01£¬°²×°Êý¾Ý¿âÓû§Îªoracle
chown oracle:dba /dev/system01
chown oracle:dba /dev/rsystem01
ÔÚʹÓÃÎļþʱ±ØÐëÓÃrsystem01
-------------------------------------------------

smit¿ìËÙ·¾¶Ãû³Æ£º(smit£ºÍ¼Ðη½Ê½£¬smitty£º×Ö·û·½Ê½)
dev É豸¹ÜÀí
diag Õï¶Ï
jfs ¶¨ÆÚµµ°¸¹ÜÀíϵͳ
lvm Âß¼­¾í²áϵͳ¹ÜÀíÔ±¹ÜÀí
nfs NFS¹ÜÀí
sinstallp Èí¼þ°²×°¼°Î¬»¤
spooler ÁÐÓ¡¶ÓÁйÜÀí
system ϵͳ¹ÜÀí
tcpip TCP/IP¹ÜÀí
USER ʹÓÃÕß¹ÜÀí
clstart£¬clstop£ºÆô¶¯ºÍÍ£Ö¹cluster
lssrc -g cluser£º²é¿´cluserµÄ״̬
-------------------------------------------------

²é¿´ÒÑ°²×°µÄÈí¼þÐÅÏ¢£º
ls -aF /usr/lpp (lpp:Licensed Program Products)
²é¿´°²×°Ã½ÌåÄÚÈÝ£º
installp -q -d /dev/cdrom -l
-------------------------------------------------

Æô¶¯Ê±×Ô¶¯¼ÓÔØÎļþϵͳÐÅÏ¢£º
ÐèÒª¼ÓÔصÄÐÅÏ¢´æ·ÅÔÚ/etc/filesystems
mount -t nf ¼ÓÔØËùÓÐÔÚ/ect/filesystemsÖж¨Òåtype=nfsµÄÎļþϵͳ
ÏÔʾÒѼÓÔصÄÎļþϵͳ¼°×´Ì¬£º df -v,mount
-------------------------------------------------

²é¿´´íÎóÈÕÖ¾ÐÅÏ¢£º
errpt -a
-------------------------------------------------

ÓйØTCP/IPµÄÃüÁî
Íø·¿¨£º
smit chgenet,chgtok,chgfddi,opschange,mktty:adptr¼Ü¹¹¿ìËÙ·¾¶
smit mkinet,ppp:slipÓëppp¿ìËÙ·¾¶
ifconfig:config½çÃæ
λַ£º
/etc/hosts ¾²Ì¬Ö÷»ú±í
/etc/resolv.conf λַ½âÎöµÄÃû³Æ·þÎñÆ÷
/etc/named.boot Ãû³Æ·þÎñÆ÷¼Ü¹¹
/etc/named.ca ¸ùÃû³Æ·þÎñÆ÷¿ìÈ¡
/etc/named.data λַÁбí
/etc/named.rev ·´×ªÖ¸±êÁбí
nslookup ²éѯÃû³Æ·þÎñÆ÷×ÊѶ
ÍøÂç·ÓÉ£º
route ¹ÜÀí·ÓÉ
netstat -rn Áгö¶¨ÒåµÄ·ÓÉ
routed ·ÓÉ(daekmin rip)
gated ·ÓÉ(daekmin rip¡¢egp¡¢hello)
/etc/gateways ÒÑÖªÍø¹Ø
/etc/networks ÒÑÖªÍø·
·þÎñ£º
/etc/services
/etc/inetd.conf
TCP/IPȺ×é×Óϵͳ:
/etc/rc.net
startsrc -g tcpip Æô¶¯È«²¿µÄtcpip×Óϵͳ 
startsrc -s inetd Æô¶¯Ö÷Òªinternet
³ý´í£º
iptrace Æô¶¯·â°ü×·×Ù
ipreport ×·×Ù½á¹û¸ñʽ»¯Êä³ö
netstat ÍøÂçͳ¼Æ
ping ¼ì²éÊÇ·ñ¿ÉÒÔµ½´ï
²é¿´HACMP£¬ÍⲿӲÅÌÐÅÏ¢:
lscfg -v
lsdev -Cc adapter
¶ÔµÈ»úÆ÷ÐÅÏ¢£º
/etc/.rhosts
/etc/hosts.equiv
/etc/hosts
-------------------------------------------------

¹Û²ì½ø³ÌÄÚ´æʹÓÃÇé¿ö£º
ps aux ¹Û²ì²ÎÊý%mem£ºÄÚ´æʹÓÃ°Ù·Ö±È RSS:ʵ¼ÊʹÓÃÄÚ´æ
vmstat freeµÄµ¥Î»Îª¿é£¬È±Ê¡ÖµÎª4096bytst
-------------------------------------------------

´´½¨rawÉ豸ʱѡÔñµÄÀàÐÍ:
raw_lv 
 
 

´Ó±ðµÄµØ·½¿´À´µÄ£¬¶ÔÓÚ»ù±¾µÄÈÕ³£Î¬»¤Óвο¼¼ÛÖµ£º

1£® ÎļþϵͳÊÇ·ñÂú
·½·¨£º df ¨Ck ¿ÉÒÔÒÔKΪµ¥Î»¼ì²éÎļþϵͳµÄʹÓÃÂÊ¡££¨90%ÒÔÉÏ£¬ÐèÒªµ÷Õû£©
2£® ¼ì²éϵͳ³ö´íÈÕÖ¾ ʹÓÃerrpt |moreÀ´¼ì²é
Çå³ýÏÖÓеÄlog: Errclear 0
3£® ¼ì²éϵͳºÏ·¨/·Ç·¨µÇ½Çé¿ö
ʹÓÃLastÃüÁîÀ´¼ì²éÀ´×ԵǽµÄµØ·½¡£
4£® ¼ì²éϵͳÊÇ·ñÓо޴óµÄCoreÎļþÉú³É
ʹÓà find / -name core ¨CprintÀ´¼ì²é¡£¶ÔCoreÎļþ£¬Ò»°ãÖ±½Óɾ³ý¾Í¿ÉÒÔÁË¡£
5£® ϵͳÐÔÄܼì²é£º
a) CPUÐÔÄÜ£ºÊ¹ÓÃVmstat, topasÀ´¼ì²é
b) ÄÚ´æʹÓÃÇé¿ö£ºÒ²ÊÇʹÓÃtopas, vmstatÀ´¼ì²é
c) ¼ì²éIOƽºâʹÓÃÇé¿ö£ºÊ¹ÓÃiostatÀ´¼ì²é
d) ½»»»¿Õ¼äʹÓÃÇé¿ö£ºÊ¹ÓÃlsps ¨CaÀ´¼ì²é
6£® Mail¼ì²é
7£® Diag Ò»¸öÔÂÒ»´Î

//mhy edit

ϵͳ¹Ø»ú£º
  shutdown +10
  shutdown now
  shutdown -r ÖØÆð
  shutdown -Fr
Çл»µ½µ¥Ä£Ê½£º
   telinit S
   init s
   shutdown -m

²é¿´Óû§ÐÅÏ¢  lsuser -f
¸Ä±äÓû§ÊôÐÔ  chuser ²ÎÊý=.. username

smit ÓÃÓÚͼÐз½Ê½ ,smittyÓÃÓÚÃüÁîÐз½Ê½
ÀýÈçsmitty device
²é¿´Î´¶¨ÒåµÄÉ豸
    lsdev -P |grep  -i other
ɾ³ýÉ豸
    rmdev -l name ´ËÃüÁÉ豸´¦Óڶϵç״̬¡£
    ³¹µ×ɾ³ý
    rmdev -d -l name

set nu -- to display line no
set nonu -- not to display line no
:ÏÂÊäÈëÐкţ¬¿Éµ½´ï¶ÔÓ¦ÐÐ
ÔÚvi½çÃæÏÂʹÓÃÃüÁî
£ £ :%s#/usr/bin#/bin#g
£ £ ¿ÉÒÔ°ÑÎļþÖÐËùÓз¾¶/usr/bin»»³É/bin¡£Ò²¿ÉÒÔʹÓÃÃüÁ
£ £ :%s/usr/bin/bin/g
£ £ ÆäÖС°¡±ÊÇתÒå×Ö·û£¬±íÃ÷ÆäºóµÄ¡°/¡±×Ö·ûÊǾßÓÐʵ¼ÊÒâÒåµÄ×Ö·û£¬²»ÊÇ·Ö¸ô·û¡£
ctrl+u   ÏòÉÏÒƶ¯
ctrl+d   ÏòÏÂÒƶ¯

ÈçºÎͨ¹ýRMAN À´ÔÚÏß¿Ë¡һ¸öRACµÄÊý¾Ý¿âµ½µ¥µãµÄÊý¾Ý¿â¡£
´óÖ²½Ö裺
1¡£Ê×ÏÈ´´½¨Ò»¸örmanÊý¾Ý¿â£¬½¨ÒéʹÓÃcatalog , ÔÚRACÒÔ¼°±»¸´ÖƵķþÎñÆ÷Ö®Í⽨Á¢¡£²¢Ê¹RMANÄܹ»ÓëRACÊý¾Ý¿âÏàÁ¬£¬²¢ÀûÓôËrman³ÌÐòʵÏÖ¶ÔRACÊý¾Ý¿âµÄ±¸·Ý¡£
2¡£½¨Á¢½«¸´ÖƵÄÊý¾Ý¿âµÄʵÀýSID , ¿ÉÒÔ²»ÒªÊý¾ÝÎļþ£¬µ«ÒªÅäÖúÃlistener²¢½«ÆäÆô¶¯£¬½«Êý¾Ý¿âÆô¶¯µ½nomount״̬£¬ÅäÖÃRMAN·þÎñÆ÷£¬Ê¹µÃrman¿ÉÒÔÓ븴ÖÆÊý¾Ý¿âÏàÁ¬¡£
3¡£Æô¶¯rman£¬¾ßÌåÓï·¨²Î¼û£ºrman TARGET SYS/oracle@erptest1 CATALOG rman/rman AUXILIARY SYS/oracle@oraaux
4¡£ÅäÖÃÏà¹ØͨµÀ£¬Óï·¨¿ÉÒԲο¼£ºCONFIGURE CHANNEL DEVICE TYPE disk CLEAR; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 3;
5¡£´´½¨Ò»¸öÊý¾Ý¿â»Ö¸´script¡£±ÈÈ磺dbrec
¾ßÌåÓï·¨¿ÉÒԲμû£ºaa-rman.sqlÎļþ£¬ÕªÂ¼ÈçÏ£º
create script dbrec
{
set until time "to_date('2004/09/26:00:00:00','YYYY/MM/DD:HH24:MI:SS')";
SET NEWNAME FOR DATAFILE 1 TO '/d02/proddata/oravol401';
¡£¡£¡£¡£¡£¡£

set newname for datafile 437 to '/d02/proddata/oravol446';

DUPLICATE TARGET DATABASE TO ORAAUX

LOGFILE GROUP 1 ('/d02/proddata/redo01a.log',

'/d02/proddata/redo01b.log') SIZE 51200K ,

GROUP 2 ('/d02/proddata/redo02a.log',

'/d02/proddata/redo02b.log') SIZE 51200K ,

GROUP 3 ('/d02/proddata/redo03a.log',

'/d02/proddata/redo03b.log') SIZE 51200K ;

}

ÔËÐиûָ´½Å±¾

RMAN> run {execute script dbrec;}

1¡£ÏÈ´òPAatch 3766934

2¡£È»ºó´ò3672076 £¬Õâ¸öpatch±È½ÏÂé·³£¬ÓкܶàÔ¤°²×°patch 3162988£­£­£­£­£­¡·3484474£­£­£­¡·3671463

                                                                      3298423£¬ 3423613£¬3432914£¬3440815£¬3514816£¬3672076

3¡£ÉèÖÃworkflow mail Õâ¸ö²½ÖèÎҾͲ»ËµÁË£¬×¢ÒâÁ½¸öÎļþ¼Ðdiscard ºÍPROCESSÒ»¶¨ÒªÉè¡£

4¡£ÐÞ¸ÄÓû§µÄÊ×Ñ¡Ï½«Í¨Öª¸ñʽÉèÖÃΪplain text mailµÄ¸ñʽ¡£

5¡£ÐÞ¸Äpo Ä£¿éϵÄsetup--->employee---->ÐÞ¸ÄÏà¹ØÈËÔ±µÄmailÉ趨¡£

6¡£ÒÔsysadminÖ°ÔðÔËÐРͬ²½¹¤×÷Á÷(sync%wf%).

7¡£Ìá½»²É¹ºÉêÇ룬Õý³£Çé¿öÏÂÄã¾Í¿ÉÒÔÊÕµ½mailÁË¡£

ÎÊÌâÈÔÓдý½â¾ö¡£

¹þ¹þ£¬¾­¹ý±¾È˲âÊÔ£¬Ä¿Ç°Ã»ÓÐÌرðºÃµÄ·½·¨¡£±ØÐë¹ØµôÒ»¸öʵÀýºÍÒ»¸öÏ̡߳£

¿ÉÒÔͨ¹ý RMANµÄ¸´Öƹ¦ÄÜ£¬ÇáËɽâ¾öÕâ¸öÎÊÌâ¡£