-
Failed to create arhieve files
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
-
under oracle8i
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|