OraFAQ Forum: Data Guard » after MRP is down why scn are being generated??

Home » Server Options » Data Guard » after MRP is down why scn are being generated??

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

after MRP is down why scn are being generated?? [message #258380]

Sat, 11 August 2007 06:43

pramodgaree
Messages: 22
Registered: August 2007

Junior Member

Once i bring down MRP n take backup for my physiacl standby database it should be equivalent to cold backup na...but when i tried to bring up db on that backup ,it is asking for recovery..y recovery is required ??/coz after bringing down mrp ideally no mismatch of SCN should happen b/w control file n datafiles headres..but y still it is asking for recovery???will there be any SCN generatrion even after bringing down MRP????

Report message to a moderator

Re: after MRP is down why scn are being generated?? [message #258386 is a reply to message #258380]

Sat, 11 August 2007 07:36

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Please read the Sticky about IM speak.

Report message to a moderator

Re: after MRP is down why scn are being generated?? [message #260232 is a reply to message #258380]

Fri, 17 August 2007 14:04

pramodgaree
Messages: 22
Registered: August 2007

Junior Member

sorry for that..but any one knows why SCNs are being generated after MRp is down on physical standby database

Report message to a moderator

Re: after MRP is down why scn are being generated?? [message #260250 is a reply to message #260232]

Fri, 17 August 2007 15:30

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Are you looking to create a "test" database from your standby? If so, since the standby has a STANDBY CONTROLFILE, you can't just recover the standby database to be a "normal" (non-standby) database. You should generate a CONTROLFILE TO TRACE from the primary and use this control file with RESETLOGS and the files from the standby to recover the "test" database.

Report message to a moderator

Re: after MRP is down why scn are being generated?? [message #261186 is a reply to message #260250]

Wed, 22 August 2007 02:06

pramodgaree
Messages: 22
Registered: August 2007

Junior Member

That'a absolutely correct.But My scenario is that i am taking a copy for complete structure including controlfiles,Redo logs after bringing down MRP.So once i bring down MRP and take backup it should be equivalent to cold backup.Then while i bringup database , as you said after recreating controlfile it should not ask for recovery as all the datafiles are pretty consistent as i took backup after bringing down MRP.But still it is asking for recovery.Why it is asking for recovery??Is there any SCN generation after MRP is down???

Report message to a moderator

Re: after MRP is down why scn are being generated?? [message #261301 is a reply to message #261186]

Wed, 22 August 2007 05:14

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Because you are using a backup controlfile.

Report message to a moderator

Re: after MRP is down why scn are being generated?? [message #262346 is a reply to message #261301]

Sun, 26 August 2007 06:44

pramodgaree
Messages: 22
Registered: August 2007

Junior Member

But most of the times alter database open resetlogs has been a success...but for some times only it is not able to open with out recovery???

Report message to a moderator

Re: after MRP is down why scn are being generated?? [message #262354 is a reply to message #262346]

Sun, 26 August 2007 08:18

ebrian
Messages: 2794
Registered: April 2006

Senior Member

If all you are doing is shutting down your standby database and then copying the files to another location and then starting it up, then it's still technically a standby database, NOT what you are looking to accomplish as far as I can tell. If you want to do it right, perform the recovery as I mentioned above.

Report message to a moderator

Previous Topic:	Using Data Broker -- Observation
Next Topic:	Getting error ORA-12154: TNS:could not resolve the connect identifier specified

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 16 21:32:49 CDT 2025