OraFAQ Forum: Backup & Recovery » how to use the incarnation command

Home » RDBMS Server » Backup & Recovery » how to use the incarnation command (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to use the incarnation command [message #546482]

Wed, 07 March 2012 01:16

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
how can i using the reset database to incarnation command?

RMAN> list incarnation of database;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORACL    1813843256       PARENT  1          2005-06-30 19:09:40
2       2       ORACL    1813843256       PARENT  446075     2011-11-28 03:21:33
3       3       ORACL    1813843256       PARENT  530572     2011-12-06 12:55:20
4       4       ORACL    1813843256       CURRENT 1763647    2012-03-06 18:50:20

RMAN> reset database to incarnation 530572;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of reset command on default channel at 03/06/2012 19:36:08
ORA-19902: incarnation key 530572 not found

Report message to a moderator

Re: how to use the incarnation command [message #546483 is a reply to message #546482]

Wed, 07 March 2012 01:23

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

incarnation key 530572 not found

Inc Key 
-------

Regards
Michel

[Updated on: Wed, 07 March 2012 01:29]

Report message to a moderator

Re: how to use the incarnation command [message #546547 is a reply to message #546483]

Wed, 07 March 2012 05:55

andy huang
Messages: 498
Registered: July 2011

Senior Member

hi,
Michel,how can i check whether the incarnation key exists?

Report message to a moderator

Re: how to use the incarnation command [message #546550 is a reply to message #546547]

Wed, 07 March 2012 06:09

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is in the list?

Regards
Michel

Report message to a moderator

Re: how to use the incarnation command [message #546561 is a reply to message #546550]

Wed, 07 March 2012 06:54

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks,
The 530572 is in the list.

RMAN> list incarnation of database;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORACL    1813843256       PARENT  1          2005-06-30 19:09:40
2       2       ORACL    1813843256       PARENT  446075     2011-11-28 03:21:33
3       3       ORACL    1813843256       PARENT  530572     2011-12-06 12:55:20
4       4       ORACL    1813843256       CURRENT 1763647    2012-03-06 18:50:20

Report message to a moderator

Re: how to use the incarnation command [message #546563 is a reply to message #546561]

Wed, 07 March 2012 06:55

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thanks Michel,
I know!

Report message to a moderator

Re: how to use the incarnation command [message #546567 is a reply to message #546563]

Wed, 07 March 2012 07:20

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

For completeness: "Inc Key" = incarnation key, the one to mention in "reset to incarnation" command.

Regards
Michel

Report message to a moderator

Re: how to use the incarnation command [message #546632 is a reply to message #546567]

Wed, 07 March 2012 20:57

andy huang
Messages: 498
Registered: July 2011

Senior Member

Thansk,
Michel, What does mean about ORPHAN in the status column? does it can reset database to incarnation of marked ORPHAN?

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORACL    1813843256       PARENT  1          2005-06-30 19:09:40
2       2       ORACL    1813843256       PARENT  446075     2011-11-28 03:21:33
3       3       ORACL    1813843256       PARENT  530572     2011-12-06 12:55:20
4       4       ORACL    1813843256       ORPHAN  1763647    2012-03-06 18:50:20
5       5       ORACL    1813843256       CURRENT 1763647    2012-03-06 23:02:18

RMAN> reset database to incarnation 4;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of reset command on default channel at 03/06/2012 23:03:43
ORA-19910: can not change recovery target incarnation in control file

Report message to a moderator

Re: how to use the incarnation command [message #546633 is a reply to message #546632]

Wed, 07 March 2012 21:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

is GOOGLE broken for you?

http://www.lmgtfy.com/?q=oracle+rman+status+orphan

Report message to a moderator

Previous Topic:	resetlogs issue
Next Topic:	Backup selected data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 01:15:45 CST 2024