How to enable ARCHIVELOG MODE in Oracle
shutdown database
SQL> shutdown immediate;
startup database in mount mode
SQL> startup mount;
Change DB log mode
SQL> alter database archivelog;
Open DB for normal use
SQL> alter database open;
check archivelog status
SQL> archive log list
Default Archive log destination.
1. 10g introduce new feature called FRA (flashback recovery area) so all archivelog files created in FRA.
2. If your not using FRA then all files created in $ORACLE_HOME/database
We can check database archivelog mode through below query
SQL> select log_mode from v$database;
or
SQL> archive log list
SQL> shutdown immediate;
startup database in mount mode
SQL> startup mount;
Change DB log mode
SQL> alter database archivelog;
Open DB for normal use
SQL> alter database open;
check archivelog status
SQL> archive log list
Default Archive log destination.
1. 10g introduce new feature called FRA (flashback recovery area) so all archivelog files created in FRA.
2. If your not using FRA then all files created in $ORACLE_HOME/database
We can check database archivelog mode through below query
SQL> select log_mode from v$database;
or
SQL> archive log list
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment