A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

603

What is the difference between sga and pga?

618

What is ora-1555 snapshot too old error? Explain in detail?

683

What is end user in database?

597

Discuss row chaining, how does it happen?

569

While taking hot backup (begin end backup) what will happens back end?

559

Explain the wait events in statspack report 'db scattered read'?

581

You see multiple fragments in the system tablespace, what should you check first?

584

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

566

What do you understand by the oracle?

551

What are the roles and responsibilities of oracle dba?

638

Who is dba in dbms?

581

What are the steps involved in instance recovery in oracle?

550

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1193

You see a wait on lms process in statspack, what does that mean?

574