| DB_RECOVERY_FILE_DEST (Flash Recovery Area) [message #235625] |
Mon, 07 May 2007 08:09  |
Muhammad Ahmad
Messages: 30
Registered: November 2002
|
Member |
|
|
Hi,
I set the "DB_RECOVERY_FILE_DEST = /u03/rcvarea",
and "log_archive_dest_10 = 'LOCATION=DB_RECOVERY_FILE_DEST'"
but
Oracle is using "/u01/app/oracle/product/10.1.0/db_1/dbs" as DB_RECOVERY_FILE_DEST.
Why?
The output for your reference is:
[oracle]$ls /u01/app/oracle/product/10.1.0/db_1/dbs/*.dbf
/u01/app/oracle/product/10.1.0/db_1/dbs/DB_RECOVERY_FILE_DEST1_13_621961572.dbf
/u01/app/oracle/product/10.1.0/db_1/dbs/DB_RECOVERY_FILE_DEST1_14_621961572.dbf
/u01/app/oracle/product/10.1.0/db_1/dbs/DB_RECOVERY_FILE_DEST1_15_621961572.dbf
/u01/app/oracle/product/10.1.0/db_1/dbs/DB_RECOVERY_FILE_DEST1_16_621961572.dbf
/u01/app/oracle/product/10.1.0/db_1/dbs/DB_RECOVERY_FILE_DEST1_17_621961572.dbf
SQL> show parameter DB_RECOVERY_FILE_DEST
NAME TYPE VALUE
------------------------------------ ----------- ------
db_recovery_file_dest string /u03/rcvarea
db_recovery_file_dest_size big integer 3G
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination DB_RECOVERY_FILE_DEST
Oldest online log sequence 16
Next log sequence to archive 18
Current log sequence 18
what I am missing?
I have also tried to update "db_create_online_log_dest_3=DB_RECOVERY_FILE_DEST" using alter system command. but it failed.
I want that my Flash recovery area (/u03/rcvarea) holds a complete redundant set of my running DB.
Any suggestions or recommendations will be highly obliged.
Thanking you in anticipation,
Regards,
|
|
|
|
|
|
| Re: DB_RECOVERY_FILE_DEST (Flash Recovery Area) [message #236337 is a reply to message #235625] |
Wed, 09 May 2007 11:59  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
Hi,
I set the "DB_RECOVERY_FILE_DEST = /u03/rcvarea",
and "log_archive_dest_10 = 'LOCATION=DB_RECOVERY_FILE_DEST'"
but
When you set DB_RECOVERY_FILE_DEST parameter then you DON'T NEED TO SET LOG_ARCHIVE_DEST_10 parameter.
it will automatically use LOG_ARCHIVE_DEST_10.
/u01/app/oracle/product/10.1.0/db_1/dbs/
It is use default location when FLASH_RECOVERY_AREA or manually log_archive_dest parameter ( except log_archive_dest) is not set.
Note: 1
When you want to configure flash recovery area you have to set to below parameters
1.db_recovery_file_dest
2.db_recovery_file_dest_size
then all files (1.Archive log file
2.Backup set
3.Autobackup ( control or spfile)) goes to DB_RECOVERY_FILE_DEST parameter location.
Note: 2
When you already configure FLASH_RECOVERY_AREA and you also configure LOG_ARCHIVE_DEST parameter for different location then backup files goes LOG_ARCHIVE_DEST parameter location.
Note: 3
When you are not configure FLASH_RECOVERY_AREA or NOT SET LOG_ARCHIVE_DEST parameter then all files goes (created)
/home/oracle/oracle/product/10.2.0/db_1/dbs/arch
Regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
