OraFAQ Forum: Backup & Recovery » Help with backup

Home » RDBMS Server » Backup & Recovery » Help with backup (Oracle + windows)

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

Help with backup [message #679472]

Wed, 04 March 2020 08:59

yordan
Messages: 18
Registered: March 2020

Junior Member

Hello everybody, I need some help, I am neewie in Oracle, I have used other database servers (Postgresql, Sql server, Mysql, etc) but now I need to restore database backup in Oracle, the problem is that I dont know how to do it, I already have installed the Oracle 18c version, but I dont know how to restore the database. Here is the structure of the backup I have to load.

ASCP
Apps_TechStack
PVWSC.tar ....... 7.98gb
archivedlog
PVWSC.tar ....... 1.37gb
datafile
PVWSC.tar ....... 4.63gb
RDBMS_TechStack
102.tar ....... 1.15gb

Please can some one give me a clue of how to load this backup?

Report message to a moderator

Re: Help with backup [message #679473 is a reply to message #679472]

Wed, 04 March 2020 09:59

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is it an RMAN backup?

Report message to a moderator

Re: Help with backup [message #679474 is a reply to message #679473]

Wed, 04 March 2020 10:03

yordan
Messages: 18
Registered: March 2020

Junior Member

I can't tell, I just have this files, and it does not look like anything else I have seen before. How can I know if it is efectively a RMAN backup?

All final files are just .tar with a file inside without extension ... Confused

Confused

Confused

Confused

[Updated on: Wed, 04 March 2020 10:05]

Report message to a moderator

Re: Help with backup [message #679475 is a reply to message #679474]

Wed, 04 March 2020 10:15

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use an hexadecimal editor (for instance XVI32 on windows) and post the first 50 bytes of a file (not a tar).
Also give the list of files you have inside the tars.

Report message to a moderator

Re: Help with backup [message #679476 is a reply to message #679475]

Wed, 04 March 2020 10:18

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Can't the person who gave you the backups tell you what they are?

Report message to a moderator

Re: Help with backup [message #679477 is a reply to message #679472]

Wed, 04 March 2020 10:20

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

We'd have to know exactly how the files were created. The fact that they are named '.tar' suggests they were NOT made using oracle's rman (recovery manager) utility.

The fact that they are named .tar would suggest (though not definitively prove) that they were created by simply copying the various database files into the tar files.

In order to recover, we'd have to know exactly:
1) how they were created
2) the exact version and patch level of the database they were created from.
3) the exact version and patch level of the system you are restoring to. You said '19c', but that is not precise enough.
4) the OS of the source database.
4) the names of all of the files contained within the various tar files. (In case you are "windows centric" and don't know, 'tar' is a unix/linux file format for packaging multiple files into a single file, similar to a zip file.)

The backup would need to include the following, within those tar files:
1) database initialization parameter file (typically named init<sid>.ora) or spfile (typically named spfile<sid>.ora)
1a) the contents of both of the above. Note that the spfile is actually a binary, in spite of it being mostly clear text. As such, it should not be modfied by a text editor.
2) database control file, typically named control<nn>.ctl.
3) all of the actual database files, typically named tablespace_name<nn>.dbf.

How to actually proceed would depend on the answers to all of the above. The most important first question is the first one I posed: Exactly how were these tar files created?

Report message to a moderator

