Database Administration (MOSC)

MOSC Banner

change log_archive_format

edited Jul 14, 2014 2:02AM in Database Administration (MOSC) 5 commentsAnswered ✓

Hi all,

on 11g R2 , I have the following :

SQL> recover database using backup controlfile until cancel;

ORA-00334: archived log:

'E:\APP\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2014_07_11\O1_MF_1_5_9VYH39VD_.ARC'

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

RET

ORA-00334: archived log:

'E:\APP\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2014_07_11\O1_MF_1_5_9VYH39VD_.ARC'

ORA-01112: media recovery not started

But :

SQL> show parameter format

NAME                                 TYPE        VALUE

------------------------------------ ----------- -----------

log_archive_format                   string      ARC%S_%R.%T

nls_date_format                      string

I want to change the log_archive_format to a value that corresponds to O1_MF_1_5_9VYH39VD_.ARC.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center