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 / sanju
shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you redefine a table online?
what do you understand by fine-grained auditing?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the recovery models for a database? : sql server DBA
how can you connect from 10g user to 11g user??
What is dbcc? : sql server DBA
how can you schedule a job in database?
what is the use of recording information about current session?
How can you control the amount of free space in your index pages? : sql server DBA
how does an oracle clusterware manage crs resources?
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 is grd?
what is ora 24313?what is the procedure to exclude that error?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What would you do with an "in-doubt" distributed transaction?