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-25448: rule string.string has errors
EXP-00092: Unable to set NLS_NUMERIC_CHARACTERS to required defaults.
ORA-16777: unable to find the destination entry of a standby in V$ARCHIVE_DEST
DRG-11728: phrase does not have any broader terms of this type
ORA-13207: incorrect use of the [string] operator
LFI-00108: Open expect the file [string][string] to exist.
ORA-16739: log transport service for standby "string" unexpectedly online
DRG-10822: duplicate query name
RMAN-06433: error installing recovery catalog
CLSR-00509: Unable to initialize NLS
ORA-22875: cannot drop primary key of an object table whose object identifier is primary key based
ORA-24759: invalid transaction start flags