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!

How does one name an Archive Log file in ARC%S_%R.%T format

4joey1May 2 2010 — edited May 9 2010

Hallo!I have been trying to enable Archive Log mode for the Oracle 10g database.

In OEM,I went via the links Maintenance->Recovery Settings->Media Recovery

There,a text box by the name Log Archive Filename Format requires one to name the Archive Log file in ARC%S_%R.%T format.

I have tried several times to name the Archive log e.g ARC001_001.001 but when I shutdown and restart the database instance,the error below appears

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

This error has proved impossible to rectify and I am forced to uninstall then re-install Oracle 10g.

I would like to have back-ups in archive log mode.Please give me the best way to name the Archive Log file i.e with an example name so that I can have online back-ups.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2010

Added on May 2 2010

#general-database-discussions

2 comments

2,224 views