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

ORA-13768: Snaphshot ID must be between string and string.

1 Answers  

---

ORA-07512: sscggtl: $enq unexpected return for client termination lock

1 Answers  

---

ORA-06767: TLI Driver: alloc failed during release

1 Answers  

---

PCC-00031: Invalid value given for option "string"

1 Answers  

---

IMP-00033: Warning: Table "string" not found in export file

2 Answers  

---

ORA-40201: invalid input parameter string

1 Answers  

---

NZE-29245: the toolkit does not recognize the function being used

1 Answers  

---

ORA-06110: NETTCP: message send failure

1 Answers  

---

ORA-28293: No matched Kerberos Principal found in any user entry

1 Answers  

---

ORA-07823: sspsqr: $QIO failure

1 Answers  

---

ORA-01530: a database already mounted by the instance

1 Answers  

---

ORA-33302: (DBVALID01) SEVERE ERROR: Record number multiply used.

1 Answers  

---