Ora-01110 data file 1 system01.dbf standby

ORA suggestion :. ORA change for thread 1 is in sequence 9. ORA change for thread 1 is in sequence ORA log file. Log applied. Media recovery complete. Database altered. ORA file 1 needs media recovery. Some more useful links: Sharing: A Company's Experience.

How to check and get details about patch applied. Important DBA Scripts. Why We are not Rich. Gyan 6 September at If not locate the file or restore from backup. When either RMAN command is complete review:. If the file is offline you will need to recover and online it assuming you are running in archivelog mode.

Data Guard. This could be: An old controlfile was used for database restoration. Or Some data files were not restored, which make them newer. Solution First of all, we need to copy some archived logs from the primary database server to my standby one. We did it. We can open even a physical standby. In case of active dataguard, recovery is applied even in open mode. Actually i learnt it can be opened in read only for active dataguard? You are correct, Physical standby can be opened in read only mode.

When you issue the command to open it as Alter Database open, the physical standby is automatically opened in read only mode only. Thanks once again….