HPE Community
Operating System - HP-UX
1751935 Members
4906 Online
108783 Solutions
New Discussion юеВ

Check if Oracle 9i runningin stdby-modus

 
SOLVED
Go to solution
Kalin Evtimov
Regular Advisor

тАО07-16-2006 07:17 PM

тАО07-16-2006 07:17 PM

Check if Oracle 9i runningin stdby-modus

Hi everyone!
I am learning Oracle, I know how to start a DB in stdby modus, but how can I check afterwords if any database is running on stdby or not?

Thanks a lot!
0 Kudos
Reply
3 REPLIES 3
Sanjay Kumar Suri
Honored Contributor

тАО07-16-2006 08:08 PM

тАО07-16-2006 08:08 PM

Solution

Re: Check if Oracle 9i runningin stdby-modus

Check v$database

DATABASE_ROLE: Current role of the database; either primary or standby

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Reply
Yogeeraj_1
Honored Contributor

тАО07-16-2006 08:40 PM

тАО07-16-2006 08:40 PM

Re: Check if Oracle 9i runningin stdby-modus

hi,

you may also check your parameters by doing:
show parameter

and also force a log switch on the primary and see if it get shipped to the standby

(depending of course if you are running on manual or automatic)

hope this helps too!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Reply
Kalin Evtimov
Regular Advisor

тАО07-16-2006 10:26 PM

тАО07-16-2006 10:26 PM

Re: Check if Oracle 9i runningin stdby-modus

This was exactly what i needed, thanks!
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.