Printable View
physical Standby database -- 10.1.0.3.0
The ALTER DATABASE OPEN READ ONLY; command hangs and its not giving the 'database altered' message and its not returning the prompt, when i open the another sqlplus
window and check the open mode its read only...is there anyknow issues..This command is part of my recovery script and therefore its not performing the rest of the job in the script...any issues with this command in 10g standby ...
Sounds like a possible bug. Might want to open up a tar.
Might as well open one anyway considering you're just beta testing.
is log_archive_start=true on the standby?Quote:
Originally posted by Akila
physical Standby database -- 10.1.0.3.0
The ALTER DATABASE OPEN READ ONLY; command hangs and its not giving the 'database altered' message and its not returning the prompt, when i open the another sqlplus
window and check the open mode its read only...is there anyknow issues..This command is part of my recovery script and therefore its not performing the rest of the job in the script...any issues with this command in 10g standby ...
As this parameter is deprecated in 10G , we didnt set anythg, its in its default value of FALSE.
This is part of the alert file of my standby server....There is no errors...
Wed Feb 02 02:12:20 2005
Alter Database Open Read Only
Wed Feb 02 02:12:20 2005
SMON: enabling cache recovery
Wed Feb 02 02:12:21 2005
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Feb 02 02:12:23 2005
Starting background process MMON
MMON started with pid=13, OS id=1992
Wed Feb 02 02:12:23 2005
Starting background process MMNL
MMNL started with pid=14, OS id=2924
Wed Feb 02 02:12:23 2005
Physical standby database opened for read only
but still the sqlplus window hangs......
Looks like a bug....opened a TAR....