Home » RDBMS Server » Server Administration » DB_RECOVERY_FILE_DEST (Flash Recovery Area)
DB_RECOVERY_FILE_DEST (Flash Recovery Area) [message #235625] Mon, 07 May 2007 08:09 Go to next message
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 #235666 is a reply to message #235625] Mon, 07 May 2007 11:23 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Try:

log_archive_dest_10 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST'
Re: DB_RECOVERY_FILE_DEST (Flash Recovery Area) [message #236337 is a reply to message #235625] Wed, 09 May 2007 11:59 Go to previous message
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
Previous Topic: oracle 9i problem
Next Topic: Trace Files
Goto Forum:
  


Current Time: Tue Dec 06 02:43:22 CST 2016

Total time taken to generate the page: 0.15028 seconds