Home » RDBMS Server » Backup & Recovery » open resetlog (oracle 10.2.0.1.0,Redhat Linux 4, oracle 10.2.0.1, windows)
open resetlog [message #470885] Wed, 11 August 2010 05:08 Go to next message
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 ??
Re: open resetlog [message #470891 is a reply to message #470885] Wed, 11 August 2010 05:33 Go to previous messageGo to next message
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 Go to previous messageGo to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
please confirm.


is we need to create new standby ??
Re: open resetlog [message #470937 is a reply to message #470896] Wed, 11 August 2010 08:53 Go to previous message
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.
Previous Topic: Is there any kind of "Transparent Data Archival" in Oracle
Next Topic: ORA-01033: Recovering database
Goto Forum:
  


Current Time: Sun Dec 22 13:41:23 CST 2024