Showing posts with label Oracle Database 12c. Show all posts
Setting Up FRA in Oracle Database
To enable the flash recovery area(FRA), you must set the two initialization parameters DB_RECOVERY_FILE_DEST_SIZE (which specifies the disk quota, or maximum space to use for flash recovery area files for this database) and
DB_RECOVERY_FILE_DEST (which specifies the location of the flash recovery area).
Note:
DB_RECOVERY_FILE_DEST (which specifies the location of the flash recovery area).
Note:
- DB_RECOVERY_FILE_DEST_SIZE must be set before DB_RECOVERY_FILE_DEST in parameter file.
- In a RAC database, all instances must have the same values for these parameters
SELECT dest_name, status, destination FROM v$archive_dest;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u02/oracle/fra';
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='*';
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/disk1/flash_recovery_area' SCOPE=BOTH SID='*';
If FRA is ASM Disk Group
--------------------------
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '+disk1' SCOPE=BOTH SID='*';
Startup mount
alter database close;
Alter database archivelog;
alter database open;
archive log list;
10.10.10.73
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 3G SCOPE=BOTH ;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u06/FRA/DCLUATarch' SCOPE=BOTH;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 3G SCOPE=BOTH ;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u06/FRA/dg731122arch' SCOPE=BOTH ;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 3G SCOPE=BOTH ;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u06/FRA/dg731211arch' SCOPE=BOTH;
dg731211
10.10.10.89
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 3G SCOPE=BOTH;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u01/install/EBSUAT/EBSarch' SCOPE=BOTH;
41-RAC
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 3G SCOPE=BOTH SID='*';
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+OCRVFDG' SCOPE=BOTH SID='*';
srvctl stop database -d ORCL
srvctl start database -d ORCL -o mount
alter database archivelog;
srvctl stop database -d ORCL
srvctl start database -d ORCL
10.10.10.74
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 3G SCOPE=BOTH;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u04/ARCH/DG731124' SCOPE=BOTH;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 3G SCOPE=BOTH;
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/u04/ARCH/DG731212' SCOPE=BOTH;
----- 10.10.10.73
Instance FRA_LOCATION SIZE ArchiveLog
--------------------------------------------------------------
DCLUAT /u06/FRA/DCLUAT 3G ENABLED
dg731122 /u06/FRA/dg731122arch 3G ENABLED
dg731211 /u06/FRA/dg731211arch 3G ENABLED
----- 10.10.10.41
Instance FRA_LOCATION SIZE ArchiveLog
-----------------------------------------------------------------
ORCL +OCRVFDG 3G ENABLED
----- 10.10.10.74
Instance FRA_LOCATION SIZE ArchiveLog
--------------------------------------------------------------
DG731124 /u04/ARCH/DG731124 3G ENABLED
DG731212 /u04/ARCH/DG731212 3G ENABLED
Dataguard -1
10.10.10.73 primary db:
10.10.10.74 standby
parallel from 41 have to take backup of EBSUAT in /mnt
shift db in archive log and take rman backup in mount state in location of /mnt
dataguard -2
primary 10.10.10.41
standby 10.10.10.89 db has been dropped.
EBSUAT database env file location : . /u01/app/oracle/product/11.2.0/EBSUAT_rac-node1.env
FILE_NAME
--------------------------------------------------------------------------------
+OCRVFDG/ebsuat/data/system17.dbf.Patch in Oracle Database
Patch is a piece of software or code designed to fix the problems of the existing software. These fixes can be security vulnerability fixes or bug fixes. In certain cases the patches increases or enhances the functionality of the software as well
Interim patch
Interim patches are also known as “one of patches”. Interim patches are released in between the release of CPU or PSU patch to fix a specific issue. These patches generally address specific bug’s fixes for a specific customer and should not be applied unless specified by Oracle support services.
Diagnostic patch
It’s a type of interim patch used for the diagnosis of a specific issue. As the name indicates this patches doesn’t fix an issue but helps us to understand an issue it is mostly used by Oracle support services.
Bundle patch
It’s a cumulative patch issued between patch set bundles. patches normally include only fixes but sometimes they include minor enhancements as well. Example Windows bundle patch
Critical patch update (CPU)
These are the cumulative patches consisting of security fixes. The new name for the critical patch updates is security patch update. CPU or SPU provide the security fixes for a single product eg: Oracle Database 11.2.0.1. These patches are cumulative for the same product or a component For example Oracle database 11.2.0.1
Critical patch updates or CPUs are released on quarterly basis.
Mostly they are released on the third week of January, April, July and October.
Subscribe to:
Posts
(
Atom
)
