ORA-19905: log_archive_format must contain %%s, %%t and %%r

Question Posted / guest

2 Answers
6274 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-19905: log_archive_format must contain %%s, %%t and %%r..

To implement the solution, please execute the following
steps:

1. Create a copy of the init.ora file. (
oracle_home/admin/pfile --> init.ora )
2. Edit the above init.ora to reflect the
log_archive_format = 'arch_%r_%t_%s.arc'
and log_archive_dest_1 = f:\archive
3. Shutdown immediate and Startup nomount with the above
pfile.
SQL> shutdown immediate
SQL> startup nomount pfile =
oracle_home/admin/pfile/init.ora

4. Create spfile from pfile
SQL> create spfile = 'oracle_home/database/spfile.ora' from
pfile =
'oracle_home/admin/pfile/init.ora'

5. SQL> shutdown immediate
6. SQL> startup
7. SQL> archive log list --- verify that db is in arhivelog
mode.

Requirement of this format is documented in:
Administrator's Guide
10g Release 1 (10.1)
Part No. B10739-01
Chapter7 :Managing Archived Redo Logs
---> Specifying Archive Destinations .

Is This Answer Correct ?

1 Yes

0 No

ORA-19905: log_archive_format must contain %%s, %%t and %%r..

Answer / guest

Cause: log_archive_format is missing a mandatory format
element. Starting with Oracle 10i, archived log file names
must contain each of the elements %s(sequence), %t(thread),
and %r(resetlogs id) to ensure that all archived log file
names are unique.

Action: Add the missing format elements to log_archive_format.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer