]]>
安装步骤
Q．开始安?/FONT>
使用如下命o挂接CDROMQ?/SPAN>
# mount -rv cdrfs /dev/cd0 /cdrom
rootq行 rootpre.sh 脚本?/SPAN>
# /cdrom/rootpre.sh #su - oracle% cd /tmp % /cdrom/runInstaller?/FONT>y
如果事先没有q行rootpre.sh脚本Q会有提C：?/FONT>rootq行rootpre.shQ之后?/FONT>yQ进行正常安装；
会有提示q行orainstRoot.sh脚本Q到linkl束的时候会提示q行root.sh脚本Q按要求完成卛_?/SPAN>
打开一个命令操作窗口（dttermH口Q；
在运?/FONT>runInstaller后会提示?/FONT>rootq行rootpre.shQ之后?/FONT>yQ进行正常安装；
Q．建库
?/FONT>dbca工具建库(ora9)?BR>$dbca
Ҏ提示一步一步徏立数据库?/SPAN>
Q．数据库启动关?/FONT>
Q?/FONT> 数据库的启动Q?/SPAN>
d?/FONT>oracleq行如下命oQ?/SPAN>
#su Q?/FONT> oracle
$export ORACLE_SID=ora9
$ sqlplus /nolog
sql>connect / as sysdba;
sql>startup;
Q?/FONT> 数据库的关闭
d?/FONT>oracleq行如下命oQ?/FONT>
#su Q?/FONT> oracle
$export ORACLE_SID=ora9
$ sqlplus /nolog
sql>connect / as sysdba;
sql>shutdown immediate;
10Q?/FONT>3Q?/FONT> 监听服务的启?/SPAN>
d?/FONT>oracleq行如下命oQ?/SPAN>
$ lsnrctl start ora9
10Q?/FONT>4Q?/FONT> 监听服务的关?/SPAN>
d?/FONT>oracleq行如下命oQ?/SPAN>
$ lsnrctl stop ora9
ｏｋQ！Q！
]]>
安装准备
1Q添?/SPAN>Oracle用户?/SPAN>dbal?/SPAN>
?/FONT>root用户完成下面的操作?/FONT>
doracle用户和组Q?/FONT> 可以用手工命令或"smit security"来完成。创建相关目录，q更改相应权限等?/SPAN>
2Q创Y件安装点
3Q确?/SPAN>Asynchronous Input Output (AIO) 可用
# lsdev -Cc aio
如果输出?/FONT>"Available"则没问题Q如果是"Defined"的话Q通过使用
# smit chaio
?/FONT>"STATE to be configured at system restart"更改?/FONT>"Available"
4Q确?/SPAN>math library已经安装在系l中
bos.adt.base,bos.adt.lib,bos.adt.libm,
bos.perf.perfstat
使用如下命oQ?/SPAN>
# lslpp -l bos.adt.libm
如果没安装的话，你还要用下面的命o安装 bos.adt.libm filesetQ?/SPAN>
# smit install_latest
AIX
# lslpp -l bos.perf.perfstat # lslpp bos.perf.libperfstat
5Q?/SPAN> 安装JDK
6Q设|环境变?/SPAN>
讄以下环境变量?/FONT>oracle用户?/FONT>?profile?/SPAN>文g中：
ORACLE_BASE=/oracle/app; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/
ORACLE_SID=ora9; export ORACLE_SID
ORACLE_TERM=vt100; export ORACLE_TERM
TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN
#NLS_LANG= SIMPLIFIED CHINESE.ZHS16GBK; export NLS_LANG
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib; export LD_LIBRARY_PATH
LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib ;export LIBPATH
ORA_DB=$ORACLE_HOME/dbs;export ORA_DB
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$ORACLE_HOME/JRE/lib:$ORACLE_HOME/JRE/lib/rt.jar:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export CLASSPATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export DISPLAY= 127.0.0.1:0.0
]]>
环境准备
1Q系l资?/SPAN>
· /tmp(或可用做临时I间?/SPAN>Disk)要有 500 MB以上的空?/SPAN>
· 256 MB以上的物理内?/SPAN>
· 臛_两倍物理内存的交换I间
2Q操作系l?/FONT>
· 查看L?/SPAN>
$ uname -a
· 是否64位的操作pȝ:
#bootinfo -y
或?/SPAN>
#bootinfo -K 注意Q因?SPAN lang=EN-US>ORACLE 9I?SPAN lang=EN-US>64位，所以安装的AIXq_也必L64位。如果不是必要重新安装或用连接库函数其改ؓ64?/FONT>
To change to 64 bit multi-processor mode:
# ln -sf /usr/lib/boot/unix_64 /unix
# ln -sf /usr/lib/boot/unix_64 /usr/lib/boot/unix
# bosboot -ad /dev/ipldevice
# shutdown -r?SPAN lang=EN-US>
此外Q?/FONT>AIX上面安装Oracle无需修改核心参数?/SPAN>
3Q安装介?/FONT>
# lsdev -Cc cdrom
cd0 Available 10-60-00-4,
mount CDROM
In the preceding output, /dev/cd0 is the CD-ROM device.
$ cd /ora_data/install
$ mkdir Disk1
$ cd Disk1
$ cp -r /cdrom/* .
]]>
SQL> archive log list;
数据库日志模?nbsp; 存档模式
自动存档 启用
存档l点 d:\oracle\oradata\test\archive
最早的概要日志序列 26
下一个存档日志序?nbsp; 28
当前日志序列 28
ORACLE要在归档模式?BR>Z用户zb
CONNECT zb/zb
Z?BR>CREATE TABLE family
(seq NUMBER(2),
NAME VARCHAR2(14) ,
LOC VARCHAR2(13) ) ;
INSERT INTO family VALUES
(1,'周斌','爸爸');
commit;
SQL> select * from family;
SEQ NAME LOC
---------- -------------- -------------
1 周斌 爸爸
做备份恢复时Q把undo改小一?BR>SQL>CREATE UNDO TABLESPACE undo1
DATAFILE 'D:\oracle\oradata\test\undo01.dbf'
SIZE 6M AUTOEXTEND ON;
SQL>ALTER SYSTEM SET UNDO_TABLESPACE=UNDO1;
SQL>DROP TABLESPACE UNDOTBS1;
commit
shutdown immediate;
冷备?BR>startup;
con sys as sysdba
alter system switch logfile;
产生日志
INSERT INTO zb.family VALUES
(2,'?,'妈妈');
commit;
alter system switch logfile;
INSERT INTO zb.family VALUES
(3,'?,'儿子');
SQL> select * from zb.family;
SEQ NAME LOC
---------- -------------- -------------
1 周斌 爸爸
2 ?nbsp; 妈妈
3 ?nbsp; 儿子
SQL> shutdown abort
3) 此时Q把undo破坏
在‘服务‘中Q将OracleServicetest停止
删除(OS)undo01文g
4) 在‘服务‘中Q将OracleServicetest启动
看警告日志D:\oracle\admin\a00215\bdump\alert_test.log,
Errors in file d:\oracle\admin\test\bdump\test_dbw0_5764.trc:
ORA-01157: cannot identify/lock data file 19 - see DBWR trace file
ORA-01110: data file 19: 'D:\ORACLE\ORADATA\TEST\UNDO01.DBF'
ORA-27041: unable to open file
OSD-04002: 无法打开文g
O/S-Error: (OS 2) pȝ找不到指定的文g?/P>
6) 恢复Q?BR>SQL> SHUTDOWN ABORT
备份的undo01.dbf copy回去
SQL> STARTUP MOUNT
SQL> recover database(或者recover datafile 19//或?recover'D:\ORACLE\ORADATA\test\UNDO01.DBF')
SQL> alter database open;
数据库已更改?/P>
SQL> select * from zb.family;
SEQ NAME LOC
---------- -------------- -------------
1 周斌 爸爸
2 ?nbsp; 妈妈
OK
如果在INSERT后COMMITQ则数据不会丢失
SQL> select * from zb.family;
SEQ NAME LOC
---------- -------------- -------------
1 周斌 爸爸
2?nbsp; 妈妈
3 ?nbsp; 儿子
数据文g一栗?BR>数据文g的丢失和损坏可以恢复到COMMIT的状?/STRONG>
]]>
System Model: IBM,9113-550
Machine Serial Number: 65F2B4E
Processor Type: PowerPC_POWER5
Number Of Processors: 4
Processor Clock Speed: 1656 MHz
CPU Type: 64-bit
Kernel Type: 64-bit
LPAR Info: 1 65-F2B4E
Memory Size: 7808 MB
Good Memory Size: 7808 MB
Platform Firmware level: Not Available
Firmware Version: IBM,SF230_126
Console Login: enable
Auto Restart: true
Full Core: false
Network Information
Host Name: zb
IP Address: 192.168.0.11
Sub Netmask: 255.255.255.0
Gateway: 10.80.1.254
Name Server:
Domain Name:
Paging Space Information
Total Paging Space: 8192MB
Percent Used: 1%
Volume Groups Information
==============================================================================
rootvg:
PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION
hdisk0 active 546 436 109..34..75..109..10
9
hdisk1 active 546 444 109..42..75..109..10
9
==============================================================================
datavg:
PV_NAME PV STATE TOTAL PPs FREE PPs FREE DISTRIBUTION
hdisk2 active 828 819 166..157..165..165..
166
hdisk3 active 799 799 160..160..159..160..
160
==============================================================================
INSTALLED RESOURCE LIST
The following resources are installed on the machine.
+/- = Added or deleted from Resource List.
* = Diagnostic support not available.
Model Architecture: chrp
Model Implementation: Multiple Processor, PCI bus
+ sys0
System Object
+ sysplanar0
System Planar
* vio0
Virtual I/O Bus
* vsa1 U787B.001.DNW419C-P1-T2
LPAR Virtual Serial Adapter
* vty1 U787B.001.DNW419C-P1-T2-L0
Asynchronous Terminal
* vsa0 U787B.001.DNW419C-P1-T1
LPAR Virtual Serial Adapter
* vty0 U787B.001.DNW419C-P1-T1-L0
Asynchronous Terminal
* pci1 U787B.001.DNW419C-P1
PCI Bus
* pci10 U787B.001.DNW419C-P1
PCI Bus
+ fcs1 U787B.001.DNW419C-P1-C1-T1
FC Adapter
* fcnet1 U787B.001.DNW419C-P1-C1-T1
Fibre Channel Network Protocol Device
* fscsi1 U787B.001.DNW419C-P1-C1-T1
FC SCSI I/O Controller Protocol Device
* dac1 U787B.001.DNW419C-P1-C1-T1-W200700A0B818D2C7
1722-600 (600) Disk Array Controller
* pci8 U787B.001.DNW419C-P1
PCI Bus
+ ent0 U787B.001.DNW419C-P1-T9
2-Port 10/100/1000 Base-TX PCI-X Adapter (14108902)
+ ent1 U787B.001.DNW419C-P1-T10
2-Port 10/100/1000 Base-TX PCI-X Adapter (14108902)
* pci9 U787B.001.DNW419C-P1
PCI Bus
+ sisscsia0 U787B.001.DNW419C-P1
PCI-X Dual Channel Ultra320 SCSI Adapter
+ scsi0 U787B.001.DNW419C-P1-T14
PCI-X Dual Channel Ultra320 SCSI Adapter bus
+ rmt0 U787B.001.DNW419C-P1-T14-L0-L0
LVD SCSI 4mm Tape Drive (36000 MB)
+ hdisk0 U787B.001.DNW419C-P1-T14-L5-L0
16 Bit LVD SCSI Disk Drive (73400 MB)
+ hdisk1 U787B.001.DNW419C-P1-T14-L8-L0
16 Bit LVD SCSI Disk Drive (73400 MB)
* ses0 U787B.001.DNW419C-P1-T14-L15-L0
SCSI Enclosure Services Device
+ scsi1 U787B.001.DNW419C-P1-T15
PCI-X Dual Channel Ultra320 SCSI Adapter bus
* pci11 U787B.001.DNW419C-P1
PCI Bus
+ ent2 U787B.001.DNW419C-P1-C2-T1
10/100/1000 Base-TX PCI-X Adapter (14106902)
* pci0 U787B.001.DNW419C-P1
PCI Bus
* pci4 U787B.001.DNW419C-P1
PCI Bus
+ sa0 U787B.001.DNW419C-P1-C3-T1
IBM 8-Port EIA-232/RS-422A (PCI) Adapter
+ tty0 U787B.001.DNW419C-P1-C3-T1-L0
Asynchronous Terminal
* pci2 U787B.001.DNW419C-P1
PCI Bus
+ usbhc0 U787B.001.DNW419C-P1
USB Host Controller (33103500)
+ usbhc1 U787B.001.DNW419C-P1
USB Host Controller (33103500)
* pci3 U787B.001.DNW419C-P1
PCI Bus
* ide0 U787B.001.DNW419C-P1-T16
ATA/IDE Controller Device
+ cd0 U787B.001.DNW419C-P4-D2
IDE DVD-ROM Drive
* pci5 U787B.001.DNW419C-P1
PCI Bus
+ fcs0 U787B.001.DNW419C-P1-C4-T1
FC Adapter
* fcnet0 U787B.001.DNW419C-P1-C4-T1
Fibre Channel Network Protocol Device
* fscsi0 U787B.001.DNW419C-P1-C4-T1
FC SCSI I/O Controller Protocol Device
* dac0 U787B.001.DNW419C-P1-C4-T1-W200600A0B818D2C7
1722-600 (600) Disk Array Controller
* pci6 U787B.001.DNW419C-P1
PCI Bus
PCI Bus
PCI Bus
+ lai0 U787B.001.DNW419C-P1-C5-T1
GXT135P Graphics Adapter
+ L2cache0
L2 Cache
+ mem0
Memory
+ proc0
Processor
+ proc2
Processor
+ proc4
Processor
+ proc6
Processor
* kbd0 U787B.001.DNW419C-P1-L1
USB keyboard
* mouse0 U787B.001.DNW419C-P1-L1
USB mouse
+ hdisk3 U787B.001.DNW419C-P1-C4-T1-W200600A0B818D2C7-L1000000000000
1722-600 (600) Disk Array Device
+ hdisk2 U787B.001.DNW419C-P1-C4-T1-W200600A0B818D2C7-L0
1722-600 (600) Disk Array Device
]]>