Answer / pvenkiroyal

select to_char(startup_time,'hh24:mi:ss dd-mom-yy') from
v$instance;

Answer / mohapatra.gouranga@gmail.com

In RAC env.

select instance_name,status,host_name,to_char
(startup_time,'DD-MON-YY HH24:MI:SS')
from gv$instance order by instance_name;

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

If we issue alter database begin backup. What happens to database?

2 Answers  

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---