Home » RDBMS Server » Server Administration » Create Database - Error in Archive format
Create Database - Error in Archive format [message #213652] Thu, 11 January 2007 13:06 Go to next message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
Hi,

We are creating new database in oracle 10gr2.

While creating the database we are getting the following error

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

Following are the format mentioned in my init.ora file
log_archive_format='arch%r%t'

How to fix the issue. What is the correct format?

DB : Oracle 10gr2
OS : Sun Solaris 5.8

Regards,
Prashanth
Re: Create Database - Error in Archive format [message #213654 is a reply to message #213652] Thu, 11 January 2007 13:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
error is self explanative.
log_archive_format must contain %s, %t and %r

set your paramater values as
LOG_ARCHIVE_FORMAT='Arch%t_%s_%r'

[Updated on: Thu, 11 January 2007 13:17]

Report message to a moderator

Re: Create Database - Error in Archive format [message #213657 is a reply to message #213654] Thu, 11 January 2007 13:43 Go to previous message
prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai
Member
gr8!!

Thanks a lot!!

the database was created!!!

Regards,
Prashanth
Previous Topic: Deadlock Problem
Next Topic: Difference in ALTER commands with redo/archive logs
Goto Forum:
  


Current Time: Thu Dec 08 08:35:14 CST 2016

Total time taken to generate the page: 0.18932 seconds