Cannot Add Asm Directory As Flashback Area Error reported ORA-01261

(Doc ID 329899.1)

Last updated on DECEMBER 29, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2011 ***


Goal

Is there some restriction on how ASM can be used with the Flash Recovery Area (FRA)?

From Chapter 2 of the Oracle® Database Administrator's Guide, 10g Release 1 (10.1):

    "Specifying a Flash Recovery Area
    A flash recovery area is a location in which Oracle Database can store and manage files related to
    backup and recovery. It is distinct from the database area, which is a location for the
    Oracle-managed current database files (datafiles, control files, and online redo logs).
   
    You specify a flash recovery area with the following initialization parameters:
   
    DB_RECOVERY_FILE_DEST: Location of the flash recovery area. This can be a directory, file system,
    or Automatic Storage Management (ASM) disk group. It cannot be a raw file system."

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms