For 10g RAC database restoration, you may check: How to Restore 10g RAC Database by a Backup Set. Suppose we have restored 12c clusterware back.… Read More »How to Restore 12c RAC Database by a Backup Set
ALTER DATABASE OPEN RESETLOGS
Suppose we have restored the whole OS to the new server including Oracle software and directory structure. Our goal is to restore the database to… Read More »How RMAN Restore Database by a Backup Set
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 »Are All Oracle Full Backups Consistent?
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?