DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: retrieval of data from physical files

  1. #1
    Join Date
    Mar 2002
    Posts
    12
    Hi,

    My Nt server has crashed .
    It was having Oracle 8.0 server on it.
    There is no chance of gettinh the NT Server reparied.
    I have all the files which were used in creating the database.
    I am also able to backup the physical files of data.

    I want to recover the data from these physical files.
    is it possible to create a new database using the files above and then recover the data fromn the datafiles..

    pls help me out

    rgds
    Deepak Kapila

  2. #2
    Join Date
    Jun 2001
    Posts
    150
    Don't worry you can create the database again if you have all the database files and archived files
    use this command
    use the same init.ora file if you have
    in svrmgrl
    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "" RESETLOGS ARCHIVELOG
    MAXLOGFILES 64
    MAXLOGMEMBERS 5
    MAXDATAFILES 1022
    MAXINSTANCES 16
    MAXLOGHISTORY 1600
    LOGFILE
    GROUP 1 'DISK$REDO1:database_THR1_GRO1_MEM1.RDO' SIZE 50M,
    GROUP 2 'DISK$REDO1:database_THR1_GRO2_MEM1.RDO' SIZE 50M,
    GROUP 3 'DISK$REDO1:database_THR1_GRO3_MEM1.RDO' SIZE 50M
    DATAFILE
    'datafile1',
    'datafile2',
    'datafile3';

    resore database using backup controlfile until cancel;

    then it will ask you for archived redo log file
    provide all the archived redo log files you have and then in the end type
    cancel

    alter database open reset redologs;

    this will open your database by creating new control files and new online redo log files.

    and then you can play with it again.

    Hope that this will solve your problem.


    UKDBA


  3. #3
    Join Date
    Mar 2002
    Posts
    12
    thanks UKDBA ....

    U HAVE BOOSTED MY ENTHU
    This command i have to run from the prompt..i'll try...
    but can i create the database using the database assistant
    shipped with the oracle enterpriise manager...

    rgds
    Deepak Kapila
    dpkpl@rediffmail.com

  4. #4
    Join Date
    Jun 2001
    Posts
    150
    well to be honest i am not found of gui thinggy provided by oracle . i prefered command line so that you can use it in every operating system. To be honest i don't know about configuration assistant.
    but there is no harm running them on server manager.


    ukdba

  5. #5
    Join Date
    Mar 2002
    Posts
    12
    UKDBA,
    WOULD U PLS. TELL ME THE SEQUENCE IN WHICH TO
    EXCUTE THE COMMANDS

    RGDS
    KAPILA

  6. #6
    Join Date
    Mar 2002
    Posts
    12
    Hi,

    can any body explain me the steps one by one
    to recover the data.
    i have only operating system copies of the databse files
    and the datafiles.

    rgds
    Deepak Kapila

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    In your other post you told that your database is not running in archived log mode. The recovery method UKDBA explained is for databases in archive log mode.
    You can restore the database if you have a cold backup.

    Sanjay

  8. #8
    Join Date
    Mar 2002
    Posts
    12

    Post

    Sanjay would u pls tell me the steps to do that..

    rgds
    Deepak Kapila
    dpkpl@rediffmail.com

  9. #9
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    C if your database was not running in archive log mode.
    then u just need to install oracle as it was earlier.

    then restore the cold backup. crete sid and you will be able to make your database up.

    thatz it.

    so steps are :

    - Install oracle (use same conventions as it was earlier)
    - Restore backup from your cold backup.
    - Create new sid

    start the services and bring the database up..



    not very big deal.....
    --------------------------
    The Time has come ....

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