see Metalink note 233290.1
Solution Description -------------------- This is logged as bug 2757099.
Until a patch is generated for your release please use the following
workaround: 1. Start the logical standby and execute this statement:
insert into system.logstdby$parameters (name,value) values
('SEED_DICT_HINT', NULL); 2. On the primary run the following select:
select sequence#, to_char(first_change#),first_time from v$archived_log
where dictionary_begin='YES'; Confirm the date, note the
first_change# and sequence number. 3. Verify that the log with the
dictionary is in the standby archive dest directory used by the logical
standby. If not, copy it from the primary archive log directory to the
standby. 4. Select sequence# from dba_logstdby_log on the standby and make
sure that the archived log with the data dictionary in it has been
registered. If not, register it by hand. Alter database register logical
logfile '/private/archive/1_30.dbf'; 5. Alter database start logical
standby apply initial <first_change# from step 2>; 6. Check the alert
log for errors. 7. Add the new logical standby to the Data Guard Manager
configuration by using the Create Configuration Wizard and choosing the
"Add an Exising standby" option. See note 214071.1 for additional
information.
.
"John Smith" <jon.smythe_at_ntlworld.com> wrote in message
news:EAcra.942$Ac.29832_at_newsfep4-glfd.server.ntli.net...
> Trying to set up a logical standby database through the data guard manager
> wizard on 9.2.0.3.0, keep getting the error below, any ideas? The database
> is on an NT machine and I am trying to build the standby on another nt
> machine with exactly the same software etc. I can build a physical standby
> using the wizard by the logical keeps failing.
>
> Jon
>
> Copying datafile D:\ORACLE\ORADATA\OLAP\UNDOTBS01.DBF to
> d:\oracle\oradata\olap3\UNDOTBS01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\CWMLITE01.DBF to
> d:\oracle\oradata\olap3\CWMLITE01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\DRSYS01.DBF to
> d:\oracle\oradata\olap3\DRSYS01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\EXAMPLE01.DBF to
> d:\oracle\oradata\olap3\EXAMPLE01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\INDX01.DBF to
> d:\oracle\oradata\olap3\INDX01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\ODM01.DBF to
> d:\oracle\oradata\olap3\ODM01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\TOOLS01.DBF to
> d:\oracle\oradata\olap3\TOOLS01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\USERS01.DBF to
> d:\oracle\oradata\olap3\USERS01.DBF...
> Copying datafile D:\ORACLE\ORADATA\OLAP\XDB01.DBF to
> d:\oracle\oradata\olap3\XDB01.DBF...
> Total time to copy datafiles: 00:22:01
> Opening primary database...
> Building logical standby data dictionary...
> Establishing Oracle home on node fred-nt.
> Installing initialization file on node fred-nt.
> Installing listener.ora file on node fred-nt.
> Starting listener on node fred-nt.
> Starting standby database...
> Renaming datafiles for standby database...
> Opening standby database...
> Adding tempfiles to standby database...
> Setting up log apply services for logical standby.
> Error running creation process on node fred-nt: Error starting log apply
> services for logical standby: ORA-01403: no data found
> ORA-06512: at "SYS.DBMS_LOGSTDBY", line 42
> ORA-06512: at line 1
>
>
Received on Wed Apr 30 2003 - 04:28:01 CDT
