The easiest way to find out if a database is running in archivelog mode:
SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
And for more reference:
Archive log related stuff
I have been earning my dough from my knowledge of Oracle since 1989, when it was version 5. So much has changed and so many new topics have arrived that I thought I use the weblog technology to note down little tips and problems I come across during my daily work with Oracle
SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
No comments:
Post a Comment