Answer / Girish Kumar Arya

Since the database is in NOARCHIVE log mode, you cannot recover from backup as point-in-time recovery (PITR) is not possible. You would need to restore a good copy of the corrupted tablespace from a backup taken before corruption occurred. However, any changes made to the other tablespaces after the backup will be lost. To avoid data loss, consider switching to ARCHIVE log mode and performing PITR.

how can you get actual data change values from previous transactions in oracle?

1 Answers   Oracle,

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

what r the types of backup?

5 Answers   CSC,

---

Why would you call update statistics? : sql server DBA

1 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  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

1 Answers   Infosys,

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

wat is global index and local indes

1 Answers   Oracle,

---

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1 Answers  

---

what do you understand by flashback feature of oracle?

1 Answers   Oracle,

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

what are the benefits of flashback feature?

1 Answers   Oracle,

---