This content has been marked as final. Show 1 reply
You need understand the difference and concept about Physical Storage Structures and Logical Storage Structures.
/dev/sdb1 ASM disk for DATAProbably 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.
/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?
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 ARCHIVELOG ALL;
Edited by: Levi Pereira on Oct 8, 2012 12:05 PM
Edited by: Levi Pereira on Oct 8, 2012 12:09 PM