We help IT Professionals succeed at work.

asm

nobleit
nobleit used Ask the Experts™
on
after single instace to asm creation
I am expected to see the output of
SQL> select tablespace_name,file_name from dba_data_files;

+DATA in the output , I am not seeing that..
can you clarify


SQL> startup nomount pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/inityank.ora';
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
SQL> create spfile from pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/inityank.ora';

File created.

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> alter system set db_recovery_file_dest_size=500m;
alter system set db_recovery_file_dest_size=500m
*
ERROR at line 1:
ORA-01034: ORACLE not available


SQL> startup
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
Database mounted.
Database opened.
SQL> alter system set db_recovery_file_dest_size=500m;

System altered.

SQL> alter system set db_recovery_file_dest='+RECOVERYDEST';

System altered.

SQL> alter system set db_create_file_dest='/u01/app/+DATA';

System altered.

SQL> alter system set control_files='/u01/new/ctf1.dbf' scope=spfile;

System altered.

SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac5 udump]$ ./rman target /
bash: ./rman: No such file or directory
[oracle@rac5 udump]$ cd $ORACLE_HOME/dbs
[oracle@rac5 dbs]$ ls
alert_zzz.log   hc_zzz.dat        initzzz.ora   orapwyank
cntrlTSH1.dbf   initclone1.ora    initzzz.ora~  pwdclone1
Desktop         initclonedb.ora   lkCLONE1      PWDzzz.ora
hc_clone1.dat   initclonedb.ora~  lkDUMMY       spfileclonedb.ora
hc_clonedb.dat  initdw.ora        lkOLTP10      spfileoltp10.ora
hc_oltp10.dat   init.ora          lkWELLS       spfileyank.ora
hc_TSH1.dat     initwells.ora     lkYANK
hc_wells.dat    initwells.ora~    orapwoltp10
hc_yank.dat     inityank.ora      orapwwells
[oracle@rac5 dbs]$ cd ..
[oracle@rac5 db_1]$ cd bin
[oracle@rac5 bin]$ ./rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 8 17:40:25 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database (not started)

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/yank/control01.ctl';


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

channel ORA_DISK_1: copied control file copy
output filename=/u01/new/ctf1.dbf
Finished restore at 08-AUG-11

RMAN>
RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> backup as copy database format '/u01/app/+DATA';

Starting backup at 08-AUG-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u01/app/oracle/oradata/yank/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/08/2011 17:42:21
ORA-19504: failed to create file "/u01/app/+DATA"
ORA-27038: created file already exists
Additional information: 1

RMAN> backup as copy database format '/u01/app/+DATA/backup_%s_%t';


Starting backup at 08-AUG-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u01/app/oracle/oradata/yank/system01.dbf
output filename=/u01/app/+DATA/backup_2_758655861 tag=TAG20110808T174421 recid=1 stamp=758655937
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:18
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u01/app/oracle/oradata/yank/sysaux01.dbf
output filename=/u01/app/+DATA/backup_3_758655939 tag=TAG20110808T174421 recid=2 stamp=758655975
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u01/app/oracle/oradata/yank/undotbs01.dbf
output filename=/u01/app/+DATA/backup_4_758655984 tag=TAG20110808T174421 recid=3 stamp=758655987
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u01/app/oracle/oradata/yank/users01.dbf
output filename=/u01/app/+DATA/backup_5_758655992 tag=TAG20110808T174421 recid=4 stamp=758655993
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
output filename=/u01/app/+DATA/backup_6_758655993 tag=TAG20110808T174421 recid=5 stamp=758655994
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-AUG-11
channel ORA_DISK_1: finished piece 1 at 08-AUG-11
piece handle=/u01/app/+DATA/backup_7_758655997 tag=TAG20110808T174421 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-AUG-11

RMAN>
RMAN> alter database open;

database opened

RMAN> exit


Recovery Manager complete.
[oracle@rac5 bin]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 8 17:47:22 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> select tablespace_name,file_name from dba_data_files;


TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
USERS
/u01/app/oracle/oradata/yank/users01.dbf

SYSAUX
/u01/app/oracle/oradata/yank/sysaux01.dbf

UNDOTBS1
/u01/app/oracle/oradata/yank/undotbs01.dbf


TABLESPACE_NAME
------------------------------
FILE_NAME
--------------------------------------------------------------------------------
SYSTEM
/u01/app/oracle/oradata/yank/system01.dbf


SQL> SQL>

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>USERS. /u01/app/oracle/oradata/yank/users01.dbf

You are not running ASM if these are your data files.

ASM is giving Oracle RAW disk and it manages it.  What you posted is showing cooked/mounted file systems.

I believe I mentioned this in one of your previous questions.  Just adding a '+' does not make it ASM.
Top Expert 2008
Commented:
To see all files you have access use the view dba_files.
These are the only files you can use in the DB.
You can not use in the file names '+' - only letters, numbers and  _ $    (Oracle discourages usinge of $).
Investigate the file system and use correct file names.

Author

Commented:
but

SQL> desc dba_files
ERROR:
ORA-04043: object dba_files does not exist


SQL> desc dba_files;
ERROR:
ORA-04043: object dba_files does not exist


SQL>

does not exists..
Top Expert 2009

Commented:
That was a typo, I believe he meant dba_data_files.  Cheers.
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
Also,
We have already covered the issue. Looking in different view won't help.