Where are the places to check this issue. Please help any one on this.
Regards
Printable View
Where are the places to check this issue. Please help any one on this.
Regards
Which issue? What files? Which db vesion?
If u talk about archive logs I would try
select log_mode from v$database;
show parameter archive
at SQL command line
SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
SQL> show parameter archive;
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
log_archive_dest string /Arc_HIS
log_archive_dest_1 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_state_1 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %s.arc
log_archive_max_processes integer 1
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
standby_archive_dest string ?/dbs/arch
SQL>
LOG_MODE
------------
NOARCHIVELOG
I will not tell u how to go to archivelog mode. I belive it's dangerous to do it if you have not read about that enough, in order to be able to do it by yourself
See
www.oracle.com/technology and read the documentation mainly concepts guide and administration guide
Regards