Database Administration (MOSC)

MOSC Banner

No Standby Database - Do I need log_archive_dest_1 ?

edited Sep 27, 2010 11:54PM in Database Administration (MOSC) 3 commentsAnswered
 Sorry, novice question, but I recently setup an 11g enterprise database for developer testing. I am running in ArchiveLog mode and perform weekly Full backups. The flashback feature is also enabled and log_archive_dest_10 is set to LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300. I "currently" have no need for a "Standby" database. In 10g, I was able to write the archive log files to a Network Storage Appliance by using archive log destinations using UNC / Windows naming conventions (e.g. \\server\share). It appears that this is no longer allowed in 11g? I have set log_archive_dest_1 and 2 to "LOCATION"s on the server's physical drives, but isn't this a performance issue? I'm running RAID-5 (Sorry, no choice for now). If this is indeed not necessary to use dest_1 and dest_2 (in my scenario), then how do I reset them back to null and effectively disable writing files to those folders? I am assuming that the logs would still be written to the flashback area, and that backups and any needed recovery would still work correctly without dest_1 and dest_2? Help and

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center