RE: recovery question - I know I am missing something
What I do and have just done a couple of days ago is copy your latest redo
log into the suggested name below
'/u07/oracle/testdb/8.1.7/dbs/arch1_1.dbf'
and do your recover again. Worked fine for me
HTH
Lee
-Original Message-
Sent: 12 September 2002 19:38
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: {RET=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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
*
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robertson Lee - lerobe
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: recovery question - I know I am missing something
I think you need the online redo log file that was current when you did
shutdown abort.
This is provided it was not recycled!
Waleed
-Original Message-
Sent: Thursday, September 12, 2002 2:38 PM
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: {RET=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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: recovery question - I know I am missing something
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.
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: {RET=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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: recovery question - I know I am missing something
select * from v$logfile. Specify the current logfile.
From: Kathy Duret [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: recovery question - I know I am missing something
Date: Thu, 12 Sep 2002 11:08:33 -0800
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.
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: {RET=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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mike Killough
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: recovery question - I know I am missing something
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: recovery question - I know I am missing something
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: {RET=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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
