Maybe, I was a little unclear before.
How can I find MAXLOGFILES, MAXLOGMEMBERS,
MAXDATAFILES... information for an existing DB ?
For example, I am working with a database that has been created
by somebody else who no longer works with our company.
Where can I look to find out MAXLOGFILES, MAXLOGMEMBERS,
MAXDATAFILES parameters that are currently allocated for the
database? Is there a data dictionary view that could tell me this?
Thank you in advance for all your responses.
In the future, please reply to your original thread instead of creating a new one. http://www.dbasupport.com/forums/sho...threadid=14920
The following will tell you everything that you want to know.
log into svrmgrl and execute the following command
alter database backup controlfile to trace;
This will create a file in you udump or trace directory depending on you version of oracle. Edit the file and you will find the answer. This file can be edited and used to recreate your control files. At which time you can change MAXLOGFILES, MAXLOGMEMBERS etc.
CREATE CONTROLFILE REUSE DATABASE "MYSID" NORESETLOGS NOARCHIVELOG
GROUP 1 'D:\ORACLE\ORADATA\MYSID\REDO01.LOG' SIZE 1M,
GROUP 2 'D:\ORACLE\ORADATA\MYSID\REDO02.LOG' SIZE 1M,
GROUP 3 'D:\ORACLE\ORADATA\MYSID\REDO03.LOG' SIZE 1M
CHARACTER SET WE8ISO8859P1