ASM QUICK REF‎ > ‎

ORA-15001: diskgroup "TDB1_FLASH" does not exist or is not mounted

posted Apr 8, 2011, 1:03 AM by Sachchida Ojha
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/08/2011 02:16:15
ORA-19504: failed to create file "+TDB1_FLASH"
ORA-15001: diskgroup "TDB1_FLASH" does not exist or is not mounted


SYS@STGTDB1  SQL>show parameter recove

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +TDB1_FLASH
db_recovery_file_dest_size           big integer 328G
recovery_parallelism                 integer     4
SYS@STGTDB1  SQL>alter system set db_recovery_file_dest_size=100G;

System altered.

SYS@STGTDB1  SQL>>alter system set db_recovery_file_dest=+TDB1_FRA;
SP2-0734: unknown command beginning ">alter sys..." - rest of line ignored.
SYS@STGTDB1  SQL>alter system set db_recovery_file_dest=+TDB1_FRA;
alter system set db_recovery_file_dest=+TDB1_FRA
                                        *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SYS@STGTDB1  SQL>alter system set db_recovery_file_dest='+TDB1_FRA';

System altered.

SYS@STGTDB1  SQL>show parameter FLASH

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flash_cache_file                  string
db_flash_cache_size                  big integer 0
db_flashback_retention_target        integer     1440
SYS@STGTDB1  SQL>show parameter recove

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +TDB1_FRA
db_recovery_file_dest_size           big integer 100G
recovery_parallelism                 integer     4
SYS@STGTDB1  SQL>alter system set db_recovery_file_dest_size=100G scope=spfile;

System altered.

SYS@STGTDB1  SQL>alter system set db_recovery_file_dest='+TDB1_FRA' scope=spfile;

System altered.

SYS@STGTDB1  SQL>create pfile from spfile;

File created.

SYS@STGTDB1  SQL>shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@STGTDB1  SQL>
SYS@STGTDB1  SQL>startup ;
ORACLE instance started.

Total System Global Area 5344731136 bytes
Fixed Size                  2216200 bytes
Variable Size            4244639480 bytes
Database Buffers         1073741824 bytes
Redo Buffers               24133632 bytes
Database mounted.
Database opened.
SYS@STGTDB1  SQL>alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST' scope=spfile;

System altered.

SYS@STGTDB1  SQL>create pfile from spfile;

File created.

SYS@STGTDB1  SQL>quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
you have mail in /usr/spool/mail/oracle
va-iperf01:STGTDB1:/u01/ARBPRDDB/home/oracle>
va-iperf01:STGTDB1:/u01/ARBPRDDB/home/oracle>
va-iperf01:STGTDB1:/u01/ARBPRDDB/home/oracle>
va-iperf01:STGTDB1:/u01/ARBPRDDB/home/oracle>rman target / catalog rman/rman@rman

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Apr 8 08:02:05 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: STGTDB1 (DBID=2538883184)
connected to recovery catalog database

RMAN>

Comments