does the datafiles have log sequence number information
Hi,
We refreshed a databases by taking transferring the dataafiles from qa to dev server and created a control file manually on the dev database from the create control file script taken from qa.
While opening the database I received below error
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
Why does the database need open restlogs for this to open since the control file has no info about the log sequence number becuase it has been created afresh manually.Does the datafiles have log sequence number info as well?
We refreshed a databases by taking transferring the dataafiles from qa to dev server and created a control file manually on the dev database from the create control file script taken from qa.
While opening the database I received below error
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
Why does the database need open restlogs for this to open since the control file has no info about the log sequence number becuase it has been created afresh manually.Does the datafiles have log sequence number info as well?
1