FAQ
Kathy,
Let me clarify a bit. I cloned the database from coldbackup .

I opened the database fine, but I goofed up the name. I
shutdown the database, it hung so I
did a shutdown abort and forgot to open it up normally before
I tried to rename the database.

I don't have any archive files created by the wrong named database.
Long shot, but shutdown normal, copy the last used redolog the arch dir as
arch1_1.log and retry the recover database. I had to use this one (if my
failiing memory serves me correctly!)

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointments are inevitable in Life, but discouragement is optional. You
decide!

The opinions and statements above are entirely my own and not those of my
employer or clients **
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
INET: john.kanagaraj_at_hds.com

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Kathy Duret at Sep 12, 2002 at 10:13 pm
    I ended up giving it one of the log files but they all said stale so it took me a couple of tries.

    Thanks!

    Kathy

    -----Original Message-----
    Sent: Thursday, September 12, 2002 11:38 AM
    To: Multiple recipients of list ORACLE-L

    Database 8.1.7

    Cloning a database that was brought down using shutdown abort.

    I know I have done this before and I can't remember what I had to do to resolve this.

    STARTUP NOMOUNT

    CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS NOARCHIVELOG

    RECOVER DATABASE using backup controlfile until cancel

    SVRMGR> recover database using backup controlfile until cancel;

    ORA-00279: change 776233169 generated at 09/12/2002 09:58:18 needed for thread 1
    ORA-00289: suggestion : /u07/oracle/testdb/8.1.7/dbs/arch1_1.dbf
    ORA-00280: change 776233169 for thread 1 is in sequence #1

    Specify log: {=suggested | filename | AUTO | CANCEL}

    CANCEL

    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01194: file 1 needs more recovery to be consistent

    ORA-01110: data file 1: '/testu01/oracle/testdata/system01.dbf'

    Thanks

    Kathy

    Confidential
    This e-mail and any files transmitted with it are the property
    of Belkin Components and/or its affiliates, are confidential,
    and are intended solely for the use of the individual or
    entity to whom this e-mail is addressed. If you are not one
    of the named recipients or otherwise have reason to believe
    that you have received this e-mail in error, please notify the
    sender and delete this message immediately from your computer.
    Any other use, retention, dissemination, forwarding, printing
    or copying of this e-mail is strictly prohibited.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kathy Duret
    INET: KathyD_at_belkin.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    Confidential
    This e-mail and any files transmitted with it are the property
    of Belkin Components and/or its affiliates, are confidential,
    and are intended solely for the use of the individual or
    entity to whom this e-mail is addressed. If you are not one
    of the named recipients or otherwise have reason to believe
    that you have received this e-mail in error, please notify the
    sender and delete this message immediately from your computer.
    Any other use, retention, dissemination, forwarding, printing
    or copying of this e-mail is strictly prohibited.
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Kathy Duret
    INET: KathyD_at_belkin.com

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
    San Diego, California -- Public Internet access / Mailing Lists
    --------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 12, '02 at 8:53p
activeSep 12, '02 at 10:13p
posts2
users2
websiteoracle.com

2 users in discussion

John Kanagaraj: 1 post Kathy Duret: 1 post

People

Translate

site design / logo © 2022 Grokbase