Home » Server Options » Data Guard » shutdown down in primary database in Data guard environment
shutdown down in primary database in Data guard environment [message #463020] Tue, 29 June 2010 07:02 Go to next message
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 #463028 is a reply to message #463020] Tue, 29 June 2010 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is it normal?

Maybe yes, maybe no.
It depends on the type of shutdown and the activity on the instance.

Quote:
Furthermore, regarding backup i used veritas Netbackup to perform hotbackup. Can i still used the same principle.

Yes.

Regards
Michel
Re: shutdown down in primary database in Data guard environment [message #463031 is a reply to message #463028] Tue, 29 June 2010 07:43 Go to previous messageGo to next message
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 Go to previous message
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

Previous Topic: Creating Standby database in same HOST (SUN )
Next Topic: Is it possible to use dataguard from single instance to RAC instance ?
Goto Forum:
  


Current Time: Fri Mar 29 07:39:46 CDT 2024