Step 1: Add new logfile groups of required size
SQL>alter database add logfile group 4('E:\ORACLE\PRODUCT\10.2.0\ORADATA\VMS\REDO04a.rdo','E:\ORACLE\PRODUCT\10.2.0\ORADATA\VMS\REDO04b.rdo') size 500M
SQL>alter database add logfile group 5('E:\ORACLE\PRODUCT\10.2.0\ORADATA\VMS\REDO05a.rdo','E:\ORACLE\PRODUCT\10.2.0\ORADATA\VMS\REDO05B.rdo') size 500M
SQL>alter database add logfile group 6('E:\ORACLE\PRODUCT\10.2.0\ORADATA\VMS\REDO06a.rdo','E:\ORACLE\PRODUCT\10.2.0\ORADATA\VMS\REDO06B.rdo') size 500M
Step 2: Drop the previous logfile groups
SQL>ALTER DATABASE DROP LOGFILE GROUP 1
SQL>ALTER DATABASE DROP LOGFILE GROUP 2
SQL>ALTER DATABASE DROP LOGFILE GROUP 3
SQL> SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
4 1 272 524288000 2 YES INACTIVE 36943246 26-FEB-09
5 1 273 524288000 2 YES INACTIVE 37596143 26-FEB-09
6 1 274 524288000 2 NO CURRENT 38261614 27-FEB-09
How we create Oracle9i DBlink
ReplyDeleteHi How many groups we add can add max for logfiles in oracle DB
ReplyDeleteHi How many groups we can add maximum for logfiles in oracle DB
ReplyDeletefor creating DBLink you can use below given query:
ReplyDeleteCREATE [SHARED | PUBLIC] DATABASE LINK link-name
[CONNECT TO username IDENTIFIED BY password]
[USING connect-string];
Example:
Create public database link link1 connect to db1 identified by pswd1 using 'connlink';
Maximum number of logfiles depend on the parameter
ReplyDeleteMAXLOGFILES used in the CREATE DATABASE statement Group values can range from 1 to MAXLOGFILES.
Thanks you very much
ReplyDeleteIn Instance what is the needed space for System global area.How to allocate memory?
ReplyDelete