Directory Control File, Redo Logs, Datafiles e Archived logs, Listener e il Tnsname
I file Control file, Redo Logs e i Datafiles sono posizionati sotto la directory:
[oracle@dbserver1 SALES]$ cd $ORACLE_BASE/oradata/SALES
[oracle@dbserver1 SALES]$ ls -lrt
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:00 controlfile
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:02 onlinelog
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:10 datafile
E' possibile risalire alla stessa informazione con Sql/Plus:
SQL> select NAME , CHECKPOINT_CHANGE# from V$DATAFILE;
NAME CHECKPOINT_CHANGE#
----------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/SALES/datafile/o1_mf_system_8gzv1xpy_.dbf 1031141
/u01/app/oracle/oradata/SALES/datafile/o1_mf_sysaux_8gzv21qg_.dbf 1031141
/u01/app/oracle/oradata/SALES/datafile/o1_mf_undotbs1_8gzv22fm_.db 1031141
Flash Recovery Area è una directory in cui salvare per default i backup su disco e gli Archived logs:
[oracle@dbserver1 ~]$ cd $ORACLE_BASE/flash_recovery_area/SALES
[oracle@dbserver1 SALES]$ ls -lrt
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:01 controlfile
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:02 onlinelog
drwxr-x--- 3 oracle oinstall 4096 Jan 11 03:34 archivelog
Per individuare i file Listener e il Tnsname posizionarsi sotto la directory:
[oracle@dbserver1 ~]$ cd $ORACLE_HOME/network/admin
[oracle@dbserver1 admin]$ ls -lrt
-rw-r--r-- 1 oracle oinstall 309 Jan 10 07:37 listener.ora
-rw-r----- 1 oracle oinstall 365 Jan 11 03:24 tnsnames.ora
[oracle@dbserver1 SALES]$ cd $ORACLE_BASE/oradata/SALES
[oracle@dbserver1 SALES]$ ls -lrt
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:00 controlfile
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:02 onlinelog
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:10 datafile
E' possibile risalire alla stessa informazione con Sql/Plus:
SQL> select NAME , CHECKPOINT_CHANGE# from V$DATAFILE;
NAME CHECKPOINT_CHANGE#
----------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/SALES/datafile/o1_mf_system_8gzv1xpy_.dbf 1031141
/u01/app/oracle/oradata/SALES/datafile/o1_mf_sysaux_8gzv21qg_.dbf 1031141
/u01/app/oracle/oradata/SALES/datafile/o1_mf_undotbs1_8gzv22fm_.db 1031141
Flash Recovery Area è una directory in cui salvare per default i backup su disco e gli Archived logs:
[oracle@dbserver1 ~]$ cd $ORACLE_BASE/flash_recovery_area/SALES
[oracle@dbserver1 SALES]$ ls -lrt
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:01 controlfile
drwxr-x--- 2 oracle oinstall 4096 Jan 11 03:02 onlinelog
drwxr-x--- 3 oracle oinstall 4096 Jan 11 03:34 archivelog
Per individuare i file Listener e il Tnsname posizionarsi sotto la directory:
[oracle@dbserver1 ~]$ cd $ORACLE_HOME/network/admin
[oracle@dbserver1 admin]$ ls -lrt
-rw-r--r-- 1 oracle oinstall 309 Jan 10 07:37 listener.ora
-rw-r----- 1 oracle oinstall 365 Jan 11 03:24 tnsnames.ora