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?
- 11 Answers
- 24582 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Query processing is slow(eg select query)how will u solve that
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
internal architecture
What types of replication are supported in sql server? : sql server DBA
what is the role of dip user in our database?
what is ora 24313?what is the procedure to exclude that error?
how can you enable flashback feature?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
when does an alert gets signaled?
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 you'd issue to show the explain plan for "select * from dual"?
how can you process messages in order asynchronously?
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
