Hi,
I created a 10g v.2 db using the DBCA...
Having executed the following command:
SQL> alter database backup controlfile to trace as '......' NoResetLogs;
so as to have the capability to re-create the control file in case of its destruction....
I have noticed in the file generated:
...
.....
CREATE CONTROLFILE REUSE DATABASE "INFO" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\INFO\REDO01.LOG' SIZE 50M,
.....
.....
But,
alter database add logfile member 'D:\OracleDB_Backup\a','D:\OracleDB_Backup\b','D:\OracleDB_Backup\c' to group 5;
Database altered
SQL> alter database add logfile member 'D:\OracleDB_Backup\r' to group 5;
Database altered
SQL> select status,type,member from v$logfile where group#=5;
STATUS TYPE MEMBER
------- ------- --------------------------------------------------------------------------------
ONLINE D:\ORACLEDB_BACKUP\A
ONLINE D:\ORACLEDB_BACKUP\B
ONLINE D:\ORACLEDB_BACKUP\REDO06.LOG
ONLINE D:\ORACLEDB_BACKUP\C
ONLINE D:\ORACLEDB_BACKUP\R
Note: I created 5 members in this group... not only 3.
Additionally, when i try to insert another log file member to this log group i get the expected(!) error message:
SQL> alter database add logfile member 'D:\OracleDB_Backup\x' to group 5;
alter database add logfile member 'D:\OracleDB_Backup\x' to group 5;
ORA-00357:too many members specified for log file, the maximum is 5
Why is there this difference between the maxlogfilemembers written in the trace file (using the backup controlfile....) and the max log file members reported in the error message(ORA-00357)...???
Thank you,
Sim