Database - RAC/Scalability (MOSC)

MOSC Banner

How reference datafile path on ASM Oracle 12c ?

edited Dec 16, 2015 10:05AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

Hello

I'm migrating from Oracle 11.1.0.7 (RAC 2 nodes) on ASM to Oracle 12.1.0.2.0 (RAC 2 nodes) on ASM by ODA X5-2.

Now (on old platafform) , when I create a Tablespace use the next command

CREATE TABLESPACE CAUX_DAT DATAFILE '+DATA' SIZE 1069248K AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED

LOGGING

ONLINE

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

BLOCKSIZE 8K

SEGMENT SPACE MANAGEMENT AUTO

FLASHBACK ON;

and obtain '+DATA/vraea/datafile/caux_dat.278.784055497' as the  phisical path for the datafile on ASM structure.

How use the CREATE TABLESPACE command to obtain the actual reference to phisicall path ?

Example of path on new plattaform is :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center