Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-19905: log_archive_format must contain %s, %t and %r

4joey1May 1 2010 — edited Jun 27 2011
Hallo!I am an Oracle 10g newbie who is studying for the Administration OCA exam.

I was trying to place the database in archive log mode and I had tried to come up with the archive log file name.

I was forced to restart the instance and from sqlplus I have tried to start the instance each time via the startup commands :startup force, startup nomount; startup mount; startup open but the ORA 19905 error still appears as below

SQL> conn /as sysdba;
Connected to an idle instance.
SQL> startup force;
ORA-19905: log_archive_format must contain %s, %t and %r

How do I resolve or bypass this.Also using an example,give me the best format for naming an archive log file which adheres to the archive log format.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2011
Added on May 1 2010
18 comments
9,694 views