Skip to content
July 3, 2010 / doganay

HOW TO ENABLE ARCHIVE MODE

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Hi,

If you want to enable archiving in your database, take a look:
(I assume that you use spfile)

SQL> alter system set log_archive_dest='YOUR_ARC_DEST' scope=spfile;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
--Let's drink our first glass of water:
--(If you have 3 redo log groups, make sure to switch logfile 3-times)
SQL> alter system switch logfile;
SQL> alter system switch logfile;
SQL> alter system switch logfile;
--Let's check:
SQL> archive log list;
SQL> select log_mode from sys.v$database;
SQL> select INST_ID,LOG_MODE from gv$database;
SQL> select ARCHIVER from v$instance;

try and pray 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: