How to Perform Consistent Backups
It depends, depends on what kind of backup mode that you had taken. If you took a full backup by the following ways, then you… Read More »How to Perform Consistent Backups
ALTER DATABASE OPEN RESETLOGS
Can I Open Database to READ ONLY with RESETLOGS?
You can have this one: SQL> ALTER DATABASE OPEN READ ONLY; And also this one: SQL> ALTER DATABASE OPEN RESETLOGS; But there's NO combined statement like… Read More »Can I Open Database to READ ONLY with RESETLOGS?
When Redo Log Files Are All Missing
If your redo logs are all missing, then you have to know you will lose some data and no longer to recover it. Now let's… Read More »When Redo Log Files Are All Missing