|
Redo log files record all changes made on the database Used for recovery
Require at least 2 Groups 1 member
Should try and divide up I/O Try and keep data file and log files on seperat drives.
Min size 50k Max size OS dependant
Make larger for many changes
You must enable arch in pfile before you can use the archiver. LOG_ARCHIVE_DEST_1='location=pathToArchiveFolder' LOG_ARCHIVE_START=true Then you must shutdown the database and startup in mount mode and run: ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN;
|
|
Read more...
|