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 grd?
what functionality does oracle provide to secure sensitive information?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what do you understand by flashback feature of oracle?
How do you trace the traffic hitting a sql server? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are statistics, under what circumstances they go out of date, how do you update them?
Explain materialized views and how they are used.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA