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:
Post a Comment