Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


ORA-01209: data file is from before the last RESETLOGS



ORA-01209: data file is from before the last RESETLOGS..

Answer / guest

Cause: The reset log data in the file header does not match
the control file. If the database is closed or the file is
offline, the backup is old because it was taken before the
last ALTER DATABASE OPEN RESETLOGS command. If opening a
database that is open already by another instance, or if
another instance just brought this file online, the file
accessed by this instance is probably a different version.
Otherwise, a backup of the file probably was restored while
the file was in use.

Action: Make the correct file available to the database.
Then, either open the database, or execute ALTER SYSTEM
CHECK DATAFILES.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00135: There are number active threads

1 Answers  


ORA-32118: Cannot perform operation on a null FILE

1 Answers  


RMAN-01008: the bad identifier was: string

1 Answers  


SQL-02155: Date Time Interval only valid with Dynamic=ANSI

1 Answers  


ORA-30118: syntax error at 'string' at the end of input

1 Answers  


ORA-35578: (SQLOUT11) SQL cursor 'number' cannot be used with CURRENT OF <cursor name> syntax

1 Answers  


RMAN-06483: changed datafile copy expired

1 Answers  


NNL-00803: Queries received, type ALIAS: number

1 Answers  


KUP-04053: record number number

1 Answers  


ORA-02210: no options specified for ALTER TABLE

1 Answers  


RMAN-06532: redundancy count must be greater than zero

1 Answers  


ORA-14066: illegal option for a non-partitioned index-organized table

1 Answers  


Categories