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.
Printable View
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.
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.
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.
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!Quote:
Originally posted by ramji_1123
Hi,
What is DB_FILES, MAXDATAFILES ?
Where these parameters can be seen ?
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".