How many maximum Redo Logfiles one can have in a Database?

Depends on what you specified for MAXLOGFILES during database creation (manually) or what you specified for “Maximum no. of redo log files” with DBCA. You can check the current max with:

SQL> select decode(type, ‘REDO LOG’, ‘MAXLOGFILES’), records_total
2 from v$controlfile_record_section
3 where type = ‘REDO LOG’;

DECODE(TYPE RECORDS_TOTAL
———– ————-
MAXLOGFILES 16

Leave a Comment


NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>