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

Thread: Data Files

  1. #1
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Question

    Hi,

    What is DB_FILES, MAXDATAFILES ?

    Where these parameters can be seen ?

    A User has accidentally dropped a Table, there is no backup for this but the database is in Archive Log mode. How do I recover the Table.


  2. #2
    Join Date
    Jun 2002
    Posts
    73
    THe parameter DB_FILES is located in initorcle.ora and parameter MAXDATAFILES you specify at the time of database creation. This parameter shows that this much number of datafiles yo can create. DB_FILES takes precedence on MAXDATAFILES.

    For your second question about recovery of table there may be two solution ....Either you know the time when the table was dropped so that you perform incomplete recovery until time the table was dropped, but this will be at the expense of loss of data from that time to present. One more solution is TSPITR (Tablespace point-in-time recovery) but it's rather complicated one...You have to export your database, make a clone database, apply incomplete recovery of clone database, import the recovered clone database and start your main database with RESETLOGS.
    You cannot succeed if you fear to face challenges.
    MAS
    BE(CS) , OCP 8/8i.



  3. #3
    Join Date
    Dec 2001
    Posts
    320
    hi ramji,
    for db_files parameter in the init.ora file check:
    http://www.dbasupport.com/oracle/ora...arameter.shtml

    for maxdatafiles check:
    http://www.dbasupport.com/oracle/ora...createDB.shtml

    for tablespace point in time recovery check:
    http://otn.oracle.com/docs/products/...ov.htm#1004808

    Best Regards.

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by ramji_1123
    Hi,

    What is DB_FILES, MAXDATAFILES ?

    Where these parameters can be seen ?

    When you run CREATE DATABASE, you often have a parameter called MAXDATAFILES. The value that is entered for this parameter or some default value is stored in the CONTROL FILE upon DB creation. This is the so called "hard" limit on the number of datafiles which can be associated with this particular database. Remember DB, not instance!

    In the init.ora you have DB_FILES. This is the limit on the total number of files associated with a particular INSTANCE of a database. As you know several instances can be associated with a single DB. This is called the "soft limit".
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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