OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » open resetlog (oracle 10.2.0.1.0,Redhat Linux 4, oracle 10.2.0.1, windows)

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

open resetlog [message #470885]

Wed, 11 August 2010 05:08

goracle9
Messages: 136
Registered: December 2006

Senior Member

Hi, all

When we should use

sql>alter database open resetlog;

what is the impact, if suppose we used resetlog option when recoverd the database. what will be impact for the standby database for the recoverd database is we need to create new standby ??

Report message to a moderator

Re: open resetlog [message #470891 is a reply to message #470885]

Wed, 11 August 2010 05:33

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://youngcow.net/doc/oracle10g/backup.102/b14191/osrecov009.htm#i1007426

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ps.htm#i1026480
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/manage_ls.htm#CHDFCEDD

[Updated on: Wed, 11 August 2010 06:02]

Report message to a moderator

Re: open resetlog [message #470896 is a reply to message #470891]

Wed, 11 August 2010 05:42

goracle9
Messages: 136
Registered: December 2006

Senior Member

please confirm.

is we need to create new standby ??

Report message to a moderator

Re: open resetlog [message #470937 is a reply to message #470896]

Wed, 11 August 2010 08:53

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Did you go through the above links?
Depending on what you have (logical/physical standby) and how it is configured, you need to take appropriate actions.

Report message to a moderator

Previous Topic:	Is there any kind of "Transparent Data Archival" in Oracle
Next Topic:	ORA-01033: Recovering database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 12 13:44:21 CDT 2025