How to Resolve Standby ORA-00600 [3020]
ORA-00600 [3020] Found MRP shutdown with ORA-00600 [3020] in alert log of a standby database due to inconsistency of a newly created data file. Wed… Read More »How to Resolve Standby ORA-00600 [3020]
ORA-01110
ORA-01110 means that the data file specified in the message is the first met or main source of problem in the course of error stack.
Therefore, ORA-01110 could exists in various situations of data file modification and operations.
When Database is Not Consistent
There are several different kinds of situation when you recover a database with inconsistent states among files. In the following, I have to assume that… Read More »When Database is Not Consistent
How to Resolve ORA-01196 and ORA-01110
ORA-01196 Saw errors ORA-01196 thrown by the database when trying to activate a standby database. SQL> alter database activate standby database; alter database activate standby… Read More »How to Resolve ORA-01196 and ORA-01110
How to Resolve ORA-01578, ORA-01110 and ORA-26040
ORA-01578 and ORA-26040 Errors found when dumping tables by exp. ORA-01578: ORACLE data block corrupted (file # 53, block # 34982) ORA-01110: data file 53:… Read More »How to Resolve ORA-01578, ORA-01110 and ORA-26040
Converting Standby Database to Snapshot (4/4) - With Flashback Tablespace Disabled
Converting Standby Database to Snapshot (3/4) - With Flashback Database DisabledSome standby conversions could be more complicated than usual, especially converting back to physical standby.… Read More »Converting Standby Database to Snapshot (4/4) - With Flashback Tablespace Disabled
User-Managed Backup (3/4) - Online Backup All Datafiles
User-Managed Backup (2/4) - Offline Backup The Whole Database With ARCHIVELOG ModeTo backup all datafiles online with user-managed mode, you can force the all datafiles… Read More »User-Managed Backup (3/4) - Online Backup All Datafiles
When Several Datafiles Are Missing - Restore From the Standby Database
Not only the local backups can save the datafiles, but also the standby database can be a source to restore the datafiles. There are four… Read More »When Several Datafiles Are Missing - Restore From the Standby Database
How to Resolve ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
I got ORA-01547 when I was trying to recreate a standby database and make them sync. In this post, I will explain the occasions to… Read More »How to Resolve ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
When Several Datafiles Are Missing - Restore From Local Backups
When several datafiles are accidentally deleted, we can use RMAN to restore and recover the datafiles individually. List the backup we have now. [oracle@primary01 ~]$… Read More »When Several Datafiles Are Missing - Restore From Local Backups