Search This Blog

Thursday, April 5, 2007

FRA_Configure

Database : 10.2.0.1.0
OS : Linux
Archive Log : ENABLE


[oracle@alwarid-taj ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 5 16:43:36 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10



Note : for flash_recovery_area two PARAMETER must be configure.


1.db_recovery_file_dest
2.db_recovery_file_dest_size

Example :
SQL> show parameter recovery

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 5G

My Database already configure for flash_recovery_area now i am disable flash_recovery_area.

SQL> alter system set db_recovery_file_dest = ' ' ;

System altered.

SQL> alter system set db_recovery_file_dest_size = 1;

System altered.



SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/oracle/product/10.2.0/db_1/dbs/arch
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10




Note : All Archvie log file generate above "archive destination" but if you configure
"LOG_ARCHIVE_DEST_1" then all archive log create in specified parameter.


SQL> alter system set log_archive_dest_1 = 'LOCATION=/home/oracle/ARC_ORACLE';

System altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/ARC_ORACLE
Oldest online log sequence 8
Next log sequence to archive 10
Current log sequence 10






Note : FLASH_RECOVERY_AREA used for store backup file.
like
1.Archive log file
2.Backup set
3.Autobackup ( control or spfile)

When we disable FLASH_RECOVERY_AREA then all backup file goes to below location.

RMAN> run
2> {
3> backup database;
4> backup archivelog all;
5> }
[output cut]
input datafile fno=00001 name=/home/oracle/oracle/product/10.2.0/db_1/oradata/or acle/system01.dbf
[output cut]
piece handle=/home/oracle/oracle/product/10.2.0/db_1/dbs/01iedvvl_1_1 tag=TAG20070405T172300 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
Finished backup at 05-APR-07
[output cut]
input archive log thread=1 sequence=8 recid=1 stamp=617743462
[output cut]
piece handle=/home/oracle/oracle/product/10.2.0/db_1/dbs/02iee022_1_1 tag=TAG20070405T172417 comment=NONE

Starting Control File and SPFILE Autobackup at 05-APR-07
piece handle=/home/oracle/oracle/product/10.2.0/db_1/dbs/c-1488579947-20070405-00 comment=NONE


[output cut]

No comments: