What is archiving in oracle database?
The configuration of a database at the time of its creation is necessary in order to easily recover your data in case of any occurrence of system failure. Online redo log files are the ones that contain the complete record of any changes that were made to the primary data files. These online redo log files are stored in online redo log groups.
Advantages of Archiving.
The advantages of archiving online redo log files are:
1. A database backup, with online and archived, redo log files, ensures that you can recover all committed transactions in case of the failure of operating system or hardware.
2. If you have a copy of the archived log files that were written while the database was being backed up then you can easily recover the database using that backup which was taken while the database was open and being used.
3. You can perform online tablespace backups, and use these backups to restore a tablespace following media failure.
4. You can keep a standby database current with its original database by continuously applying the original archived redo log files to the standby database.
SQL> sqlplus / as sysdba
SQL> show user;
SQL> archive log list;
SQL> select log_mode from v$database;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
-- Check archivelog open or not
SQL> select log_mode from v$database;
The important command for archive log open and close
Start archive logging – alter system archive log start;
Stop archive logging – alter system archive log stop;
Force archiving of all log files – alter system archive log all;
Force archiving of the current log file – alter system archive log current;
0 comments:
Post a Comment