By default in Oracle 10g the database is in noarchivelog mode. To check the present status of archivelog, login as any user with dba privileges and try the below querys
sql> select log_mode from v$database;
or
sql> archive log list
if the database is in noarchivelog mode, then if require you can change to archivelog mode as shown below
sql> shut immediate;
sql> startup mount;
sql> alter database archivelog;
sql> alter database open;
check the status of archivelog again for confirmation.
sql> select log_mode from v$database;
or
sql> archive log list
if the database is in noarchivelog mode, then if require you can change to archivelog mode as shown below
sql> shut immediate;
sql> startup mount;
sql> alter database archivelog;
sql> alter database open;
check the status of archivelog again for confirmation.
No comments:
Post a Comment