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
- 23761 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
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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 is dbcc? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What purpose does the model database server? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you schedule a job in database?
What is the difference between clustered and non-clustered index? : sql server DBA
how to restore files with rman?
What the different components in replication and what is their use? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different sql server versions you have worked on? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
