虚拟机增加硬盘以及更改ORACLE DB_RECOVERY_FILE_DEST参数实验(四)

2014-11-24 17:58:59 · 作者: · 浏览: 3
lete a partition
l list known partition types
m print this menu
n add a new partition
o create a new empty DOS partition table
p print the partition table
q quit without saving changes
s create a new empty Sun disklabel
t change a partition's system id
u change display/entry units
v verify the partition table
w write table to disk and exit
x extra functionality (experts only)


Command (m for help): w
The partition table has been altered!


Calling ioctl() to re-read partition table.


WARNING: If you have created or modified any DOS 6.x
partitions, please see the fdisk manual page for additional
information.
Syncing disks.
[root@coop ~]# fdisk -l


Disk /dev/sda: 53.6 GB, 53687091200 bytes
255 heads, 63 sectors/track, 6527 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes


Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 3916 31350847+ 8e Linux LVM


Disk /dev/sdb: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes


Device Boot Start End Blocks Id System
/dev/sdb1 1 2610 20964793+ 8e Linux LVM



[root@coop ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
28G 22G 4.5G 83% /
/dev/sda1 99M 14M 81M 15% /boot
none 506M 0 506M 0% /dev/shm
[root@coop ~]# mkfs.ext3 /dev/sdb1
mke2fs 1.35 (28-Feb-2004)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
2621440 inodes, 5241198 blocks
262059 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=8388608
160 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000


Writing inode tables: done
Creating journal (8192 blocks): done
Writing superblocks and filesystem accounting information: done


This filesystem will be automatically checked every 39 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
[root@coop ~]# mount /dev/sdb1 /u01/arch
[root@coop ~]# df -lh
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
28G 22G 4.5G 83% /
/dev/sda1 99M 14M 81M 15% /boot
none 506M 0 506M 0% /dev/shm
/dev/sdb1 20G 77M 19G 1% /u01/arch


还要更改文件夹权限


[root@coop ~]# chmod 777 /u01/arch
[root@coop ~]# chown -R oracle /u01/arch



2,更改ORACLE 参数


SQL> show parameter db_recover


NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /home/oracle/oracle/product/10
.2.0/db_1/flash_recovery_area
db_recovery_file_dest_size big integer 2G
SQL> alter system set db_recovery_file_dest='/u01/arch/flash_recovery_area' scope=both;


System altered.


SQL> alter system set db_recovery_file_dest_size=10G;


System altered.


3.大功告成


SQL> show parameter db_recover


NAME TYPE VALUE
---------------------