Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    128

    Unanswered: Where did my control file get backed up too?

    Reading this doc:

    http://download-west.oracle.com/docs...l.htm#i1006485

    I stumbled onto this:

    Produce SQL statements that can later be used to re-create your control file:

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

    I ran it successfully, but have no clue as to where this file got created. Can someone please assist?

    TIA, cfr

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Your DB has a parameter called "user_dump_dest".
    So its value is the directory where the *trc file was written.
    Typically the directory is called "udump"; but this is NOT a requirement & it could be called anything you desire it to be.
    Typically it is under the "admin" tree, but again it does not have to reside in the default OFA location.

    Be warned that in some/many/most "older" versions of Oracle, this file contained incorrect "comment characters" upon which SQL*Plus would complain.
    AFAIK, Oracle 10.2 does correctly compose this file.
    Last edited by anacedent; 04-28-07 at 17:03.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Nov 2004
    Posts
    128
    Thanks. My DB is in fact using the default, but I just checked and the file doesn't arrive. I ran it again just now to see and still no luck, any ideas?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    > ls
    oltp-comdb03.sql
    > sqlplus
    
    SQL*Plus: Release 10.2.0.2.0 - Production on Sun Apr 29 16:16:06 2007
    
    Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.
    
    Enter user-name: / as sysdba
    
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    
    SQL> alter database backup controlfile to trace;
    
    Database altered.
    
    SQL> exit
    Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options
    > ls -ltr
    -rw-r--r--  1 oracle dba  15249 Dec  1 14:10 oltp-comdb03.sql
    -rw-r-----  1 oracle dba  33699 Apr 29 16:16 comdb03_ora_9421.trc
    > pwd
    /prime/oracle/product/admin/comdb03/udump
    Above snippet shows the working directory is the "udump" folder & the new trace file gets created there.
    I don't what what is the problem on your system, but it works OK for me.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •