Home » RDBMS Server » Backup & Recovery » Help with backup (Oracle + windows)
Help with backup [message #679472] Wed, 04 March 2020 08:59 Go to next message
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?
Re: Help with backup [message #679473 is a reply to message #679472] Wed, 04 March 2020 09:59 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is it an RMAN backup?
Re: Help with backup [message #679474 is a reply to message #679473] Wed, 04 March 2020 10:03 Go to previous messageGo to next message
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

[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 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Help with backup [message #679476 is a reply to message #679475] Wed, 04 March 2020 10:18 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
Can't the person who gave you the backups tell you what they are?
Re: Help with backup [message #679477 is a reply to message #679472] Wed, 04 March 2020 10:20 Go to previous messageGo to next message
EdStevens
Messages: 1283
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?
Re: Help with backup [message #679478 is a reply to message #679477] Wed, 04 March 2020 10:42 Go to previous messageGo to next message
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 139 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 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post what I asked.

Re: Help with backup [message #679506 is a reply to message #679478] Thu, 05 March 2020 11:01 Go to previous messageGo to next message
John Watson
Messages: 8428
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.
Re: Help with backup [message #679507 is a reply to message #679506] Thu, 05 March 2020 14:29 Go to previous messageGo to next message
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.

Re: Help with backup [message #679508 is a reply to message #679507] Thu, 05 March 2020 15:04 Go to previous messageGo to next message
John Watson
Messages: 8428
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
Re: Help with backup [message #679509 is a reply to message #679508] Thu, 05 March 2020 15:26 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.

Toggle Spoiler
Re: Help with backup [message #679511 is a reply to message #679510] Thu, 05 March 2020 18:08 Go to previous messageGo to next message
BlackSwan
Messages: 26756
Registered: January 2009
Location: SoCal
Senior Member
IMO, NONE of the files in the most recent post are database files.
Re: Help with backup [message #679512 is a reply to message #679510] Thu, 05 March 2020 18:55 Go to previous messageGo to next message
EdStevens
Messages: 1283
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.
Re: Help with backup [message #679513 is a reply to message #679510] Fri, 06 March 2020 00:59 Go to previous messageGo to next message
John Watson
Messages: 8428
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Help with backup [message #679522 is a reply to message #679518] Fri, 06 March 2020 11:27 Go to previous messageGo to next message
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?

Toggle Spoiler

[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 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Are you on Windows or on Linux?

Re: Help with backup [message #679524 is a reply to message #679523] Fri, 06 March 2020 11:34 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Help with backup [message #679528 is a reply to message #679527] Fri, 06 March 2020 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
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"?

Re: Help with backup [message #679529 is a reply to message #679528] Fri, 06 March 2020 12:18 Go to previous messageGo to next message
yordan
Messages: 18
Registered: March 2020
Junior Member
No, is just ASCP\datafile\PVWSC.tar", do you need me to post other files?
Re: Help with backup [message #679531 is a reply to message #679529] Fri, 06 March 2020 12:46 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Help with backup [message #679535 is a reply to message #679531] Fri, 06 March 2020 13:10 Go to previous messageGo to next message
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
Re: Help with backup [message #679536 is a reply to message #679535] Fri, 06 March 2020 13:10 Go to previous messageGo to next message
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
Re: Help with backup [message #679538 is a reply to message #679536] Fri, 06 March 2020 13:14 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Help with backup [message #679541 is a reply to message #679539] Fri, 06 March 2020 13:32 Go to previous messageGo to next message
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...
Re: Help with backup [message #679542 is a reply to message #679535] Fri, 06 March 2020 13:33 Go to previous messageGo to next message
John Watson
Messages: 8428
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.
Re: Help with backup [message #679543 is a reply to message #679542] Fri, 06 March 2020 13:40 Go to previous messageGo to next message
yordan
Messages: 18
Registered: March 2020
Junior Member
ok, let me install it
Re: Help with backup [message #679544 is a reply to message #679543] Fri, 06 March 2020 13:54 Go to previous messageGo to next message
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...
Re: Help with backup [message #679548 is a reply to message #679544] Sat, 07 March 2020 00:43 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Help with backup [message #679551 is a reply to message #679544] Sat, 07 March 2020 03:12 Go to previous messageGo to next message
John Watson
Messages: 8428
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.
Re: Help with backup [message #679553 is a reply to message #679551] Sat, 07 March 2020 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 67549
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
yordan
Messages: 18
Registered: March 2020
Junior Member
Don't worry about the applpication, I just need the data, thanks a lot...
Re: Help with backup [message #679556 is a reply to message #679555] Sun, 08 March 2020 01:35 Go to previous message
John Watson
Messages: 8428
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.
Previous Topic: 19c pdb duplication
Next Topic: Point In Time recovery with timestamp
Goto Forum:
  


Current Time: Mon Nov 30 14:06:08 CST 2020