Oracle AppsDBAs World: Enable/Disable archivelog in 9i

(By default database will be in no archive log
mode)

connect to sqlplus as sysdba
check the archive log mode using,
archive log list;

Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle/visdb/9.2.0/dbs/
arch
Oldest online log sequence 204
Current log sequence 206

issue shutdown immediate;
take the cold backup.

Then startup database in mount stage,
startup mount

once database has mounted issue,
alter database archive log;
This command will enable Database log mode to
Archive Mode.
But still Automatic archival will be Disabled.
To enable Automatic archival process issue
alter system archive log start;
Now Automatic archival will be enabled.
But once if you restart the database it'll be
disabled.
set log_archive_start=true in init file so that
whenever database is started it'll consult with
this parameter and will start automatic archival
process. if you want to change the archive log
destination set log_archive_dest_n for multiple
locations.
if you set this parameter bounce the database
once otherwise issue,
alter database open;

issue,
archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/visdb/9.2.0/dbs/arch
Oldest online log sequence 205
Current log sequence 206

For disable archivelog mode issue,
(Database should be in mount stage)
alter database noarchivelog;

issue,
archive log list;
Database log mode No Archive Mode
Automatic archival Enabled
Archive destination /oracle/visdb/9.2.0/dbs/arch
Oldest online log sequence 205
Current log sequence 206

posted by Senthil Kumaran @ 10:28 PM

0 Comments: