I have restored the log files(LOG2ORCL.ora, LOG1ORCL.ora) from my cold backup. While trying to start the database I get the following error
ORA-00322: Log 1 of thread 1 is not current copy
ORA-00312: Online log 1 thread 1:'D:\ORANT\DATABASE\LOG2ORCL.ORA'.
The docu says, to check for all instances, I am sure there are no other instance running.
The database earlier was on archiver log mode.
Suggest me to start the database please.
If you restored only the logs from the cold backup and nothing else, than that error should be expected. You're restoring logs with an old SCN, while your control files have the newer SCN.
Assuming you don't need the contents of your logs, and the database is otherwise in stable condition, you will probablly have to startup mount, fake a recovery by alter database recover until cancel, and then alter database open resetlogs.
It shows that you have not taken the backup when the Database is closed. May be you can try to use RECOVER DATABASE.
It will start applying Archive Log files and may be able to open the database. Provided that you have archive logs available prior to the Backup you are using.
To bring up the database, follow these steps.
svrmgrl> startup mount;
svrmgrl> recover database until cance;
At proplt enter cancel
svrmgrl> alter database open resetlogs;
This will create online redo log files.
Click Here to Expand Forum to Full Width