A
A
Arman2019-11-19 13:30:36
Oracle
Arman, 2019-11-19 13:30:36

Can I find out the version of the Oracle database by its files?

Files *.DBF, *.LOG, *.CTL are on hand.
The task is to raise a test server with them.
From the information only: this is most likely some kind of old Oracle =)
There is no access to the old database

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
ISE73, 2019-11-19
@ISE73

I'm afraid of not knowing the version of the database from these files.
All parameters are stored in a parameter file (called a PFILE) or server-side parameter file (called a SPFILE)
Of course, you can try to raise the database from all this, but it will be very difficult.
The plan is something like this:
1) Create a new database and extinguish it
2) see the SID of the databases that need to be restored in the control file.
3) change the control files, change the SID of the new base
4) decompose the files of the old base into folders "as it was"
5) try to raise the base, look for errors.
I'm "not a real DBA", so I'm probably wrong.
Worst of all will be with dictionary
ZZY and RMAN backup-and there is no old basis?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question