ORA-19905: log_archive_format must contain %%s, %%t and %%r
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-16092: dependent archive log destination is not active
LFI-00151: Error on inserting into hash table in function string
ORA-09805: conversion of category number to string failed.
ORA-26503: internal RepAPI operation failure on object string.string
LFI-00146: copy does not expect the file string.string to exist
ORA-12561: TNS:unknown error
IMG-00552: invalid inputChannels specified
ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here
ORA-07472: snclrd: open error when opening sgadef.dbf file.
ORA-15036: disk 'string' is truncated
ORA-13708: Some snapshots in the range [string, string] were purged before the analysis was complete.
ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION