error when implement dataguard in single solaris 10?

liontiger

i implement dataguard in solaris10/oracle10g , but can't startup oracle from the standby site.
note: "primary site" and "standby site" are in the same solaris 10.

I did it from primary site:

**************************
SQL> startup
ORACLE instance started.

Total System Global Area  373293056 bytes
Fixed Size                  1978784 bytes
Variable Size             142610016 bytes
Database Buffers          226492416 bytes
Redo Buffers                2211840 bytes
Database mounted.
Database opened.
SQL> alter database begin backup;

Database altered.



SQL> host cp /export/home/ora10g/ora10g/*.dbf /datafrom

SQL> alter database end backup;

Database altered.

SQL> alter system archive log current;

System altered.


SQL> alter database create standby controlfile as '/datafrom/control01.ctl';

Database altered.

******************************

when I startup oracle from standby site, it showed me this error:



SQL> startup
ORACLE instance started.

Total System Global Area  373293056 bytes
Fixed Size                  1978784 bytes
Variable Size             113249888 bytes
Database Buffers          255852544 bytes
Redo Buffers                2211840 bytes
Database mounted.
ORA-16004: backup database requires recovery
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/datafrom/system01.dbf'



can anyone give me your hand? how to solve this problem ? thanks in advance?

liontiger

i have recovered standby database, but it seem still can't open standby database!!!! can anyone help to have a look at it? thx.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area  373293056 bytes
Fixed Size                  1978784 bytes
Variable Size             113249888 bytes
Database Buffers          255852544 bytes
Redo Buffers                2211840 bytes
SQL> alter database mount standby database;

Database altered.

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now


SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open real only;
alter database open real only
                    *
ERROR at line 1:
ORA-02288: invalid OPEN mode


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/datafrom/system01.dbf'


SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01666: control file is for a standby database

用户密码不对

transfer the archivelog(or online redo log), then recovery, at last try again

liontiger

have tried again, but the problem still exists.........................