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.

Just wanted to know if the script will be ok on the solaris platform?

Those are the script:
set ORACLE_SID=test
C:\ORACLE\bin\oradim -new -sid TEST -startmode manual -pfile "C:\ORACLE\admin\test\pfile\inittest.ora"
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testrun.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testrun1.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testreplicate.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testjava.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testordinst.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testiMedia.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testdrsys.sql
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\svrmgrl @C:\temp\oracle\testtimeseries.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testvirage.sql
C:\ORACLE\bin\svrmgrl @C:\temp\oracle\testalterTablespace.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.

http://download-west.oracle.com/docs...gy.htm#1004582

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

So after the db is created, and you are in archivelog mode, do a backup to establish the baseline, then apply the archived log files.

Im able to connect to my corrupt database and issue a alter database backup controlefile to trace;

I have 2 years of archive log, i want to be able to recover from my full export, instead of course from the database creation.


Any idea?

If is it not possible, how to i apply my archive from a new database?

Quote:

---

Originally posted by steeve123
I have 2 years of archive log, i want to be able to recover from my full export, instead of course from the database creation.


Any idea?

If is it not possible, how to i apply my archive from a new database?

---

Again,

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.

You created new database, imported database objects and data in the new database using import, but the archivelogs are from the different database, you just can't apply them.

Assume a situation when you open database after imcomplete recovery you resetlogs. After this, all the arhivelogs from prev. incarnation of database are of no use. Same way, you have different database in your situation.

ever hear of the backup and recovery guide?
http://tahiti.oracle.com