Add a hard disk to the VM and change the ORACLEDB_RECOVERY_FILE_DEST Parameter Experiment

Today, in the virtual machine, we found that the remaining disk space is less than 10%, a total of 30 GB of disk space, less than 2 GB. If we create an RMAN full backup for ORACLE, there will be little left, so I want

Today, in the virtual machine, we found that the remaining disk space is less than 10%, a total of 30 GB of disk space, less than 2 GB. If we create an RMAN full backup for ORACLE, there will be little left, so I want

Today, in the virtual machine, we found that the remaining disk space is less than 2 GB for a total of 30 GB disks. If we create an RMAN full backup for Oracle, there will be little left, so I want to add a hard disk to the virtual machine, format it, mount it to the ORACLE directory, and change FLASH_RECOVERY_AREA of ORACLE. The steps are as follows,

The process of adding a hard disk is very simple. First shut down the VIRTUAL Machine and click EDIT => hard disk => ADD => create new virtual disk => SCSI and so on. After that, start the 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 coshould in certain setups cause problems:
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
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): t
Selected partition 1
Hex code (type L to list codes): l

0 Empty 1e Hidden W95 FAT1 80 Old Minix c1 DRDOS/sec (FAT-
1 FAT12 24 nec dos 81 Minix/old Lin c4 DRDOS/sec (FAT-
2 XENIX root 39 Plan 9 82 Linux swap c6 DRDOS/sec (FAT-
3 XENIX usr 3c PartitionMagic 83 Linux c7 syr.pdf
4 FAT16 <32 M 40 Venix 80286 84 OS/2 hidden C: da Non-FS data
5 Extended 41 PPC PReP Boot 85 Linux extended db CP/M/CTOS /.
6 FAT16 42 SFS 86 NTFS volume set de Dell Utility
7 HPFS/NTFS 4d QNX4.x 87 NTFS volume set df BootIt
8 AIX 4e QNX4.x 2nd part 8e Linux LVM e1 DOS access
9 AIX bootable 4f QNX4.x 3rd part 93 Amoeba e3 dos r/O
A OS/2 Boot Manag 50 OnTrack DM 94 Amoeba BBT e4 SpeedStor
B W95 FAT32 51 OnTrack DM6 Aux 9f BSD/OS eb BeOS fs
C W95 FAT32 (LBA) 52 CP/M a0 IBM Thinkpad hi ee EFI GPT
E W95 FAT16 (LBA) 53 OnTrack DM6 Aux a5 FreeBSD ef EFI (FAT-12/16/
F W95 Ext 'd (LBA) 54 OnTrackDM6 a6 OpenBSD f0 Linux/PA-RISC B
10 OPUS 55 EZ-Drive a7 NeXTSTEP f1 SpeedStor
11 Hidden FAT12 56 Golden Bow a8 Darwin UFS f4 SpeedStor
12 Compaq diagnost 5c Priam Edisk a9 NetBSD f2 DOS secondary
14 Hidden FAT16 <3 61 SpeedStor AB Darwin boot fb VMware VMFS
16 Hidden FAT16 63 gnu hurd or Sys b7 BSDI fs fc VMware VMKCORE
17 Hidden HPFS/NTF 64 Novell Netware b8 BSDI swap fd Linux raid auto
18 AST SmartSleep 65 Novell Netware bb Boot Wizard hid fe LANstep
1b Hidden W95 FAT3 70 DiskSecure Mult be Solaris boot ff BBT
1c Hidden W95 FAT3 75 PC/IX bf Solaris
Hex code (type L to list codes): B
Changed system type of partition 1 to B (W95 FAT32)

Command (m for help): p

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 + B W95 FAT32

Command (m for help): p

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 + B W95 FAT32

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
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): t
Selected partition 1
Hex code (type L to list codes): l

0 Empty 1e Hidden W95 FAT1 80 Old Minix c1 DRDOS/sec (FAT-
1 FAT12 24 nec dos 81 Minix/old Lin c4 DRDOS/sec (FAT-
2 XENIX root 39 Plan 9 82 Linux swap c6 DRDOS/sec (FAT-
3 XENIX usr 3c PartitionMagic 83 Linux c7 syr.pdf
4 FAT16 <32 M 40 Venix 80286 84 OS/2 hidden C: da Non-FS data
5 Extended 41 PPC PReP Boot 85 Linux extended db CP/M/CTOS /.
6 FAT16 42 SFS 86 NTFS volume set de Dell Utility
7 HPFS/NTFS 4d QNX4.x 87 NTFS volume set df BootIt
8 AIX 4e QNX4.x 2nd part 8e Linux LVM e1 DOS access
9 AIX bootable 4f QNX4.x 3rd part 93 Amoeba e3 dos r/O
A OS/2 Boot Manag 50 OnTrack DM 94 Amoeba BBT e4 SpeedStor
B W95 FAT32 51 OnTrack DM6 Aux 9f BSD/OS eb BeOS fs
C W95 FAT32 (LBA) 52 CP/M a0 IBM Thinkpad hi ee EFI GPT
E W95 FAT16 (LBA) 53 OnTrack DM6 Aux a5 FreeBSD ef EFI (FAT-12/16/
F W95 Ext 'd (LBA) 54 OnTrackDM6 a6 OpenBSD f0 Linux/PA-RISC B
10 OPUS 55 EZ-Drive a7 NeXTSTEP f1 SpeedStor
11 Hidden FAT12 56 Golden Bow a8 Darwin UFS f4 SpeedStor
12 Compaq diagnost 5c Priam Edisk a9 NetBSD f2 DOS secondary
14 Hidden FAT16 <3 61 SpeedStor AB Darwin boot fb VMware VMFS
16 Hidden FAT16 63 gnu hurd or Sys b7 BSDI fs fc VMware VMKCORE
17 Hidden HPFS/NTF 64 Novell Netware b8 BSDI swap fd Linux raid auto
18 AST SmartSleep 65 Novell Netware bb Boot Wizard hid fe LANstep
1b Hidden W95 FAT3 70 DiskSecure Mult be Solaris boot ff BBT
1c Hidden W95 FAT3 75 PC/IX bf Solaris
Hex code (type L to list codes): 8e
Changed system type of partition 1 to 8e (Linux LVM)

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
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 99 M 14 M 81 M 15%/boot
None 506 M 0 506 M 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,983 04, 163840,229 376, 294912,819 200, 884736,160 5632, 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 99 M 14 M 81 M 15%/boot
None 506 M 0 506 M 0%/dev/shm
/Dev/sdb1 20G 77 M 19G 1%/u01/arch

You also need to change the folder permission.

[Root @ coop ~] # Chmod 777/u01/arch
[Root @ coop ~] # Chown-R oracle/u01/arch

2. Change ORACLE Parameters

SQL> show parameter db_recover

NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_recovery_file_dest string/home/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. Success

SQL> show parameter db_recover

NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_recovery_file_dest string/u01/arch/flash_recovery_area
Db_recovery_file_dest_size big integer 10G