Oracle Instance recovery phase and flashback Introduction

Instance Recovery phase:
1. data File not synchronized

2. Roll forward (redo redo)
3. Submissions and uncommitted data in the file

4. Open the Database

5. Fallback (Restore undo)

6. Submission data in the file
Optimize instance recovery: (Faster write of dirty data)
Using MTTR
Fast_start_mttr_target (not recommended to set/Add system burden)
Db_writer_pricesses (process of DBWN)

Flashback
The location specified by the Db_recovery_file_dest parameter is large enough by the Db_recovery_file_dest_size parameter to hold the backup, archive log, flashback log, mirror control file, and mirror redo log automatically managed according to retention policy
Flash Back: Flashback query
Flashback transaction Query:
Flash back version query:
Flash Back Table Delete:
Flash back to the database:
Flash Back: 11g new features

Flashback Recovery zone: The default location for all recovery-related files, simplifying the management of the files required for restore and recovery.
Permanent files: Control file multiplexing Replicas
, online redo log file multiplexing copy
Temp File: Archive log, Rman Backup, copy
, control file Automatic backup
, Flashback log file,
In addition to the flashback log, other files can be redirected elsewhere.

Archive log list;
--See if the archive is open
Select Log_mode from V$database;
--whether the database is open for archiving

The is_recovery_dest_file of the data dictionary can be seen whether it is placed in the Flashback recovery area.

V$controlfile,v$logfile,v$archived_log
V$recovery_file_dest
-----------------------------------------------------

Select group#, bytes/1024/1024 size_m, members, STATUS from V$log;
--View Log groups
alter system switch logfile;
--Toggle Log
Select group#, Status,type, member,is_recovery_dest_file from V$logfile;
--View the information in V$logfile

Instance recovery: Instance Recovery
Crash recovery: Crash recovery

Oracle Instance recovery phase and flashback Introduction