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 / mohanamurali chittim
1.Ans) NO
5.Ans)go to mount state then give
alter database archivelog;
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What is dbcc? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What is the default port no on which sql server listens? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What authentication modes does sql server support? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What are statistics, under what circumstances they go out of date, how do you update them?
what is grd?
how can you create a user-defined lock?
how can you get actual data change values from previous transactions in oracle?