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.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment