-
Hi,
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.
Ksana
-
In the future, please reply to your original thread instead of creating a new one. http://www.dbasupport.com/forums/sho...threadid=14920
Jeff Hunter
-
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.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "MYSID" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 4
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
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
DATAFILE
'D:\ORACLE\ORADATA\MYSID\SYSTEM01.DBF',
'D:\ORACLE\ORADATA\MYSID\RBS01.DBF',
'D:\ORACLE\ORADATA\MYSID\USERS01.DBF',
'D:\ORACLE\ORADATA\MYSID\TEMP01.DBF',
'D:\ORACLE\ORADATA\MYSID\TOOLS01.DBF',
'D:\ORACLE\ORADATA\MYSID\INDX01.DBF',
'D:\ORACLE\ORADATA\MYSID\TMPMYSID.ORA',
'D:\ORACLE\ORADATA\MYSID\USER_DATA.ORA'
CHARACTER SET WE8ISO8859P1
;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|