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

Thread: System file recovery Help

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    System file recovery Help

    Hi Guys
    Need you help to recover this NEW detabase. NO BACKUP
    I had to recreate the controlfile and now it is complaining about recovering the system file.
    Any suggestion and recommendation and appreciated.
    Thanks



    Total System Global Area 6442450944 bytes
    Fixed Size 2050200 bytes
    Variable Size 687871848 bytes
    Database Buffers 5737807872 bytes
    Redo Buffers 14721024 bytes

    Database mounted.

    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


    SQL> alter database open resetlogs;

    alter database open resetlogs

    *

    ERROR at line 1:

    ORA-01194: file 1 needs more recovery to be consistent

    ORA-01110: data file 1:

    '/opt/app/hmpm1d1/oradata01/HMPROD/dbf/system_01.dbf'
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Was your database in archivelog mode?

    Make sure archivelogs are available and in the right location.

    Make sure the first line of your control file reads like...
    CREATE CONTROLFILE REUSE SET DATABASE "your_db_name" RESETLOGS ARCHIVELOG

    sqlplus /nolog
    conn sys as sysdba
    --hit enter--
    STARTUP NOMOUNT
    @/your_path/your_control_file.sql
    RECOVER DATABASE USING BACKUP CONTROLFILE until cancel
    --apply your logs--
    alter database open resetlogs;

    Once your database is up, bounce it and be sure your alertlog is clean.

    Put together a backup strategy.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Feb 2009
    Posts
    3
    If you dont have any backup then you can just mimic the recovery process something like this

    SQL> startup mount;
    SQL> recover database;
    SQL> alter database open resetlogs;

    After that shutdown the db and take a cold backup and the restart the db in normal fashion.

    Hope this helps.

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    374

    the database

    This database is a newly created database that is having issues. Did not get to the point to open it even yet.
    I need to do the recovery and open it and have no backup and not in archivelog yet
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

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