OraFAQ Forum: Backup & Recovery » ora 19698 file is from different database id= db_name=

Home » RDBMS Server » Backup & Recovery » ora 19698 file is from different database id= db_name= (ERP R12, Linux 5.5 64-bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora 19698 file is from different database id= db_name= [message #613648]

Thu, 08 May 2014 23:45

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Hi,

Cold backup of source machine restored on target machine successfully.

Hot backup is restored by following steps:

RMAN> startup nomount

RMAN> set dbid=174105117
Source and target systems have different dbids (I've set source machine dbid on target machine)

RMAN> run {
2> set controlfile autobackup format for device type disk to '/opt/backup/%F';
3> restore controlfile from autobackup; }

RMAN> alter database mount;

RMAN> run {
2> allocate channel disk1 device type disk format '/opt/backup/%F';
3> restore database; }

RMAN> recover database;
ora 19698 file is from different database id= db_name=

regards,

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613649 is a reply to message #613648]

Thu, 08 May 2014 23:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Cold backup of source machine restored on target machine successfully.
what problem are you trying to solve because report a functioning DB here!

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613650 is a reply to message #613649]

Thu, 08 May 2014 23:57

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Thank you for your reply.

Actually I want to restore the hot backup of source on target system. During the restoration I faced the error that is the title of this thread. I need to resolve the error.

Regards,

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613651 is a reply to message #613650]

Fri, 09 May 2014 00:10

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Please help me to resolve the issue.

Thanks,

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613654 is a reply to message #613651]

Fri, 09 May 2014 00:30

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613655 is a reply to message #613654]

Fri, 09 May 2014 00:33

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Can you help me to provide correct file belonging to this database?

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613657 is a reply to message #613655]

Fri, 09 May 2014 00:34

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Search in your backups.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613658 is a reply to message #613657]

Fri, 09 May 2014 01:00

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Backup with control file is available.
Steps of restoring hot backup mentioned already.
Kindly rewrite the steps of hot backup restoration with Supply the correct file belonging to this database.

Thanks,

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613660 is a reply to message #613658]

Fri, 09 May 2014 01:05

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Copy and paste the COMPLETE rman session.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613661 is a reply to message #613658]

Fri, 09 May 2014 01:06

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

I'll try to understand, but you will need to explain what you did.

First, when you "restored" the cold backup, did that include a copy of the database?

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613662 is a reply to message #613658]

Fri, 09 May 2014 01:07

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I didn't see "Source and target systems have different dbids ".
You cannot restore a (control) file with a DBID into another DBID.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613665 is a reply to message #613661]

Fri, 09 May 2014 01:15

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Michel Cadot
Actually the server got down accidentally, so the session can not be copied and pasted.
I've pasted the sequence of commands as they were executed.

John Watson
Complete backup of last Saturday restored on Monday.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613667 is a reply to message #613665]

Fri, 09 May 2014 01:24

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Find the correct DBID, then you can restore.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613668 is a reply to message #613665]

Fri, 09 May 2014 01:28

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

theowais wrote on Fri, 09 May 2014 07:15

Michel Cadot
Actually the server got down accidentally, so the session can not be copied and pasted.
I've pasted the sequence of commands as they were executed.

John Watson
Complete backup of last Saturday restored on Monday.

You didn't answer my question, did you? My best guess is that "complete" means that the database was included.
If so, two more questons:
Firt, why did you change the DBID?
Second, why do you want to restore again?

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613675 is a reply to message #613668]

Fri, 09 May 2014 02:09

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Michel Cadot
I got dbid. Now kindly explain the steps for restoration. What dbid should be given Source ora Target?

John Watson
Yes database was included.
First, why did you change the DBID?
Actually dbid of target and source system we not same there for I want to make
Second, why do you want to restore again?
I need to restore hot backup first I restored cold backup. This is business requirement.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613677 is a reply to message #613675]

Fri, 09 May 2014 02:14

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is only one DBID, the one of the database you backed up and want to restore.
Target DBID is meaningless.
So set the DBID to the one of the original database and retry; then copy and paste the RMAN session.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613680 is a reply to message #613677]

Fri, 09 May 2014 02:28

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Ok. Please wait for a while.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613685 is a reply to message #613680]

Fri, 09 May 2014 03:00

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

RMAN> startup nomount

Oracle instance started

Total System Global Area 1068937216 bytes

Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes

RMAN> set dbid=174105117

executing command: SET DBID

RMAN> run {
2> set controlfile autobackup format for device type disk to '/opt/backup/%F';
3> restore controlfile from autobackup; }

executing command: SET CONTROLFILE AUTOBACKUP FORMAT
using target database control file instead of recovery catalog

Starting restore at 09-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=383 device type=DISK

channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140509
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140508
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140507
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140506
channel ORA_DISK_1: AUTOBACKUP found: /opt/backup/c-174105117-20140506-00
channel ORA_DISK_1: restoring control file from AUTOBACKUP /opt/backup/c-174105117-20140506-00
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/opt/oracle/db/apps_st/data/cntrl01.dbf
output file name=/opt/oracle/db/apps_st/data/cntrl02.dbf
output file name=/opt/oracle/db/apps_st/data/cntrl03.dbf
Finished restore at 09-MAY-14

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> run {
2> allocate channel disk1 device type disk format '/opt/backup/%F';
3> restore database; }

allocated channel: disk1
channel disk1: SID=383 device type=DISK

Starting restore at 09-MAY-14

skipping datafile 1; already restored to file /opt/oracle/db/apps_st/data/system01.dbf
skipping datafile 5; already restored to file /opt/oracle/db/apps_st/data/system05.dbf
skipping datafile 7; already restored to file /opt/oracle/db/apps_st/data/owad01.dbf
skipping datafile 8; already restored to file /opt/oracle/db/apps_st/data/a_queue02.dbf
skipping datafile 11; already restored to file /opt/oracle/db/apps_st/data/sysaux01.dbf
skipping datafile 16; already restored to file /opt/oracle/db/apps_st/data/a_ref03.dbf
skipping datafile 31; already restored to file /opt/oracle/db/apps_st/data/a_media02.dbf
skipping datafile 36; already restored to file /opt/oracle/db/apps_st/data/a_archive02.dbf
skipping datafile 40; already restored to file /opt/oracle/db/apps_st/data/system13.dbf
skipping datafile 45; already restored to file /opt/oracle/db/apps_st/data/a_txn_data08.dbf
skipping datafile 49; already restored to file /opt/oracle/db/apps_st/data/sysaux07.dbf
skipping datafile 53; already restored to file /opt/oracle/db/apps_st/data/undo10.dbf
skipping datafile 56; already restored to file /opt/oracle/db/apps_st/data/a_queue03.dbf
skipping datafile 58; already restored to file /opt/oracle/db/apps_st/data/undo13.dbf
skipping datafile 62; already restored to file /opt/oracle/db/apps_st/data/undo14.dbf
skipping datafile 353; already restored to file /opt/oracle/db/apps_st/data/system08.dbf
skipping datafile 393; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind01.dbf
skipping datafile 394; already restored to file /opt/oracle/db/apps_st/data/a_ref01.dbf
skipping datafile 399; already restored to file /opt/oracle/db/apps_st/data/a_queue01.dbf
skipping datafile 401; already restored to file /opt/oracle/db/apps_st/data/a_txn_data02.dbf
skipping datafile 2; already restored to file /opt/oracle/db/apps_st/data/system02.dbf
skipping datafile 9; already restored to file /opt/oracle/db/apps_st/data/odm.dbf
skipping datafile 12; already restored to file /opt/oracle/db/apps_st/data/apps_ts_tools01.dbf
skipping datafile 13; already restored to file /opt/oracle/db/apps_st/data/system12.dbf
skipping datafile 15; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind06.dbf
skipping datafile 17; already restored to file /opt/oracle/db/apps_st/data/a_int02.dbf
skipping datafile 18; already restored to file /opt/oracle/db/apps_st/data/sysaux02.dbf
skipping datafile 19; already restored to file /opt/oracle/db/apps_st/data/a_cane_data01.dbf
skipping datafile 33; already restored to file /opt/oracle/db/apps_st/data/a_txn_data07.dbf
skipping datafile 34; already restored to file /opt/oracle/db/apps_st/data/ctxd03.dbf
skipping datafile 39; already restored to file /opt/oracle/db/apps_st/data/undo05.dbf
skipping datafile 42; already restored to file /opt/oracle/db/apps_st/data/a_summ02.dbf
skipping datafile 44; already restored to file /opt/oracle/db/apps_st/data/a_int05.dbf
skipping datafile 48; already restored to file /opt/oracle/db/apps_st/data/undo07.dbf
skipping datafile 52; already restored to file /opt/oracle/db/apps_st/data/undo09.dbf
skipping datafile 57; already restored to file /opt/oracle/db/apps_st/data/undo12.dbf
skipping datafile 61; already restored to file /opt/oracle/db/apps_st/data/system14.dbf
skipping datafile 314; already restored to file /opt/oracle/db/apps_st/data/portal01.dbf
skipping datafile 392; already restored to file /opt/oracle/db/apps_st/data/a_txn_data01.dbf
skipping datafile 398; already restored to file /opt/oracle/db/apps_st/data/a_archive01.dbf
skipping datafile 400; already restored to file /opt/oracle/db/apps_st/data/a_media01.dbf
skipping datafile 405; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind04.dbf
skipping datafile 3; already restored to file /opt/oracle/db/apps_st/data/system03.dbf
skipping datafile 10; already restored to file /opt/oracle/db/apps_st/data/olap.dbf
skipping datafile 14; already restored to file /opt/oracle/db/apps_st/data/a_txn_data04.dbf
skipping datafile 20; already restored to file /opt/oracle/db/apps_st/data/a_txn_data05.dbf
skipping datafile 21; already restored to file /opt/oracle/db/apps_st/data/sysaux03.dbf
skipping datafile 23; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind07.dbf
skipping datafile 25; already restored to file /opt/oracle/db/apps_st/data/ctxd02.dbf
skipping datafile 26; already restored to file /opt/oracle/db/apps_st/data/sysaux04.dbf
skipping datafile 27; already restored to file /opt/oracle/db/apps_st/data/sysaux05.dbf
skipping datafile 28; already restored to file /opt/oracle/db/apps_st/data/odm01.dbf
skipping datafile 29; already restored to file /opt/oracle/db/apps_st/data/a_txn_data06.dbf
skipping datafile 38; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind09.dbf
skipping datafile 43; already restored to file /opt/oracle/db/apps_st/data/a_int04.dbf
skipping datafile 47; already restored to file /opt/oracle/db/apps_st/data/undo06.dbf
skipping datafile 51; already restored to file /opt/oracle/db/apps_st/data/undo08.dbf
skipping datafile 55; already restored to file /opt/oracle/db/apps_st/data/a_txn_data09.dbf
skipping datafile 60; already restored to file /opt/oracle/db/apps_st/data/a_txn_data10.dbf
skipping datafile 295; already restored to file /opt/oracle/db/apps_st/data/system06.dbf
skipping datafile 354; already restored to file /opt/oracle/db/apps_st/data/system11.dbf
skipping datafile 403; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind02.dbf
skipping datafile 404; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind03.dbf
skipping datafile 407; already restored to file /opt/oracle/db/apps_st/data/a_ref02.dbf
skipping datafile 4; already restored to file /opt/oracle/db/apps_st/data/system04.dbf
skipping datafile 6; already restored to file /opt/oracle/db/apps_st/data/ctxd01.dbf
skipping datafile 22; already restored to file /opt/oracle/db/apps_st/data/undo02.dbf
skipping datafile 24; already restored to file /opt/oracle/db/apps_st/data/undo03.dbf
skipping datafile 30; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind08.dbf
skipping datafile 32; already restored to file /opt/oracle/db/apps_st/data/a_nolog02.dbf
skipping datafile 35; already restored to file /opt/oracle/db/apps_st/data/sysaux06.dbf
skipping datafile 37; already restored to file /opt/oracle/db/apps_st/data/undo04.dbf
skipping datafile 41; already restored to file /opt/oracle/db/apps_st/data/a_int03.dbf
skipping datafile 46; already restored to file /opt/oracle/db/apps_st/data/a_int06.dbf
skipping datafile 50; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind10.dbf
skipping datafile 54; already restored to file /opt/oracle/db/apps_st/data/undo11.dbf
skipping datafile 59; already restored to file /opt/oracle/db/apps_st/data/sysaux08.dbf
skipping datafile 288; already restored to file /opt/oracle/db/apps_st/data/system10.dbf
skipping datafile 351; already restored to file /opt/oracle/db/apps_st/data/system07.dbf
skipping datafile 352; already restored to file /opt/oracle/db/apps_st/data/system09.dbf
skipping datafile 379; already restored to file /opt/oracle/db/apps_st/data/undo01.dbf
skipping datafile 395; already restored to file /opt/oracle/db/apps_st/data/a_int01.dbf
skipping datafile 396; already restored to file /opt/oracle/db/apps_st/data/a_summ01.dbf
skipping datafile 397; already restored to file /opt/oracle/db/apps_st/data/a_nolog01.dbf
skipping datafile 402; already restored to file /opt/oracle/db/apps_st/data/a_txn_data03.dbf
skipping datafile 406; already restored to file /opt/oracle/db/apps_st/data/a_txn_ind05.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 09-MAY-14

RMAN> recover database;

Starting recover at 09-MAY-14
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/09/2014 12:43:34
ORA-19698: /opt/oracle/db/apps_st/data/log01a.dbf is from different database: id=258686669, db_name=PROD

RMAN> exit

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613686 is a reply to message #613685]

Fri, 09 May 2014 03:03

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

It was a cold backup, so do not RECOVER. Simply ALTER DATABASE OPEN RESETLOGS;

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613687 is a reply to message #613686]

Fri, 09 May 2014 03:06

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

No it was hot backup. The system was in running state when this backup was taken.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613688 is a reply to message #613687]

Fri, 09 May 2014 03:07

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Michel Cadot please update.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613689 is a reply to message #613688]

Fri, 09 May 2014 03:10

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

theowais wrote on Fri, 09 May 2014 09:07

Michel Cadot please update.

OK, goodbye. Sorry to have wasted your time. And mine.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613691 is a reply to message #613685]

Fri, 09 May 2014 03:17

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

ORA-19698: /opt/oracle/db/apps_st/data/log01a.dbf is from different database: id=258686669, db_name=PROD

Provide files that are from the original database.
Best way is to (re)move all files and restart from the beginning.

John was trying to help you, it is very bad and rude from you to ignore him. In addition, it is counter-productive as I'm not always there (and indeed I will be off for 8 hours) and this will prevent other people from trying to help you not knowing if you will have the same behaviour towards them.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613698 is a reply to message #613691]

Fri, 09 May 2014 05:03

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Apologies for misunderstanding John Watson and Michel Cadot. I was answering both of you individually.
Again I'm sorry. Please do not leave it and help me to resolve the issue.

Please explain how to (re)move all files and restart from the beginning.

regards,

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613703 is a reply to message #613698]

Fri, 09 May 2014 06:12

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

theowais wrote on Fri, 09 May 2014 11:03

Apologies for misunderstanding John Watson and Michel Cadot. I was answering both of you individually.
Again I'm sorry. Please do not leave it and help me to resolve the issue.

Please explain how to (re)move all files and restart from the beginning.

regards,

All right, one more try.
First, you remove files with the rm command.
Second, your problems are, as I said before, because what you doing will not work. You appear to be restoring a database, changing its dbid, and then attempting to recover. You can't do that.

I see that you are working on an EBS database. Can you explain what you are actually want to do? For example, are you trying to clone the EBS instance? If so, you should follow the instructions for the Rapid Clone process. Or are you trying to clone only the database? In which case, you should do an RMAN duplicate.

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613705 is a reply to message #613703]

Fri, 09 May 2014 06:43

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Quote:

Thanks

What files are you be removed?
All files on following location:
"/opt/oracle/db/apps_st/data/"

Actually I want to solve following error:
RA-19698: /opt/oracle/db/apps_st/data/log01a.dbf is from different database: id=258686669, db_name=PROD

Initially our EBS was configured for cold backup now we shift it on hot backup and when we restore the hot backup it generate error. I want to successfully restore the hot backup successfully.

regards,

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613707 is a reply to message #613705]

Fri, 09 May 2014 07:03

John Watson
Messages: 8929
Registered: January 2010
Location: Global Village

Senior Member

Yes, all very interesting, but what are you actually trying to achieve? For example, if all you want to do a clone the database to another mahcine, use an RMAN duplicate. If you want to do something else, what is it?

Report message to a moderator

Re: ora 19698 file is from different database id= db_name= [message #613708 is a reply to message #613688]

Fri, 09 May 2014 07:11

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

theowais wrote on Fri, 09 May 2014 03:07

Michel Cadot please update.

Pardon me for jumping in, but this message was posted a mere one minute after your previous message. Please note that this forum is not a chat line. It is a global forum with participants scattered across 24 time zones. While you were just sitting down with your first cup of coffee, someone responding to your post may be finishing his day and starting to shut down and go do something else. Also that all participants have real jobs (and this forum isn't it) and simply participate here "in the cracks".

If you have a truly urgent situation, you should open an SR with oracle support.

Report message to a moderator

Previous Topic:	Undo tablespace corrupt
Next Topic:	RMAN Backup of archivelog failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 17 22:52:12 CDT 2024