asked on

command doubts

alter system set db_recovery_file_dest_size=500m;
system altered

also
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..

ASKER CERTIFIED SOLUTION

mrjoltcola

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nobleit

ASKER

Sir,
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)

Darius Ghassem

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='*';

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/setup005.htm

slightwv (䄆 Netminder)

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

Are you running ASM?
Did you create the diskgroups?

mrjoltcola

>>where how can see physically..

Where how can you see what, physically?

I do not understand the question.

nobleit

ASKER

Sir,

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...