Ryfujk

Why can't wing-mounted spoilers be used to steepen approaches?

Can smartphones with the same camera sensor have different image quality?

How does ice melt when immersed in water?

Sort a list of pairs representing an acyclic, partial automorphism

Working through the single responsibility principle (SRP) in Python when calls are expensive

He got a vote 80% that of Emmanuel Macron’s

Derivation tree not rendering

How to pronounce 1ターン?

Does Parliament need to approve the new Brexit delay to 31 October 2019?

In horse breeding, what is the female equivalent of putting a horse out "to stud"?

How to split my screen on my Macbook Air?

Relations between two reciprocal partial derivatives?

Finding the path in a graph from A to B then back to A with a minimum of shared edges

Didn't get enough time to take a Coding Test - what to do now?

Was credit for the black hole image misattributed?

Does Parliament hold absolute power in the UK?

Single author papers against my advisor's will?

Who or what is the being for whom Being is a question for Heidegger?

Can the prologue be the backstory of your main character?

How did passengers keep warm on sail ships?

What can I do if neighbor is blocking my solar panels intentionally?

I could not break this equation. Please help me

Semisimplicity of the category of coherent sheaves?

The variadic template constructor of my class cannot modify my class members, why is that so?

Oracle: Getting ORA-01195 and ORA-01110 when attempting resetlogs

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

1

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message:

Total System Global Area  534462464 bytes

Fixed Size                  2215064 bytes

Variable Size             331350888 bytes

Database Buffers          192937984 bytes

Redo Buffers                7958528 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

So I do a shutdown, startup mount (which works fine) and then run:

SQL> alter database recover using backup controlfile until cancel;

alter database recover using backup controlfile until cancel

*

ERROR at line 1:

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/<path>/system01.dbf'





SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/<path>/system01.dbf'

I know I've used instructions to get me past this error before, but I seem to be having trouble tracking it down.

