Oracle 11g change log group size

Oracle 11g change log group size

Oracle 11g change log group size

1. Create a New log Group

1. alter database add logfile group 4 ('/u01/app/oracle/oradata/jian/redo04.log') size 1024 k;

2. alter database add logfile group 5 ('/u01/app/oracle/oradata/jian/redo05.log') size 1024 k;

2. Switch the current log to a new log group.

1. alter system switch logfile;

2. alter system switch logfile;

3. Delete the old log Group

1. alter database drop logfile group 1;

2. alter database drop logfile group 2;

3. alter database drop logfile group 3;

4. delete files in the original log group 1, 2, and 3 in the operating system

5. Rebuild log groups 1, 2, and 3

1. alter database add logfile group 1 ('/u01/app/oracle/oradata/jian/redo01.log') size 10 M;

2. alter database add logfile group 2 ('/u01/app/oracle/oradata/jian/redo02.log') size 10 M;

3. alter database add logfile group 3 ('/u01/app/oracle/oradata/jian/redo03.log') size 10 M;

6. Switch the log Group

1. alter system switch logfile;

2. alter system switch logfile;

3. alter system switch logfile;

7. delete a log group 4 and 5

1. alter database drop logfile group 4;

2. alter database drop logfile group 5;

8. delete files in log group 4 and 5 under the Operating System

9. Back up the latest Control File

SQL> alter database backup controlfile to trace resetlogs

-------------------------------------- Split line --------------------------------------

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

-------------------------------------- Split line --------------------------------------