If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

database down

Hi, my client has his database down. Ora-600 all over the place.
He's in archive log mode and have all the archive logs since creation.
It's 8.1.7.0 running on solaris plateform.

Not sure, but it seems like their where out of disk space and they managed to copy the datafiles while the database was open or something like that.

We cannot be on the server physicaly, it is somewhere in canada, and we need to create another instance manually by telnet. I have a script that create an instance but that was created on windows platform with the installer.

Once i create my new database with the a full export from mid-november, my database will be open and ok, but i need to apply archive log until 10 december. How do i put my database in need media recovery so i recover until time?

But i still need to know how to aplly archive redo log from my full import dated 17 november, my database is open and running, i want to apply all the archive logs until 10 december, how do i put my database in need media recovery, or how do i do this correctly from the start.

The only valid backup i have is a full export from 17 november, i have all the archives logs from that date, i want to recover right before the crash.

Database exports are not a substitute for whole database backups and cannot provide the same complete recovery advantages that the built-in functionality of Oracle offers. For example, you cannot apply archived logs to logical backups in order to update lost changes. An export provides a snapshot of the logical data (tables, stored procedures, and so forth) in a database when the export was made.

What control file(s) do you have - one made at the beginning when the database was created, and therefore, only has the SCN at that time, or one that is recent - which would have a higher SCN and would be able to recognize the lower SCNs in your archived log files?