Answer / ramakrishnachallapalli

To take both backups we should keep database in archive log
mode.

Neither cold backup nor hot backup identify the corrupted
blocks in backup where as rman can identify

RMAN will take the backup of database used block only where as
hot backup will take physical existing database files
completely

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

What purpose does the model database server? : sql server DBA

0 Answers  

---

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

2 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 are the recovery models for a database? : sql server DBA

0 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

what are the differences of where and if in SAS?

0 Answers  

---

how to restore files with rman?

0 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---