How do you find out from the RMAN catalog if a particular
archive log has been backed-up?
Answer Posted / narmada kumari
The database should be in ARCHIVE mode if you are going to
use RMAN as backup method.
Is This Answer Correct ? | 16 Yes | 13 No |
Post New Answer View All 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
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
what is the use of ocr?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
internal architecture
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are the commands you'd issue to show the explain plan for "select * from dual"?
Query processing is slow(eg select query)how will u solve that
What authentication modes does sql server support? : sql server DBA
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.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you enable flashback feature?
what is asm?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?