A bit of history:
We wanted to refresh the data in this from another db so we attempted to do a expdb/impdb into this instance. The impdb did not complete correctly and got an end of file error message in it and hung (I still have the message in a log if it's important).

Since the instance would start at this point, we decided to use the hotbackup process we have to restore the db. The hotbackups are from another server/instance. We went through the same process 2 weeks ago. At the point of recreating the control file is where we got to the issue above.

oracle oracle-11g

share|improve this question

asked Aug 12 '11 at 13:27

MacAnthonyMacAnthony

1481210

bumped to the homepage by Community♦ 15 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

1

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message:

Total System Global Area  534462464 bytes

Fixed Size                  2215064 bytes

Variable Size             331350888 bytes

Database Buffers          192937984 bytes

Redo Buffers                7958528 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

So I do a shutdown, startup mount (which works fine) and then run:

SQL> alter database recover using backup controlfile until cancel;

alter database recover using backup controlfile until cancel

*

ERROR at line 1:

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/<path>/system01.dbf'





SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/<path>/system01.dbf'

I know I've used instructions to get me past this error before, but I seem to be having trouble tracking it down.

A bit of history:
We wanted to refresh the data in this from another db so we attempted to do a expdb/impdb into this instance. The impdb did not complete correctly and got an end of file error message in it and hung (I still have the message in a log if it's important).

Since the instance would start at this point, we decided to use the hotbackup process we have to restore the db. The hotbackups are from another server/instance. We went through the same process 2 weeks ago. At the point of recreating the control file is where we got to the issue above.

oracle oracle-11g

share|improve this question

asked Aug 12 '11 at 13:27

MacAnthonyMacAnthony

1481210

bumped to the homepage by Community♦ 15 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I am trying to get our database to startup. When I login to sqlplus and do a startup, I get the message:

Total System Global Area  534462464 bytes

Fixed Size                  2215064 bytes

Variable Size             331350888 bytes

Database Buffers          192937984 bytes

Redo Buffers                7958528 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

So I do a shutdown, startup mount (which works fine) and then run:

SQL> alter database recover using backup controlfile until cancel;

alter database recover using backup controlfile until cancel

*

ERROR at line 1:

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/<path>/system01.dbf'





SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/<path>/system01.dbf'

I know I've used instructions to get me past this error before, but I seem to be having trouble tracking it down.

A bit of history:
We wanted to refresh the data in this from another db so we attempted to do a expdb/impdb into this instance. The impdb did not complete correctly and got an end of file error message in it and hung (I still have the message in a log if it's important).

Since the instance would start at this point, we decided to use the hotbackup process we have to restore the db. The hotbackups are from another server/instance. We went through the same process 2 weeks ago. At the point of recreating the control file is where we got to the issue above.

oracle oracle-11g

share|improve this question

asked Aug 12 '11 at 13:27

MacAnthonyMacAnthony

1481210

Total System Global Area  534462464 bytes

Fixed Size                  2215064 bytes

Variable Size             331350888 bytes

Database Buffers          192937984 bytes

Redo Buffers                7958528 bytes

Database mounted.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database recover using backup controlfile until cancel;

alter database recover using backup controlfile until cancel

*

ERROR at line 1:

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/<path>/system01.dbf'





SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/<path>/system01.dbf'

share|improve this question

asked Aug 12 '11 at 13:27

MacAnthonyMacAnthony

1481210

share|improve this question

asked Aug 12 '11 at 13:27

MacAnthonyMacAnthony

1481210

asked Aug 12 '11 at 13:27

MacAnthonyMacAnthony

1481210

asked Aug 12 '11 at 13:27

MacAnthonyMacAnthony

1481210

2 Answers
2

active

oldest

votes

0

Before restoring from hot backup you should make sure that there are no old control files left from the broken instance. Also you should move out or delete any existing data files that match location and file name with the database being recovered.

share|improve this answer

answered Aug 16 '11 at 12:52

Yavor ShahpasovYavor Shahpasov

47126

add a comment | 

0

You use old controlfile, but files that you try to recover are from newer incranation of database. If you want to use backup controlfile, than you must restore your datafiles from backup. Do not restore redolog files in any case!!

share|improve this answer

answered Sep 6 '11 at 12:41

Predrag SimovićPredrag Simović

161

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f300485%2foracle-getting-ora-01195-and-ora-01110-when-attempting-resetlogs%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Before restoring from hot backup you should make sure that there are no old control files left from the broken instance. Also you should move out or delete any existing data files that match location and file name with the database being recovered.

share|improve this answer

answered Aug 16 '11 at 12:52

Yavor ShahpasovYavor Shahpasov

47126

add a comment | 

0

Before restoring from hot backup you should make sure that there are no old control files left from the broken instance. Also you should move out or delete any existing data files that match location and file name with the database being recovered.

share|improve this answer

answered Aug 16 '11 at 12:52

Yavor ShahpasovYavor Shahpasov

47126

add a comment | 

Before restoring from hot backup you should make sure that there are no old control files left from the broken instance. Also you should move out or delete any existing data files that match location and file name with the database being recovered.

share|improve this answer

answered Aug 16 '11 at 12:52

Yavor ShahpasovYavor Shahpasov

47126

share|improve this answer

answered Aug 16 '11 at 12:52

Yavor ShahpasovYavor Shahpasov

47126

answered Aug 16 '11 at 12:52

Yavor ShahpasovYavor Shahpasov

47126

answered Aug 16 '11 at 12:52

Yavor ShahpasovYavor Shahpasov

47126

0

You use old controlfile, but files that you try to recover are from newer incranation of database. If you want to use backup controlfile, than you must restore your datafiles from backup. Do not restore redolog files in any case!!

share|improve this answer

answered Sep 6 '11 at 12:41

Predrag SimovićPredrag Simović

161

add a comment | 

0

You use old controlfile, but files that you try to recover are from newer incranation of database. If you want to use backup controlfile, than you must restore your datafiles from backup. Do not restore redolog files in any case!!

share|improve this answer

answered Sep 6 '11 at 12:41

Predrag SimovićPredrag Simović

161

add a comment | 

You use old controlfile, but files that you try to recover are from newer incranation of database. If you want to use backup controlfile, than you must restore your datafiles from backup. Do not restore redolog files in any case!!

share|improve this answer

answered Sep 6 '11 at 12:41

Predrag SimovićPredrag Simović

161

share|improve this answer

answered Sep 6 '11 at 12:41

Predrag SimovićPredrag Simović

161

answered Sep 6 '11 at 12:41

Predrag SimovićPredrag Simović

161

answered Sep 6 '11 at 12:41

Predrag SimovićPredrag Simović

161