Answer Posted / amsu

4. No you can't take online backup while database in
NOARCHIVELOG mode.

5. shutdown immediate
startup mount
alter database archivelog;
alter database open;
6. Best way is keep the database in archive log mode.
That will help to recover the database up to last
committed transaction. Oracle recommendation is keep
the database in archive log mode.

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

1775

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1685

---

Why does Oracle not permit the use of PCTUSED with indexes?

2442

---

What are the commands used in dcl? : sql server DBA

661

---

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

698

---

---

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?

2468

---

What are the different types of indexes available in sql server? : sql server DBA

664

---

What is a correlated sub-query? : sql server DBA

667

---

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

668

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1741

---

How do you open a cluster administrator? : sql server DBA

659

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

666

---

what do you understand by fine-grained auditing?

726

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

672

---

What is dcl? : sql server DBA

750

---