Archive mode

[maga2724]

Hi 2 All,

Please provide the steps to put 10g database into archive log mode.

Thanks in advance.

Mohammed AbdulGaffar

[Awais.Riaz]

shutdown immediate;
--backup the entire database
--set initialization parameter file as
shutdown immediate;
--backup the entire database
--set initialization parameter file as
alter database archivelog;
alter database open;

Regards,
Awais Riaz

[Awais.Riaz]

Follow the steps bellow:

shutdown immediate;
--backup the entire database
--set initialization parameter file as

log_archive_format=arch_%t_%s_%r.arc
log_archive_dest=e:\database\archive
startup mount;

database mounted.


alter database archivelog;

database altered.

alter database open;

archive log list;

Regards,