TutorialDBA - Support | Training | Consultant

This article highlights the differences between resetting the archive log mode on a single node instance and a Real Application Clusters (RAC). Single Instance Oracle 9i On a single node 9i instance the archive log mode is reset as follows. ALTER SYSTEM SET log_archive_start=TRUE SCOPE=spfile; ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/MYSID/archive/' SCOPE=spfile; ALTER SYSTEM SET log_archive_format='arch_%t_%s.arc' SCOPE=spfile; SHUTDOWN IMMEDIATE; STARTUP MOUNT; ARCHIVE LOG START; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; Oracle 10g Upward In Oracle 10g the  LOG_ARCHIVE_START  parameter and  ARCHIVE LOG START  command have been deprecated, so you will use the following code. ALTER SYSTEM SET log_archive_dest_1='location=/u01/oradata/MYSID/archive/' SCOPE=spfile; ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' SCOPE=spfile; SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; ...

In this tutorial i will explained about how to enable archivelog in postgresql server WAL Archive log In PostgreSQL database system, the actual database ‘writes’ to an addition file called write-ahead log (WAL) to disk. It contains a record of writes that made in the database system. In the case of Crash, database can be repaired/recovered from these records. Normally, the write-ahead log logs at regular intervals (called Checkpoints) matched against the database and then deleted because it no longer is required. You can also use the WAL as a backup because,there is a record of all writes made to the database. WAL Archiving Concept : In pg_xlog/pg_wal write ahead logs are stored. It is the log file, where all the logs are stored of committed and uncommitted transaction. It contains max 6 logs, and last one overwrites. If archiver is on, it moves there. The write-ahead log is composed of each 16 MB large, which are called segments.  The WALs reside under pg_xlog/p...