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 188.8.131.52 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.
Just wanted to know if the script will be ok on the solaris platform?
Those are the script:
C:\ORACLE\bin\oradim -new -sid TEST -startmode manual -pfile "C:\ORACLE\admin\test\pfile\inittest.ora"
C:\ORACLE\bin\sqlplus internal/ @C:\temp\oracle\testcontext.sql
C:\ORACLE\bin\sqlplus SYSTEM/manager @C:\temp\oracle\testspatial1.sql
C:\ORACLE\bin\sqlplus system/manager @C:\temp\oracle\testsqlplus.sql
C:\ORACLE\bin\oradim -edit -sid test -startmode auto
It is basic database creation and tablespace, rollback, etc...
Just want to know if i need to run something else for the sun?
there is no oraidm in UNIX, other than that, creation should be standard
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?
Am I missing something, or is it blindingly obvious that the script will not work because there is no such location on the solaris box as "C:\".
I'd also like to know what was in those SQL files as well, 'cos they are probably full of "C:\" and other non-existant locations as well.
I think you need to read the Oracle documentation for Solaris
I changed the directory names of course, it work, thx for the info.
My new instance is fine and database is ok.
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.
I'm no backup/recovery expert, but I don't think you can do a recovery from archived log files based on an import. It has to be from a full backup, including control files etc.
I think there might be a way of recovering though if you have all archive logs since db creation, but I'm not familiar enough with the subject to advise on it.
You cannot use an import and archive logs together.
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.
I have all archive log since the databse creation, how do i recover on a new database?
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?
I issued a alterdatabase backup controlfile to trace;
i have the control file from now