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

最新推荐文章于 2024-04-23 08:15:00 发布

hotye393

最新推荐文章于 2024-04-23 08:15:00 发布

阅读量1.1k

点赞数

分类专栏： ORACLE 管理文章标签： oracle file 虚拟机 dos command table

本文链接：https://blog.csdn.net/hotye393/article/details/6180683

版权

本文介绍了如何在虚拟机中增加硬盘空间，并将其挂载到Oracle数据库的闪回恢复区域，以解决磁盘空间不足的问题。首先，通过虚拟机管理工具增加新的硬盘并格式化为Linux LVM。接着，创建EXT3文件系统并挂载到/u01/arch目录。最后，通过SQL命令更改Oracle的DB_RECOVERY_FILE_DEST参数，将闪回恢复区指向新挂载的硬盘，同时调整其大小为10GB。

摘要由CSDN通过智能技术生成

今天在虚拟机里，发现剩余磁盘空间<10%，总共30G的磁盘，剩下不到2G，如果给ORACLE做一个RMAN全备的话就所剩无几了，于是想在虚拟机里增加一块硬盘，然后格式化，挂载到ORACLE的目录下，然后把ORACLE的 FLASH_RECOVERY_AREA 改过来，步骤如下，

增加硬盘的步骤很简单，先关闭虚拟机，点EDIT =>HARD DISK=>ADD=>CREATE NEW VIRTUAL DISK=>SCSI 等按部就班，搞定后启动vm.

1，[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

Disk /dev/sdb doesn't contain a valid partition table
[root@coop ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

The number of cylinders for this disk is set to 2610.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
   (e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help):
Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2610, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-2610, default 2610):
Using default value 2610

Command (m for help):
Command (m for help): m
Command action
   a   toggle a bootable flag
   b   edit bsd disklabel
   c   toggle the dos compatibility flag
   d   delete 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<