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

RMAN-06034: at least 1 channel must be allocated to execute this command

1 Answers  

---

ORA-04077: WHEN clause cannot be used with table level triggers

1 Answers  

---

ORA-25465: variable name not specified

1 Answers  

---

SQL*Loader-00608: subpartition not empty for INSERT option; table string, subpartition string

1 Answers  

---

DRG-12307: column string is NULL and cannot be indexed

1 Answers  

---

ORA-29363: plan directive string, string is mandatory and cannot be modified or deleted

1 Answers  

---

ORA-33920: (MAKEDCL34) The string SURROGATE must have one of the following data types: ID, NTEXT, TEXT, NUMBER, or INTEGER.

1 Answers  

---

ORA-36272: (XSCGMDLAGG04) 'workspace object' is not a valid operator for the AGGREGATION function.

1 Answers  

---

ORA-08186: invalid timestamp specified

1 Answers  

---

ORA-23439: refresh group template already exists

1 Answers  

---

ORA-06134: NETTCP: file access privilege violation

1 Answers  

---

ORA-24163: dblink is not supported in rules engine DDLs

1 Answers  

---