Answer / dipti ranjan

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 .

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

TNS-04020: CMCTL Version: number.number.number.number.number

1 Answers  

---

QSM-02076: sequence number in the mv log is newer than last refresh

1 Answers  

---

NCR-00003: NCR: Initialization failure

1 Answers  

---

LCD-00203: missing keyword [string]

1 Answers  

---

ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

1 Answers  

---

RMAN-06175: deleted script: string

1 Answers  

---

DRG-11207: user filter command exited with status string

1 Answers  

---

RMAN-06515: archived logs required to recover from this copy will expire when this copy expires

1 Answers  

---

ORA-01867: the interval is invalid

1 Answers  

---

ORA-01952: system privileges not granted to 'string'

1 Answers  

---

ORA-16595: NetSlave process string failed to terminate

1 Answers  

---

ORA-00604: error occurred at recursive SQL level string

1 Answers  

---