Oracle Database Discussions

Hi!

This is about Oracle 10.2.0.4 on Solaris.

First the most important information.

SQL>archive log list

Database log mode Archive Mode
Automatic archival Enabled
Archive destination ?/dbs/arch
Oldest online log sequence 12
Next log sequence to archive 12
Current log sequence 17

SQL> show parameter recov

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /data/MVS_P0/reco01
db_recovery_file_dest_size big integer 98G
recovery_parallelism integer 0

SQL> show parameter archive

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target integer 0
log_archive_config string
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 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
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string ?/dbs/arch

The problem

When I do a 'alter system log switch' the lines below are shown in the alertlog:
Errors in file /data/MVS_P0/admin/bdump/mvs_r1_arc0_12115.trc:
ORA-16014: Message 16014 not found; No message file for product=RDBMS, facility=ORA; arguments: [6] [12]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [6] [1] [data/MVS_P0/redo01/log06.rdo]

SQL> select recid, completion_time, name from v$archived_log

RECID COMPLETIO NAME
---------- --------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 23-JUL-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_07_23/o1_mf_1_1_48gf98jq_.arc
2 23-JUL-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_07_23/o1_mf_1_2_48gfjvq1_.arc
3 28-JUL-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_07_28/o1_mf_1_3_48vf0cns_.arc
4 02-AUG-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_08_02/o1_mf_1_4_497pys3n_.arc
5 06-AUG-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_08_06/o1_mf_1_5_49mfqbrb_.arc
6 11-AUG-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_08_11/o1_mf_1_6_4b16ml0y_.arc
7 17-AUG-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_08_17/o1_mf_1_7_4bhd48pc_.arc
8 21-AUG-08 /data/MVS_P0/reco01/MVS_P0/archivelog/2008_08_21/o1_mf_1_8_4bvlck3b_.arc
9 22-AUG-08 /data/MVS_P0/reco01/arch/1_9_660770425.dbf
10 22-AUG-08 /data/MVS_P0/reco01/arch/1_10_660770425.dbf
11 22-AUG-08 /data/MVS_P0/reco01/arch/1_11_660770425.dbf

11 rows selected.


It looks like the archives are not written, or I can not find them. I check $ORACLE_HOME/dbs/arch and /data/MVS_P0/reco01 but it is not there. It worked before, but the person who configured it is on holiday. I know that I did 'something' that created archives (check the last three lines above), but that is somehow not working anymore.

Can someone help me by finding the archives?

(I need to make a online copy to create a standby-database, that is quite hard without archives. ;-))