29 April 2010

How to Set the DB on the archive log mode ?

1- log on the db (database) as sys dba

>sqlplus >username/password as sysdba

2- shutdown the DB immediate

>sqlplus shutdown immediate

3-start db in mount state

>sqlplus startup mount

4-alter database archive log

5-alter database open

No comments:

Post a Comment