shutdown down in primary database in Data guard environment [message #463020] |
Tue, 29 June 2010 07:02 |
sailesh
Messages: 72 Registered: September 2007 Location: MAURITIUS
|
Member |
|
|
Hi all,
I have configured data Guard on oracle 11gR2. It is working fine. The only issue i am facing is that when i am stopping the database on the primary server, it is taking a long long time to down the database.
Is it normal?
Furthermore, regarding backup i used veritas Netbackup to perform hotbackup. Can i still used the same principle.
Please help?
Thanks,
Sailesh
|
|
|
|
Re: shutdown down in primary database in Data guard environment [message #463031 is a reply to message #463028] |
Tue, 29 June 2010 07:43 |
sailesh
Messages: 72 Registered: September 2007 Location: MAURITIUS
|
Member |
|
|
Hi,
i am using shutdown immediate option. Furthermore, there is no activity on the instance.
Is there any procedure for shutdown the database in a data Guard environment?
i have waited 2 hours for shut down the db for both primary and physical standby?
I am getting a warning on my physical standby db:
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
WARNING: -------------------------------
WARNING: oradism did not start up correctly.
Dynamic ISM can not be locked.----------------------------------------
oradism creation failed for unknown reasons 0 8 100
Tue Jun 29 16:27:55 2010
Tue Jun 29 16:28:09 2010
WARNING: Detected too many memory locking problems.
WARNING: Performance degradation may occur
Thanks,
Sailesh
|
|
|
cannot shutdown database in a data Guard environment [message #463241 is a reply to message #463028] |
Wed, 30 June 2010 06:23 |
sailesh
Messages: 72 Registered: September 2007 Location: MAURITIUS
|
Member |
|
|
Hi,
I am facing another problem in my data guard env. Now i am unable to shutdown the dababase for primary and physical standby. Each time i have to shutdown abort. with shutdown immediate it never shut down.
Furthermore, if i do not enable the transmission of archive from my primary to the physical standby, i can shut it down with shutdown immediate.
i used the command below to enable the transfer of redo:
alter system set log_archive_dest_state_2 = enable
once i enable the transfer, i cannot shutdown the db with shutdown immediate. But with shutdown abort it works.
Please help.
Thanks,
Sailesh
|
|
|