NAVEEN

Saturday, February 6, 2010

Redo log Management.

The most crucial structure for recovery operations is the online redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle database has an associated online redo log to protect the database in case of an instance failure.

To get logfile details:
SELECT * FROM v$log;


Add logfile to database:

ALTER DATABASE
ADD LOGFILE ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo') SIZE 500K;

Add logfile to log group:

ALTER DATABASE
ADD LOGFILE GROUP 10 ('/oracle/dbs/log1c.rdo', '/oracle/dbs/log2c.rdo')
SIZE 500K;

1 comment:

  1. THANKS NAVEENKP! This is what I was looking from last 30 minutes. You solved my problem. Cheers!
    sap testing

    ReplyDelete