Oracle Study之案例--Oracle Sqlplus错误
1、查看空间信息$df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 17408.00 1238.15 93% 37699 12% /
/dev/hd2 8192.00 6310.39 23% 46534 4% /usr
/dev/hd9var 2048.00 1725.55 16% 1704 1% /var
/dev/hd3 2048.00 1902.58 8% 420 1% /tmp
/dev/fwdump 3072.00 3071.21 1% 4 1% /var/adm/ras/platform
/dev/hd1 2048.00 1821.98 12% 74 1% /home
/proc - - - - -/proc
/dev/hd10opt 2048.00 1374.77 33% 8934 3% /opt
/dev/lv00 1024.00 991.80 4% 18 1% /var/adm/csd
/dev/arch 10240.00 8347.63 19%
/dev/lv02 15360.0010097.80 35% 123693 4% /u01
2、查看文件权限
$ls -ld /u01/app/oracle/admin/master/
drwxr-x--- 8 oracle dba 512 Feb 17 16:40 /u01/app/oracle/admin/master/
$ls -ld /u01/app/oracle/admin/master/adump/
drwxr-x--- 2 oracle dba 1536 Feb 17 19:48 /u01/app/oracle/admin/master/adump/
3、查看文件系统信息
$cat /etc/filesystems
/u01:
dev = /dev/lv02
vfs = jfs
log = /dev/loglv00
mount = true
options = rw
account = false
#lsvg -l oraclevg
oraclevg:
LV NAME TYPE LPs PPs PVsLV STATE MOUNT POINT
loglv00 jfslog 1 1 1 closed/syncdN/A
lv02 jfs 120 120 1 closed/syncd/u01
#df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 17408.00 1238.18 93% 37700 12% /
/dev/hd2 8192.00 6310.39 23% 46534 4% /usr
/dev/hd9var 2048.00 1725.56 16% 1704 1% /var
/dev/hd3 2048.00 1902.58 8% 420 1% /tmp
/dev/fwdump 3072.00 3071.21 1% 4 1% /var/adm/ras/platform
/dev/hd1 2048.00 1821.98 12% 74 1% /home
/proc - - - - -/proc
/dev/hd10opt 2048.00 1374.77 33% 8934 3% /opt
/dev/lv00 1024.00 991.80 4% 18 1% /var/adm/csd
/dev/arch 10240.00 8347.63 19% 52 1% /arch
/dev/lv01 5120.00 4959.25 4% 16 1% /flash
/dev/lv03 25600.0024796.43 4% 17 1% /home/oracle/arch_master
rhel152:/backup/cuug15/storage3014111.0513052.23 8% 31 1% /backup
mount文件系统失败：
#mount /u01
Replaying log for /dev/lv02.
mount: /dev/lv02 on /u01: Unformatted or incompatible media
The superblock on /dev/lv02 is dirty.Run a full fsck to fix.
修复文件系统：
#fsck -y/dev/lv02
......
** Phase 5 - Check Inode Map
** Phase 6 - Check Block Map
Bad Block Map (SALVAGED)
** Phase 6b - Salvage Block Map
Superblock is marked dirty (FIXED)
123665 files 10749336 blocks 20707944 free
***** Filesystem was modified *****
mount文件系统成功：
#mount /u01
#df -m
Filesystem MB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 17408.00 1238.16 93% 37699 12% /
/dev/hd2 8192.00 6310.39 23% 46534 4% /usr
/dev/hd9var 2048.00 1725.55 16% 1704 1% /var
/dev/hd3 2048.00 1902.58 8% 420 1% /tmp
/dev/fwdump 3072.00 3071.21 1% 4 1% /var/adm/ras/platform
/dev/hd1 2048.00 1821.98 12% 74 1% /home
/proc - - - - -/proc
/dev/hd10opt 2048.00 1374.77 33% 8934 3% /opt
/dev/lv00 1024.00 991.80 4% 18 1% /var/adm/csd
/dev/lv02 15360.0010111.30 35% 123674 4% /u01
执行sqlplus命令成功：
#su - oracle
$sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 17 19:46:03 2015
Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to an idle instance.
SQL>
页:
[1]