Re: Help with backup [message #679478 is a reply to message #679477]

Wed, 04 March 2020 10:42

yordan
Messages: 18
Registered: March 2020

Junior Member

In fact, the database came from an old system in my enterprise, I am new here and they gave me this job, they just saved those files, but they don't have enough information about de files they saved. They just know it is a backup of the database, as I am seeing, they do not use Linux in any of their servers , so I am supossing the system was on windows and they are telling me that the system was in the r11 oracle version system. The tar files only have one file inside.

ASCP\Apps_TechStack\PVWSC.tar ...... PVWSC
ASCP\archivedlog\PVWSC.tar ...... PVWSC
ASCP\datafile\PVWSC.tar ...... PVWSC
ASCP\RDBMS_TechStack\102.tar ...... 102

Attachment: backup.png
(Size: 20.50KB, Downloaded 2911 times)

[Updated on: Wed, 04 March 2020 10:44]

Report message to a moderator

Re: Help with backup [message #679479 is a reply to message #679478]

Wed, 04 March 2020 10:44

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post what I asked.

Report message to a moderator

Re: Help with backup [message #679506 is a reply to message #679478]

Thu, 05 March 2020 11:01

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

Senior Member

Quote:

ASCP\Apps_TechStack\PVWSC.tar ...... PVWSC
ASCP\archivedlog\PVWSC.tar ...... PVWSC
ASCP\datafile\PVWSC.tar ...... PVWSC
ASCP\RDBMS_TechStack\102.tar ...... 102

That looks like tar balls of an EBS system. You have no chance of getting that going. You might be able to extract the database from PVWSC.tar and open it with 10.2 database instance, but probably not if you are new to db admin.

Report message to a moderator

Re: Help with backup [message #679507 is a reply to message #679506]

Thu, 05 March 2020 14:29

yordan
Messages: 18
Registered: March 2020

Junior Member

Uff thanks a lot John Watson for your lack of support, that's not the kind of answer I'm searching, thanks anyway, I'll find a solution with the people who really wants to help and I will share with them and with you.

Report message to a moderator

Re: Help with backup [message #679508 is a reply to message #679507]

Thu, 05 March 2020 15:04

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

Senior Member

I've told you which tar ball you need to extract. I've told you which release of Oracle you need to install to open the database. I've also suggested that this is not a job for a beginner. Uff! Smile

Smile

Report message to a moderator

Re: Help with backup [message #679509 is a reply to message #679508]

Thu, 05 March 2020 15:26

yordan
Messages: 18
Registered: March 2020

Junior Member

Ok, sorry, my mistake, the problem is that even with your sugestions, I still need to make it, because there is no one that can do it, even if it is not for beginners (take into account that I am beginer with oracle, I already have a lot of experience with postgresql, sql server, mysql, etc...)

[Updated on: Thu, 05 March 2020 15:27]

Report message to a moderator

Re: Help with backup [message #679510 is a reply to message #679509]

Thu, 05 March 2020 15:36

yordan
Messages: 18
Registered: March 2020

Junior Member

Hi Michel Cadot, I could finally unpack the files using ubuntu, it give a message that the file were corrupted, but still it did it. Rigth here are the list of files inside .tar.

Re: Help with backup [message #679511 is a reply to message #679510]

Thu, 05 March 2020 18:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

IMO, NONE of the files in the most recent post are database files.

Report message to a moderator

Re: Help with backup [message #679512 is a reply to message #679510]

Thu, 05 March 2020 18:55

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

I agree with BlackSwan. Those are not database files. Period. Full stop. From the directory name, I'd guess they are part of some java installation and have nothing whatsoever to do with an oracle database.

I'm afraid you've been put in an untenable position. To put this in medical terms, you may well be a very experienced doctor with 20 years of practice in internal medicine, but what you are presented with here is a gunshot wound to the head. You can rail against those who don't give you ready-made fix, but you have to consider the very distinct possibility (and growing more apparent with each post) that the task you've been given is fundamentally impossible - for anyone of any skill level.

Report message to a moderator

Re: Help with backup [message #679513 is a reply to message #679510]

Fri, 06 March 2020 00:59

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

Senior Member

I've already told you the file you need to unpack: the one with the database, presumably ASCP\datafile\PVWSC.tar. You have unpacked some of the apps tech stack, you cannot do anything with that. Whether you can do anything with the database depends on whether you can find a a copy of the 10g database software with which to open it. You certainly can't open it with the 18c you say you have installed.

[Updated on: Fri, 06 March 2020 01:07]

Report message to a moderator

Re: Help with backup [message #679517 is a reply to message #679513]

Fri, 06 March 2020 08:29

yordan
Messages: 18
Registered: March 2020

Junior Member

John Watson, I alrready said sorry, my first impresion was that you where trying to make firewood from the fallen tree, my intention is not to fight, actually I am just searching knowledge from specialists with more experience than me, I am very gratefull if you are just trying to help, even if your response wont help me...

[Updated on: Fri, 06 March 2020 08:46]

Report message to a moderator

Re: Help with backup [message #679518 is a reply to message #679517]

Fri, 06 March 2020 09:14

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So post the list of files in "ASCP\datafile\PVWSC.tar" as John suggested the one you posted seems to come from "ASCP\Apps_TechStack\PVWSC.tar".
Also it seems your files are from Linux/Unix environment, you cannot "restore" then on Windows just untaring.

Report message to a moderator

Re: Help with backup [message #679522 is a reply to message #679518]

Fri, 06 March 2020 11:27

yordan
Messages: 18
Registered: March 2020

Junior Member

Hi, I alrready have instaled oracle 10g version in ubuntu 19.04, and untar data file, here are all the files inside. What else do you propose me to do?

[Updated on: Sat, 07 March 2020 00:20] by Moderator

Report message to a moderator

Re: Help with backup [message #679523 is a reply to message #679522]

Fri, 06 March 2020 11:32

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you on Windows or on Linux?

Report message to a moderator

Re: Help with backup [message #679524 is a reply to message #679523]

Fri, 06 March 2020 11:34

yordan
Messages: 18
Registered: March 2020

Junior Member

I have both OS, initially I was on windows, but you suggested linux, so...
The OS is not a problem...

[Updated on: Fri, 06 March 2020 11:35]

Report message to a moderator

Re: Help with backup [message #679525 is a reply to message #679524]

Fri, 06 March 2020 11:42

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK.
Forget the "Apps_TechStack" stuff.
Restore the other directories on your Ubuntu system; don't mix them with your Oracle installation.
Post what you have:

ls /u01

And point the directories you just restore.
Post your Oracle home directory.

[Updated on: Fri, 06 March 2020 11:44]

Report message to a moderator

Re: Help with backup [message #679527 is a reply to message #679525]

Fri, 06 March 2020 11:57

yordan
Messages: 18
Registered: March 2020

Junior Member

Ok, here is my oracle home directory

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

"u01" have just one folder inside: "oradata"
"oradata" have just one folder inside: "PVWSC"
and "PVWSC" have all the files inside by this way:

u01/
oradata/
PVWSC/
a_archive01.dbf
a_archive02.dbf
a_int01.dbf
a_media01.dbf
a_nolog01.dbf
a_queue01.dbf
a_ref01.dbf
a_ref02.dbf
a_tools01.dbf
a_txn_data01.dbf
a_txn_data02.dbf
a_txn_data03.dbf
a_txn_ind01.dbf
a_txn_ind02.dbf
a_txn_ind03.dbf
a_txn_ind04.dbf
a_txn_ind05.dbf
cntrl01.dbf
cntrl02.dbf
log01a.dbf
log01b.dbf
log02a.dbf
log02b.dbf
odm.dbf
olap.dbf
perfstat1.dbf
perfstat2.dbf
perfstat.dbf
portal01.dbf
system01.dbf
system02.dbf
system03.dbf
system04.dbf
system05.dbf
system06.dbf
system07.dbf
system08.dbf
system09.dbf
system10.dbf
system11.dbf
temp01.dbf
temp02.dbf
undo01.dbf

Report message to a moderator

Re: Help with backup [message #679528 is a reply to message #679527]

Fri, 06 March 2020 12:16

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think this comes from "ASCP\datafile\PVWSC.tar", doesn't it?
Or is this also from "ASCP\archivedlog\PVWSC.tar" and "ASCP\RDBMS_TechStack\102.tar"?

Report message to a moderator

Re: Help with backup [message #679529 is a reply to message #679528]

Fri, 06 March 2020 12:18

yordan
Messages: 18
Registered: March 2020

Junior Member

No, is just ASCP\datafile\PVWSC.tar", do you need me to post other files?

Report message to a moderator

Re: Help with backup [message #679531 is a reply to message #679529]

Fri, 06 March 2020 12:46

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, this is what I said, all but "Apps_TechStack".

Report message to a moderator

Re: Help with backup [message #679535 is a reply to message #679531]

Fri, 06 March 2020 13:10

yordan
Messages: 18
Registered: March 2020

Junior Member

Oh, sorry, here are all the files:

archivedlog:
E:\oracle\WDBackup\ASCP\archivedlog\lista.txt
E:\oracle\WDBackup\ASCP\archivedlog\PVWSC.tar
E:\oracle\WDBackup\ASCP\archivedlog\u01
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788595_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788602_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788660_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788843_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788845_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788852_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788869_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_788895_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_795969_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_795986_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_795999_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796014_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796026_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796028_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796033_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796036_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796054_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796089_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796111_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796120_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796134_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796142_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796160_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796180_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796210_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796211_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796259_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796261_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796281_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796291_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796298_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796299_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796330_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796341_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796376_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796388_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796408_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\PVWSC_796411_1_802735448.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690834_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690845_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690851_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690857_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690864_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690873_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690902_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690915_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690970_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690978_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_690996_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_691004_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_691094_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_691135_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_691143_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_691169_1_657294787.arc
E:\oracle\WDBackup\ASCP\archivedlog\u01\archive\PVWSC\VWPA_691174_1_657294787.arc

Report message to a moderator

Re: Help with backup [message #679536 is a reply to message #679535]

Fri, 06 March 2020 13:10

yordan
Messages: 18
Registered: March 2020

Junior Member

datafile:
E:\oracle\WDBackup\ASCP\datafile\u01
E:\oracle\WDBackup\ASCP\datafile\u01\oradata
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\lista.txt
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_archive01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_archive02.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_int01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_media01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_nolog01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_queue01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_ref01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_ref02.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_tools01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_data01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_data02.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_data03.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_ind01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_ind02.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_ind03.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_ind04.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\a_txn_ind05.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\cntrl01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\cntrl02.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\log01a.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\log01b.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\log02a.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\log02b.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\odm.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\olap.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\perfstat.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\perfstat1.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\perfstat2.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\portal01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system02.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system03.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system04.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system05.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system06.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system07.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system08.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system09.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system10.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\system11.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\temp01.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\temp02.dbf
E:\oracle\WDBackup\ASCP\datafile\u01\oradata\PVWSC\undo01.dbf

Report message to a moderator

Re: Help with backup [message #679538 is a reply to message #679536]

Fri, 06 March 2020 13:14

yordan
Messages: 18
Registered: March 2020

Junior Member

Here are the txt files of each folder because in the RDBMS_TechStack folder, are a lot of files, so the txt file with the names was too large.

archivedlog:
https://drive.google.com/open?id=1ciEn1lkKupo1QiXiPjFMEgLFb4n1JcuC

datafile:
https://drive.google.com/open?id=1rTyeglsocLEC9seeqguW02RTP8hM96sG

RDBMS_TechStack:
https://drive.google.com/open?id=1W_IM81SPVnw3tpxDdCxeVA9BmBsifdDN

[Updated on: Fri, 06 March 2020 13:26]

Report message to a moderator

Re: Help with backup [message #679539 is a reply to message #679538]

Fri, 06 March 2020 13:24

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Is there a "dbs" sub-directory? if so then post it.

Report message to a moderator

Re: Help with backup [message #679541 is a reply to message #679539]

Fri, 06 March 2020 13:32

yordan
Messages: 18
Registered: March 2020

Junior Member

Actually there is a dbs folder in

\ASCP\RDBMS_TechStack\u01\app\orapc\product\PVWSC\102\appsutil\template

but is an empty folder...

Report message to a moderator

Re: Help with backup [message #679542 is a reply to message #679535]

Fri, 06 March 2020 13:33

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

Senior Member

Quote:

Ok, here is my oracle home directory

ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

Have you installed the XE edition? You can't open an EBS database with that. You need the real thing: Enterprise Edition plus all the extras.

Report message to a moderator

Re: Help with backup [message #679543 is a reply to message #679542]

Fri, 06 March 2020 13:40

yordan
Messages: 18
Registered: March 2020

Junior Member

ok, let me install it

Report message to a moderator

Re: Help with backup [message #679544 is a reply to message #679543]

Fri, 06 March 2020 13:54

yordan
Messages: 18
Registered: March 2020

Junior Member

Is there any url where I can download de oracle 10g Enterprise Edition version for linux? because in oracle url are all versions from 11 ahead, the 10th version is not there...

Report message to a moderator

Re: Help with backup [message #679548 is a reply to message #679544]

Sat, 07 March 2020 00:43

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Your RDBMS_TechStack/102.tar seems to contain a backup of your original Oracle 10.2 home.
You may try to use it, however I'm surprised there is no "ORACLE_HOME/dbs" directory and other ones like that, so I think it is not complete.
Anyway, extract it on your Ubuntu system and post the content of oraInst.loc.bak file.

Report message to a moderator

Re: Help with backup [message #679551 is a reply to message #679544]

Sat, 07 March 2020 03:12

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

Senior Member

yordan wrote on Fri, 06 March 2020 19:54

Is there any url where I can download de oracle 10g Enterprise Edition version for linux? because in oracle url are all versions from 11 ahead, the 10th version is not there...

You will not be able to get this legally, because your system is not under a support contract. You may be able to get it from the .tar as Michel says, but at the very least you will have to relink it before it will be usable.

What you are attempting would be a long and hard process for a top notch Apps DBA (neither Michel nor I is one of them) with no guarantee of success. You need to set the expectations of your employer accordingly, if you haven't done that yet, better do so pronto.

Report message to a moderator

Re: Help with backup [message #679553 is a reply to message #679551]

Sat, 07 March 2020 12:00

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As John says, we may be able to lead you to get your database but we are not skilled about the application part.

[Updated on: Sun, 08 March 2020 01:39]

Report message to a moderator

Re: Help with backup [message #679555 is a reply to message #679553]

Sat, 07 March 2020 18:17

yordan
Messages: 18
Registered: March 2020

Junior Member

Don't worry about the applpication, I just need the data, thanks a lot...

Report message to a moderator

Re: Help with backup [message #679556 is a reply to message #679555]

Sun, 08 March 2020 01:35

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

Senior Member

yordan wrote on Sun, 08 March 2020 00:17

Don't worry about the applpication, I just need the data, thanks a lot...

I do suspect that you are still under estimating this task. A typical EBS database might have 50,000 tables. Perhaps 100,000 depending on options and configuration. This data is incomprehensible to an unskilled user. It is presented to users through views and forms that make it meaningful. So without the middle tier, you are unlikely to be able to extract much useful. To take a trivial example, if you want to query orders, will you query PO_LINES_ARCHIVE_ALL, SO_ORDERS_ALL, OE_ORDER_HEADERS_ALL, OE_ORDER_HEADERS_ALL_EXT_B, OP_ORDR_DTL, or something else? Getting the database opened is only the first part.

Report message to a moderator

Previous Topic:	19c pdb duplication
Next Topic:	Point In Time recovery with timestamp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 17 20:10:16 CST 2024