| OMF online logfiles [message #506322] |
Sun, 08 May 2011 06:01  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Please can you take a look at the way I have my omf parameters set, and the logfile members that were created when I added new groups:risb> sho parameters db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string /data250/risb
db_create_online_log_dest_1 string /log1/risb
db_create_online_log_dest_2 string /log2/risb
db_create_online_log_dest_3 string /log3/risb
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
risb> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------------------------------------------ ---
1 ONLINE /log1/risb/RISB/onlinelog/o1_mf_1_6wdwzsw9_.log NO
1 ONLINE /log2/risb/RISB/onlinelog/o1_mf_1_6wdwzv3r_.log NO
4 ONLINE /log1/risb/RISB/onlinelog/o1_mf_4_6w8oft93_.log NO
4 ONLINE /log2/risb/RISB/onlinelog/o1_mf_4_6w8ofyvl_.log NO
5 ONLINE /log1/risb/RISB/onlinelog/o1_mf_5_6w8ogvhj_.log NO
5 ONLINE /log2/risb/RISB/onlinelog/o1_mf_5_6w8ogxfv_.log NO
6 ONLINE /log1/risb/RISB/onlinelog/o1_mf_6_6w8ohprc_.log NO
6 ONLINE /log2/risb/RISB/onlinelog/o1_mf_6_6w8ohrnc_.log NO
8 rows selected.
risb>
Why am I getting only two members per group? I've just done the same test on another database (Windows Ent Edition), and I get three members, as expected:orcl> sho parameters db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string c:\app\john\oradata\orcl
db_create_online_log_dest_1 string c:\app\john\oradata\orcl
db_create_online_log_dest_2 string c:\app\john\oradata\orcl
db_create_online_log_dest_3 string c:\app\john\oradata\orcl
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
orcl> select * from v$logfile where group#=9;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------------------------------------------- ---
9 ONLINE C:\APP\JOHN\ORADATA\ORCL\ORCL\ONLINELOG\O1_MF_9_6WDXF976_.LOG NO
9 ONLINE C:\APP\JOHN\ORADATA\ORCL\ORCL\ONLINELOG\O1_MF_9_6WDXFKOH_.LOG NO
9 ONLINE C:\APP\JOHN\ORADATA\ORCL\ORCL\ONLINELOG\O1_MF_9_6WDXFTO4_.LOG NO
orcl>
Any insight gratefully received. I want to use OMF, and I want three memebrs per group.
|
|
|
|
| Re: OMF online logfiles [message #506334 is a reply to message #506322] |
Sun, 08 May 2011 12:23  |
 |
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
|
Senior Member |
|
|
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> select dimlm from x$kccdi;
DIMLM -----Max log members.
----------
3
SQL>
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ---------------------------------------- ---
3 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO03.LOG NO
2 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO02.LOG NO
1 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO01.LOG NO
SQL> alter system set db_create_file_dest='D:\APP\SRIRAM\ORADATA\SRIRAM';
System altered.
SQL> sho parameters db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string D:\APP\SRIRAM\ORADATA\SRIRAM
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
db_create_online_log_dest_5 string
SQL> ALTER DATABASE ADD LOGFILE;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ---------------------------------------- ---
3 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO03.LOG NO
2 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO02.LOG NO
1 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO01.LOG NO
4 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\SRIRAM\ONLI NO
NELOG\O1_MF_4_6WCL18PN_.LOG
4 ONLINE D:\APP\SRIRAM\FLASH_RECOVERY_AREA\SRIRAM YES
\ONLINELOG\O1_MF_4_6WCL1K9Q_.LOG
SQL> alter system set db_create_ONLINE_LOG_dest_1='D:\APP\SRIRAM\ORADATA\SRIRAM';
System altered.
SQL> alter system set db_create_ONLINE_LOG_dest_2='D:\APP\SRIRAM\ORADATA';
System altered.
SQL> alter system set db_create_ONLINE_LOG_dest_3='D:\APP\SRIRAM\ORADATA';
System altered.
SQL> alter system set db_create_ONLINE_LOG_dest_4='D:\APP\SRIRAM\ORADATA';
System altered.
SQL> ALTER DATABASE ADD LOGFILE;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ---------------------------------------- ---
3 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO03.LOG NO
2 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO02.LOG NO
1 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\REDO01.LOG NO
4 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\SRIRAM\ONLI NO
NELOG\O1_MF_4_6WCL18PN_.LOG
4 ONLINE D:\APP\SRIRAM\FLASH_RECOVERY_AREA\SRIRAM YES
\ONLINELOG\O1_MF_4_6WCL1K9Q_.LOG
5 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\SRIRAM\ONLI NO
NELOG\O1_MF_5_6WCLSX55_.LOG
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ---------------------------------------- ---
5 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\ONLINELOG\O NO
1_MF_5_6WCLSZ9J_.LOG
5 ONLINE D:\APP\SRIRAM\ORADATA\SRIRAM\ONLINELOG\O NO
1_MF_5_6WCLT1SK_.LOG
8 rows selected.
See here I have configured for "db_create_ONLINE_LOG_dest_4"
But I have only 3 members created. Because this is OS specific.
Some operating systems have min value 1 ,Some OS supports 2(default value), 3 and other supports max number(5).
check your maxlogmembers parameter in your control file.and your max log members for your Operating System.
Sriram
[Updated on: Sun, 08 May 2011 12:28] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
