Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2004
    Posts
    128

    Unanswered: Where are my data files?

    Oracle 10g R2
    RHEL 4

    Greetings. I have read this doc:

    http://download-west.oracle.com/docs...b.htm#CACDJBBF

    but it fails to tell me where my data files are stored. In Enterprise Manager it shows that the are in thr +My_DG2/.... folder, but Im not sure where exactly that is as the file +My_DG2 doesn't exist, at least not where I can find. Can someone please assist?

    TIA, cfr

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Select File_name From Dba_data_files;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2004
    Posts
    128
    Thanks, but that points me back to +My_DG2 which I am unable to find.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >that points me back to +My_DG2 which I am unable to find.
    Sounds to me like PEBKAC.
    The fact that you could execute the SQL & get a response indicates Oracle is up & available; which implies the "missing" datafiles exist.
    If you can't find them, maybe you should turn the keyboard to some one else.

    A challenge for folks who might be able to assist you, is that you make it really, really difficult by describing what you think is happening rather than using CUT & PASTE so we can see for ourselves what really is happening.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Nov 2004
    Posts
    128
    Quote Originally Posted by anacedent
    >that points me back to +My_DG2 which I am unable to find.
    Sounds to me like PEBKAC.
    The fact that you could execute the SQL & get a response indicates Oracle is up & available; which implies the "missing" datafiles exist.
    If you can't find them, maybe you should turn the keyboard to some one else.

    A challenge for folks who might be able to assist you, is that you make it really, really difficult by describing what you think is happening rather than using CUT & PASTE so we can see for ourselves what really is happening.
    I forget exactly what PEBKAC stands for, but I do know it's not as good as PICNIC. I do of course realize that Oracle responding to a query means that it's up and running, but thanks. I never claimed my files were "missing", I said I couldn't find them. My turning the keyboard over to someone else would mean my learning would stop, which is my primary goal.

    I run this query:

    select file_name from dba_data_files

    And I get back this result set:

    +MY_DG2/racdb/datafile/users.259.562151249
    +MY_DG2/racdb/datafile/sysaux.257.562151243
    +MY_DG2/racdb/datafile/undotbs1.258.562151247
    +MY_DG2/racdb/datafile/system.256.562151237
    +MY_DG2/racdb/datafile/example.265.562151495
    +MY_DG2/racdb/datafile/undotbs2.267.562154137
    +MY_DG2/racdb/datafile/flow_1.271.562196855
    +MY_DG2/racdb/datafile/soe.272.562263577

    Now this seems to look just like what I "think is happening" as you put it, but since you asked to see it I do feel a sense of obligation to provide it. Does this help in any way? Did my newbie eyes mis-percieve me and it doesn't really say "+MY_DG2" as I had indicated?

    Please forgive the sarcasim, but I am only returning it as you have dealt it in my last couple of posts.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    As user root do the following:
    $ find / -name system.256.562151237 -ls
    & post the results.
    It appears that this Oracle installation was done without regard to OFA convention & similar file naming "standards".
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Mar 2007
    Posts
    623
    Hi,

    it seems to me you are using ASM for your datafiles. Query the views listed here (eg. V$ASM_FILE view).

    If they are not empty, then you cannot see your data files from OS directly, as they are managed by Oracle. Access to them is possible through ASMCMD utility.

  8. #8
    Join Date
    Nov 2004
    Posts
    128
    Quote Originally Posted by anacedent
    As user root do the following:
    $ find / -name system.256.562151237 -ls
    & post the results.
    It appears that this Oracle installation was done without regard to OFA convention & similar file naming "standards".
    I get thousands of results.

  9. #9
    Join Date
    Nov 2004
    Posts
    128
    Quote Originally Posted by flyboy
    Hi,

    it seems to me you are using ASM for your datafiles. Query the views listed here (eg. V$ASM_FILE view).

    If they are not empty, then you cannot see your data files from OS directly, as they are managed by Oracle. Access to them is possible through ASMCMD utility.
    Thanks. Some are empty, some are not. However, I don't think Im using ASM as when I type "asmcmd" at the command prompt I get "command disallowed for current instance type".

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •