Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    3

    Unanswered: Help:Recovery data

    I have some file:

    build.log
    Ctl1text.ora
    Ctl2text.ora
    Index1.ora
    initTEXT.ora
    Log1text.ora
    Log2text.ora
    Rbs1orcl.ora
    Rbs2orcl.ora
    Sys1text.ora
    Text.ini
    Tmp1orcl.ora
    Usr1text.ora

    How could I rebuild the database???
    Thanks in advance.

  2. #2
    Join Date
    Dec 2004
    Location
    vienna, at
    Posts
    27
    you have to read the recover guide!!

    first you need the init.ora file and the ctl-file
    you have to edit the init.ora entry for the ctl-file or
    you put the ctl-file to the destination of the init.ora entry.
    then you have to mount the database with
    your init.ora file.
    after mounting the database you have to check the datafile-destinations in the ctl-file and move them,
    or alter the destination of the files in the ctl-file
    ...
    when you have all file on the right place you can open the
    database and you can do everything you want (e.g. export, ...).
    phh

  3. #3
    Join Date
    Feb 2005
    Posts
    3

    Re:Help

    Thankyou for your help.
    I did as your advice but it still get ERROR in identifying controlfile although I had put the ctl-file(s) in the right place.
    This is my inittext.ora:

    db_name = text
    db_files = 20
    control_files = "C:\text\database\ctl1text.ora"
    control_files = "C:\text\database\ctl2text.ora"

    compatible = 8.1.0.0.0

    #db_file_multiblock_read_count = 8 # INITIAL
    # db_file_multiblock_read_count = 8 # SMALL
    db_file_multiblock_read_count = 16 # MEDIUM
    # db_file_multiblock_read_count = 32 # LARGE

    #db_block_buffers = 200 # INITIAL
    # db_block_buffers = 200 # SMALL
    # db_block_buffers = 550 # MEDIUM
    db_block_buffers = 3200 # LARGE

    #shared_pool_size = 6500000 # INITIAL
    # shared_pool_size = 3500000 # SMALL
    shared_pool_size = 6000000 # MEDIUM
    # shared_pool_size = 9000000 # LARGE

    log_checkpoint_interval = 10000

    #processes = 50 # INITIAL
    # processes = 50 # SMALL
    processes = 100 # MEDIUM
    # processes = 200 # LARGE

    #dml_locks = 100 # INITIAL
    # dml_locks = 100 # SMALL
    dml_locks = 200 # MEDIUM
    # dml_locks = 500 # LARGE

    #log_buffer = 8192 # INITIAL
    # log_buffer = 8192 # SMALL
    log_buffer = 32768 # MEDIUM
    # log_buffer = 163840 # LARGE

    sequence_cache_entries = 10 # INITIAL
    # sequence_cache_entries = 10 # SMALL
    # sequence_cache_entries = 30 # MEDIUM
    # sequence_cache_entries = 100 # LARGE

    sequence_cache_hash_buckets = 10 # INITIAL
    # sequence_cache_hash_buckets = 10 # SMALL
    # sequence_cache_hash_buckets = 23 # MEDIUM
    # sequence_cache_hash_buckets = 89 # LARGE

    # audit_trail = true # if you want auditing
    # timed_statistics = true # if you want timed statistics
    max_dump_file_size = 10240 # limit trace file size to 5 Meg each

    # log_archive_start = true # if you want automatic archiving

    # define directories to store trace and alert files
    background_dump_dest=%RDBMS73%\trace
    user_dump_dest=%RDBMS73%\trace

    db_block_size = 2048

    snapshot_refresh_processes = 1

    remote_login_passwordfile = shared

    text_enable = true

    OPEN_CURSORS = 150
    Last edited by trungnt0308l; 02-17-05 at 22:00.

  4. #4
    Join Date
    Feb 2005
    Posts
    4

    Be more specific and detailed.

    Hey, you should mention complete details as the solution differs on various factors.

    1)What is the Oracle error you face.

    2)Was the earlier db in archive log mode?

    3)Also note that the source db files should be of the same or compatible version of Orcale.

    4)In case the message is a warning you would need to recover the database or would need to reset the logs.

    5)Was the earlier db cleanly shut ?before you used the db files?

  5. #5
    Join Date
    Feb 2005
    Posts
    3

    Re:Help

    Thankyou for answer.
    The error I get is :
    ORA-00205:Error in identifying controlfile, check alert log for more info.
    I have checked the alert log but there isn't anything unusual.
    I don't know about other things(Was the earlier db in archive log mode?
    Was the earlier db cleanly shut ?....).All I got is these ora file.

Posting Permissions

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