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?
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?
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.
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.
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?