Tuesday, February 26, 2013
Enable archivelog mode in Oracle 11g database
First lets check the current log mode:
SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 67
Current log sequence 69
or SQL> select name, log_mode from v$database;
NAME LOG_MODE
--------- ------------
DEV NOARCHIVELOG
SQL> alter system set log_archive_start=TRUE scope=spfile;
SQL> alter system set log_archive_dest_1='location=/home/oracle/archivelog' scope=spfile;
SQL> shutdown immediate
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> select name, log_mode from v$database;
NAME LOG_MODE
--------- ------------
DEV ARCHIVELOG
SQL> alter system switch logfile;
Subscribe to:
Post Comments (Atom)
2 comments:
Thanks very nice blog!
My site; voyance
It is appropriate time to make a few plans for the long run and it's time to be happy. I've read this
publish and if I may just I desire to suggest
you some interesting issues or advice. Perhaps you can write next articles relating to this article.
I desire to read even more things approximately it!
my homepage voyance gratuite
Post a Comment