What is an Oracle Instance? What information is stored in Control File? When you start an Oracle DB which file is accessed first? What is the Job of SMON, PMON processes? What is Instance Recovery? What is written in Redo Log Files? How do you control number of Datafiles one can have in an Oracle …
STANDBY DB -Alert logfile: Media Recovery Log /dbprod/PROD/db/apps_st/data/archive/1_138_1090708106.dbfMedia Recovery Waiting for thread 1 sequence 139 (in transit)Thu Feb 03 11:46:15 2022Archived Log entry 18 added for thread 1 sequence 139 rlc 1090708106 ID 0x1df3f809 dest 2:Thu Feb 03 11:46:15 2022Errors in file /dbprod/PROD/db/tech_st/12.1.0/admin/PROD_standbydb/diag/rdbms/prodmum/PROD/trace/PROD_rfs_26005.trc:ORA-19527: physical standby redo log must be renamedORA-00312: online log 3 thread 0: …
Recreate online redo log file and Standby redo log file in Data gurd Read More »