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 / amit bhagat
6. The database should run in Archive log mode because you
cant take online if your database is running in No archive
log mode.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the different types of indexes available in sql server? : sql server DBA
Why would you use sql agent? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Explain about your sql server dba experience? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
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.
What are the different sql server versions you have worked on? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
how can you record information about current session?
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is logical system in sap basis
what do you understand by fine-grained auditing?