Archive Daily Archives: September 11, 2009

Oracle Database Incarnation : Open Resetlogs , SCN

Q. What happens when you run ALTER DATABASE OPEN RESETLOGS ? The current online redo logs are archived, the log sequence number is reset to 1, new database incarnation is created, and the online redo logs are given a new time stamp and SCN. . Q. In what scenarios open resetlogs required ? An ALTER […]

Read More
Not found