No question at this time
DBA Top 10
1 A. Kavsek 8400
2 B. Vroman 5900
3 M. Cadot 5400
4 P. Wisse 4800
5 T. Boles 3700
6 J. Schnackenberg 2100
7 . Lauri 1500
8 R. Pattyn 700
9 T. P 600
9 J. PĂ©ran 600
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48407
Total active users1518
Act. users last 24h5
Act. users last hour0
Registered user hits last week275
Registered user hits last month927
Go up

ORA-00363: log is not the archived version
Next thread: Tracing database user in listener log
Prev thread: Your pactice about ORA-600

Message Score Author Date
Hi Guys I am trying to recover database after r...... Tso P Aug 13, 2019, 13:38
Hi, You mention a redo log, but it should be an...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Lauri Aug 13, 2019, 15:19
I had to recreate the controlfile and apply that r...... Tso P Aug 15, 2019, 13:19

Follow up by mail Click here


Subject: ORA-00363: log is not the archived version
Author: Tso P, South Africa
Date: Aug 13, 2019, 13:38, 6 days ago
Os info: solaris 11
Oracle info: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Message: Hi Guys

I am trying to recover database after restore from Netbackup.

Now, when I try to recover database using the recoer database command I get the :

ORA-00363: log is not the archived version

I managed to apply two redo logs as I don't have the archivelogs.

I used the redo logs to get the required changes.

Now, the one redo that have the required change throws this error.

How can I resolve this issue?

Please help !!!

Thanks in advance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-ORA-00363: log is not the archived version
Author: Lauri, Netherlands
Date: Aug 13, 2019, 15:19, 6 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi,

You mention a redo log, but it should be an archived redo log. Meaning that the archived log should be the end of the thread.
The error messag means that you probably performed a recovery with an online version from the time it was the current log.
II guess that if you cannot get that archived log, you will need to perform incomplete recovery.

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-ORA-00363: log is not the archived version
Author: Tso P, South Africa
Date: Aug 15, 2019, 13:19, 4 days ago
Message: I had to recreate the controlfile and apply that redo log as I don't have archivelogs.

Then I was able to open my database.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here