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 / ramakrishna
no we can't take a backup while in no archive log mode to
enable archive log: alter database archivelog;
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain about your sql server dba experience? : sql server DBA
What is dbcc? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What are the commands used in dcl? : sql server DBA
what is asm?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you connect from 10g user to 11g user??
What is the default fill factor value? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Where would you look for errors from the database engine?
How do you trace the traffic hitting a sql server? : sql server DBA
how can you communicate with operating system files from oracle?
what is grd?
What are statistics, under what circumstances they go out of date, how do you update them?
What is the difference between dropping a database and taking a database offline? : sql server DBA