Re: Any way to 'truncate' the control file?

From: Tom Tyson <tomtysonjr_at_yahoo.com>
Date: Tue, 1 Aug 2000 17:52:23 -0700 (PDT)
Message-Id: <10576.113541@fatcity.com>

Zhong Hong

I am assuming that you are using some version Oracle 8/8i, which is the version that the control file had become considerably larger. If you are worried about the size of your control file you aren't left with too many choices. What is your configuration of your control file, execute in svrmgrl the following command:
"alter database backup controlfile to trace", this will output a trace file with a script to recreate your controlfile. Send that back in an email, also do you use RMAN, or are you in archive log mode? (type: "archive log list" in svrmgrl ).

Tom Tyson
Exodus Communications, Inc.
Oracle DBA

"The opinions that are being expressed are solely mine, and are not necessarily the options of Exodus Communications, Inc."

• Zhong Hong <zhong_at_cantametrix.com> wrote:
  > My contril file is about 39MB for a 150GB Database. Anybody knows what could
  > cause that and how to reduce the size?
  >
  > TIA,
  > Zhong
  > It's another beautiful day!
  

  ---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. Received on Tue Aug 01 2000 - 19:52:23 CDT