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 the use of recording information about current session?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What the different components in replication and what is their use? : sql server DBA
how can you create a user-defined lock?
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you communicate with operating system files from oracle?
what is ora 24313?what is the procedure to exclude that error?
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?
Why would you use sql agent? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the commands you'd issue to show the explain plan for "select * from dual"?
How can you control the amount of free space in your index pages? : sql server DBA
how to restore files with rman?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.