Database Administration (MOSC)

MOSC Banner

Flashback logs in the wrong place

edited Apr 19, 2016 5:05AM in Database Administration (MOSC) 7 commentsAnswered

Oracle RDBMS 12.1.0.2

I have 3 RAID-10 ASM Diskgroups, called ASM_FAST_1, ASM_FAST_2 and ASM_FRA. 

ASM_FAST_1 and ASM_FAST_2 are meant to have control file copies, Online Redo Logs, UNDO and TEMP (mix these up).  ASM_FRA is mean to have archive logs and flashback logs.  (Our RMAN Backups go elsewhere). 

The flashback logs are going to the wrong place, but I don't know why !

db_recovery_file_dest +ASM_FRA

db_recovery_file_dest_size 600G

db_create_online_log_dest_1 is ASM_FAST_1

db_create_online_log_dest_2 is ASM_FAST_2


The online redo logs are in the right place, the archive logs are in ASM_FRA, but the flashback logs are going to ASM_FAST_1.

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