This discussion is archived
1 Reply Latest reply: Oct 8, 2012 8:10 AM by Levi-Pereira RSS

where are  tablespace, table structure, package physically stored?

scottjhn Newbie
Currently Being Moderated
Running Oracle 11g on Linux.

My disk settings are:

/dev/sda1 (boot)
/dev/sda2 (/)
/dev/sda3 (/u01) for Oracle software. Base: /u01/app/oracle
/dev/sda4 (swap)

/dev/sdb1 ASM disk for DATA
/dev/sdc1 ASM disk for DATA
/dev/sdd1 ASM disk for FRA


1. Where are the tablespace, table structure (such as table name, column name, column type, primarykey key, and index), package, procedure, trigger, and function PHYSICALLY stored? I want to know the common directory path and disk location?

2. When the Fast Recovery Area (FRA) does the backup job, will the tablespace, table structure (column, type, key, index), package, procedure, trigger, and function also be backed up to the Fast Recovery Area (FRA), in addition to the data files, control files, redo logs and archived logs?



Thanks
  • 1. Re: where are  tablespace, table structure, package physically stored?
    Levi-Pereira Guru
    Currently Being Moderated
    You need understand the difference and concept about Physical Storage Structures and Logical Storage Structures.

    http://docs.oracle.com/cd/E11882_01/server.112/e16508/physical.htm

    http://docs.oracle.com/cd/E11882_01/server.112/e16508/logical.htm
    /dev/sdb1 ASM disk for DATA
    /dev/sdc1 ASM disk for DATA
    /dev/sdd1 ASM disk for FRA
    1. Where are the tablespace, table structure (such as table name, column name, column type, primarykey key, and index), package, procedure, trigger, and function PHYSICALLY stored? I want to know the common directory path and disk location?
    Probably your database is stored on ASM Filesystem, wich are using the /dev/sdb1 and /dev/sdc1. So if your database files is on ASM "DATA" diskgroup then all objects is there.

    Query V$DATAFILE, V$CONTROLFILE, V$LOGFILE, V$TEMPFILE
    2. When the Fast Recovery Area (FRA) does the backup job, will the tablespace, table structure (column, type, key, index), package, procedure, trigger, and function also be backed up to the Fast Recovery Area (FRA), in addition to the data files, control files, redo logs and archived logs?
    FRA is used to hold backups of database then your objects are backed up there too.

    Use RMAN to check it:

    LIST BACKUP;

    LIST ARCHIVELOG ALL;


    Edited by: Levi Pereira on Oct 8, 2012 12:05 PM

    Edited by: Levi Pereira on Oct 8, 2012 12:09 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points