Home » RDBMS Server » Server Administration » how to read a control file structure
how to read a control file structure [message #140521] Tue, 04 October 2005 10:41 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
How do I read the control file to know the physical structure of a database that was created.

Thanks in advance for the help.

R.
Re: how to read a control file structure [message #140527 is a reply to message #140521] Tue, 04 October 2005 11:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
SQL> alter database backup controlfile to trace;
 
Database altered.

Login as dba and issue the above.
check the trace file colllected in $ORACLE_HOME/admin/ORACLE_SID/udump
Re: how to read a control file structure [message #140544 is a reply to message #140521] Tue, 04 October 2005 12:45 Go to previous message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Thank you Boss.
Previous Topic: RMAN TTS
Next Topic: drop the database
Goto Forum:
  


Current Time: Sat Jan 25 08:08:20 CST 2025