database down
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: database down

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    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?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    there is no oraidm in UNIX, other than that, creation should be standard

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    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?

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Nov 2000
    Posts
    440
    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.

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    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

  8. #8
    Join Date
    Nov 2000
    Posts
    440
    I have all archive log since the databse creation, how do i recover on a new database?

  9. #9
    Join Date
    May 2002
    Posts
    2,645
    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?

  10. #10
    Join Date
    Nov 2000
    Posts
    440
    I issued a alterdatabase backup controlfile to trace;

    i have the control file from now

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width