Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
Answer Posted / guest
1.no
2.archive mode enable level.
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is the role of dip user in our database?
What is replication? : sql server DBA
Explain materialized views and how they are used.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
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?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is fill factor? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What is the difference between clustered and non-clustered index? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
what functionality does oracle provide to secure sensitive information?
What purpose does the model database server? : sql server DBA
what are the types of connection load-balancing?