Hi David, Thanks for your reply. As per hemanth's comment, I did not open the database. After recovery is complete, I give ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; and immediately I see standby redo logs complain about missing redo logs. I do not yet have a working physical standby. Can you please send me the link of Herman's document. On Wed, Feb 9, 2011 at 5:44 PM, David Barbour <david.barbour1@xxxxxxxxx>wrote: > Check Herman's doc on the transition from a physical standby to a logical > standby. > > Of particular note is the instruction: > > SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY db_name; > > For db_name, specify a database name that is different from the primary > database to identify the new logical standby database. > > I'm also wondering if you've properly configured your primary (and standby) > initialization files. Did you successfully run this as a physical standby > first? > > > On Wed, Feb 9, 2011 at 4:20 PM, sundar mahadevan < > sundarmahadevan82@xxxxxxxxx> wrote: > >> Hi Hemant/David, >> Thanks for your replies. I am using Oracle® Data Guard Concepts and >> Administration 11.2 as a reference. After the complete recovery in mount >> mode, when i enter ALTER DATABASE RECOVER TO LOGICAL STANDBY <primary >> DBname>; I get ORA-16136: Managed Standby Recovery not active with >> ORA-00313/ORA-00312/ORA-27037 errors in alert log file complaining about >> missing redo logs. Can you please tell me when does the tempfiles and >> redologs get created. Am i missing anything on my parameters? >> >> >> On Wed, Feb 9, 2011 at 1:14 PM, David Barbour >> <david.barbour1@xxxxxxxxx>wrote: >> >>> If you're objective is to first create a physical standby, you did okay >>> through the backup process for the database, but NOT for the controlfile. >>> Additionally you don't need to set dbid and recover, let RMAN do it for you. >>> >>> Check out the 9i RMAN users guide chapter 13 - Creating a Standby >>> Database with RMAN. I KNOW it's 9i, but it's still the best basic primer on >>> how to do this I've seen. >>> >>> http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/title.htm >>> >>> >>> >>> >>> On Wed, Feb 9, 2011 at 11:17 AM, sundar mahadevan < >>> sundarmahadevan82@xxxxxxxxx> wrote: >>> >>>> Hi All, >>>> I would like to make my previous email short. I am trying to implement >>>> logical standby. First I start off with creating a physical standby with >>>> rman. After a complete recovery, do I open the database with noresetlogs or >>>> with resetlogs? If I try to open the database with resetlogs, I get >>>> ORA-01666: control file is for a standby database. On one mos note, it said >>>> alter database open resetlogs would create the redo log files (After the >>>> complete recovery, I do not have tempfile and redo logs created). According >>>> to note 601835.1, the redo log errors can be safely ignored on physical >>>> standby. So when do the redo logs get created ? What should I do now to >>>> eliminate this error. Oracle support is taking too long to respond and i >>>> need to get this working soon. Thanks a ton for all your help. >>>> >>>> >>>> On Tue, Feb 8, 2011 at 5:28 PM, sundar mahadevan < >>>> sundarmahadevan82@xxxxxxxxx> wrote: >>>> >>>>> Hi Group, >>>>> Greetings. I am trying to setup a logical dataguard on 11.2.0.2 (SLES >>>>> 11 x86_64). Initially I am creating the physical standby with rman hot >>>>> backup from primary. I followed the procedure from note *469493.1 *to >>>>> create the physical standby. The following are the steps: >>>>> >>>>> >>>>> Connect to primary and crosscheck backup/archivelogs: >>>>> delete expired backup and archivelogs >>>>> Connect to primary and take rman backup: >>>>> command used for backup on primary: >>>>> run { >>>>> set command id to 'rman'; >>>>> backup database plus archivelog; >>>>> sql 'alter system switch logfile'; >>>>> backup archivelog from time 'sysdate -3/24'; >>>>> backup current controlfile for standby; >>>>> } >>>>> >>>>> Rman Restore Physical Standby Database: >>>>> startup nomount; >>>>> set dbid=2225084209 >>>>> sql 'alter database mount standby database'; >>>>> restore database; >>>>> exit >>>>> >>>>> Find current redo log sequence on Primary Database: >>>>> sqlplus / as sysdba >>>>> recover standby database ; >>>>> enter all archivelogs and the current redo log sequence from primary >>>>> and finally i get Media recovery complete. >>>>> At this point I do not have tempfile/redo logs created but the redo >>>>> logs missing error was reported as soon as i mounted the physical standby >>>>> database with "sql 'alter database mount standby database'; before >>>>> restore" >>>>> >>>>> now do I open the database with reset logs or no resetlogs. >>>>> If I try to open the database with noresetlogs, the tempfile gets >>>>> created but not the redo logs. If I try to open the database with >>>>> resetlogs, >>>>> I get ORA-01666: control file is for a standby database. On one mos note, >>>>> it >>>>> said alter database open resetlogs would create the redo log files. >>>>> According to note 601835.1, the redo log errors can be safely ignored on >>>>> physical standby. So when do the redo logs get created when I go for a >>>>> logical standby creation. What should I do now to eliminate this error. >>>>> Oracle support is taking too long to respond and i need to get this >>>>> working >>>>> soon. Thanks a ton for all your help. >>>>> >>>>> >>>> >>> >> >