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 do you understand by flashback feature of oracle?
What types of replication are supported in sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is transparent data encryption? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how can you implement fine-grained auditing?
What is dbcc? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
what is the diffrence between core dba and apps dba?
What is the difference between dropping a database and taking a database offline? : sql server DBA
what are the benefits of flashback feature?
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.