Hello Experts,
I am new to DBA, Need some help!
1- How Production DB and standby DB Update as same data?
2- Suppose Production DB crashed on 3:10 PM and we have taken backup Before 6 hours so what is state of ProDB and StaDB.
3- More Knowledge about Archive.
Please expert help me, Thanks in advance.
Archive means if you made any changes in your database like some insert update delete query. this changes will save in redo log buffers ... once one 3rd of this buffer fills or every 3 seconds log writer will write these details in redolog files in a database 2 redolog files must if one redo log file fills log switch will happen. It will write in another log file if db is running in archive log mode this filled redolog files wil be archived by archiver processer if system is running in no archive log mode. It won't archive and it will simply overwrite.
please correct me, if i am wrong.