How to put oracle database to archivelog

0
(0)

Shutdown the database.

shutdown immediate;

Exclusive start.

startup mount;

Turn on archivelog.

SQL> alter database archivelog;
Database altered.

SQL> alter database open;
Database altered.

Check archive log mode.

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG

Similar Posts:

508

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Leave a Comment

Your email address will not be published.

Scroll to Top