Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> ora-19698: redo01.log is from different database: id=1034728779, db_name=local, While recovering database from hot backup the given error is showing
Joe Valiyaveetti...
post Apr 29 2017, 05:35 AM
Post #1


Newbie
*

Group: Members
Posts: 5
Joined: 25-April 17
Member No.: 51,933



Hi,

When I'm trying to recover the database after restoring the database from hot backup, error message is getting like:

ora-19698: C:\newapp\oradata\local\redo01.log is from different database: id=1034728779, db_name=local

Please help me to sort it out...........

Thanks in advance........
Go to the top of the page
 
+Quote Post
burleson
post May 2 2017, 08:44 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,438
Joined: 26-January 04
Member No.: 13



Hi Joe,

It this was a cold backup, do not use the RECOVER command. Simply ALTER DATABASE OPEN RESETLOGS;

Please read:

http://www.dba-oracle.com/t_rman_ora_19698...nt_database.htm

**************************************************************

>> ora-19698: C:\newapp\oradata\local\redo01.log is from different database: id=1034728779

It looks like you are using a file from a different database!

Check your setting for $ORACLE_SID

*******************************************************

ORA-19698: %s is from different database: id=%s, db_name=%s

*Cause: Catalog failed because the database id in file header
does not match the one in control file.

*Action: Supply the correct file belonging to this database.

*******************************************************

If the error "ORA-19698: %s is from different database" is seen during an Oracle disaster recovery operation, perform the following:
1. Bring the database to nomount state (Steps mentioned below):

At a command prompt, type the following command: SQLplus / as SYSDBA

type shutdown immediate;

type startup nomount;
2. Empty the contents of the directory (under the oradata directory) containing the data files and online redo logs of the newly created database.
3. Re-try the control file restore operation.








--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Joe Valiyaveetti...
post May 7 2017, 11:49 PM
Post #3


Newbie
*

Group: Members
Posts: 5
Joined: 25-April 17
Member No.: 51,933



Thanks Burleson smile.gif ... After cleaning the oradata directory I was able to recover the database.

Could you please explain what is actually happening if we are cleaning the oradata directory and then restoring the control file.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd June 2017 - 08:55 AM