We help IT Professionals succeed at work.

command doubts

nobleit used Ask the Experts™
alter system set db_recovery_file_dest_size=500m;
system altered

alter system set db_recovery_file_dest='+RECOVERYDEST';
system altered

for some reason eventhough it is created I cannot see physically see where it is
can I give like
alter system set db_recovery_file_dest='/u01/fra';
so that I can see where it is ..

can please clarify my doubt..
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2009
+RECOVERYDEST means ASM, so  you would only see it by using the ASM utilities.

Yes, you can change your FRA to /u0/fra (I actually recommend that for simplicity, as in case of a disaster recovery, it ensures you can perform recovery without ASM).


What I am asking is if I add +RECOVERYDEST
where how can see physically..
I understand parameter file is beign modified...

I got failure
while doing that..
like this please help me
RMAN> startup nomount

Oracle instance started

Total System Global Area     608174080 bytes

Fixed Size                     1220844 bytes
Variable Size                171970324 bytes
Database Buffers             432013312 bytes
Redo Buffers                   2969600 bytes

RMAN> restore controlfile from '/u01/app/oracle/oradata/dss10/control01.ctl';

Starting restore at 06-AUG-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/06/2011 13:57:18
ORA-19504: failed to create file "+DATA/ctf1.dbf"
ORA-17502: ksfdcre:3 Failed to create file +DATA/ctf1.dbf
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
ORA-19600: input file is control file  (/u01/app/oracle/oradata/dss10/control01.ctl)
ORA-19601: output file is control file  (+DATA/ctf1.dbf)

Top Expert 2012

You can view physical location of the flash recovery area in this parameter DB_RECOVERY_FILE_DEST

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = '/disk1/flash_recovery_area' SCOPE=BOTH SID='*';

Most Valuable Expert 2012
Distinguished Expert 2018

Error seems self explanatory:
ORA-15001: diskgroup "DATA" does not exist

Are you running ASM?
Did you create the diskgroups?
Top Expert 2009

>>where how can see physically..

Where how can you see what, physically?

I do not understand the question.



I am sorry I did not respond to question for a long time..
Linux server machine I deleted accidently and I could not restore the old machine and purchased new vmware..
All experts and moderators please unblock me ..
Here onward I will be consistent and be maintained well..
Thank you for all suggestions and advices...