| Unable to start ACTIVE DATAGUARD [message #448253] |
Mon, 22 March 2010 05:29  |
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
|
Member |
|
|
Hi,
I am unable to start ACTIVE DATAGUARD in 11g.
SQL> startup
ORACLE instance started.
Total System Global Area 522092544 bytes
Fixed Size 2090224 bytes
Variable Size 180362000 bytes
Database Buffers 331350016 bytes
Redo Buffers 8290304 bytes
Database mounted.
Database opened.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
Database altered.
SQL> select count(*) from scott.test;
select count(*) from scott.test
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
I dont know where I did mistake, Please help me out.
Thanks,
Suresh
|
|
|
|
| Re: Unable to start ACTIVE DATAGUARD [message #448268 is a reply to message #448253] |
Mon, 22 March 2010 07:37  |
Yasir Hashmi
Messages: 304
Registered: April 2006
|
Senior Member |
|
|
Hi,
You already have started your datagaurd by the statement:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;
IT seems even if your database is open for read only access once you this command,oracle puts the database in mount mode and start r edo/log apply.
As you cannot simuntaneously open the database and apply redo, you get the error as the database now is in mount mode.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
