Hi 2 All,
Please provide the steps to put 10g database into archive log mode.
Thanks in advance.
Mohammed AbdulGaffar
Archive mode
-
- Posts: 4
- Joined: Tue Jul 03, 2007 5:21 am
- Location: Bahrain
-
- Posts: 4
- Joined: Tue Jul 03, 2007 5:21 am
- Location: Bahrain
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,
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,
Who is online
Users browsing this forum: No registered users and 1 guest