OraFAQ Forum: Server Administration » Create Database

Home » RDBMS Server » Server Administration » Create Database - Error in Archive format

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create Database - Error in Archive format [message #213652]

Thu, 11 January 2007 13:06

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

Report message to a moderator

Re: Create Database - Error in Archive format [message #213654 is a reply to message #213652]

Thu, 11 January 2007 13:16

Mahesh Rajendran
Messages: 10708
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

prashanth_gs
Messages: 67
Registered: November 2005
Location: chennai

Member

gr8!!

Thanks a lot!!

the database was created!!!

Regards,
Prashanth

Report message to a moderator

Previous Topic:	Deadlock Problem
Next Topic:	Difference in ALTER commands with redo/archive logs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 02:54:40 CST 2025