Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 27040 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / uki
DB can be turned to archive log mode by turning the
LOGRETAIN parameter to RECOVERY and/or USEREXIT to YES. DB
will be in backup pending state which in turn requires to
be taken an offline backup to bring back the db to normal.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is the diffrence between core dba and apps dba?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the default fill factor value? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
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 are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the recovery models for a database? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
internal architecture
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.
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
what are the benefits of flashback feature?
What types of replication are supported in sql server? : sql server DBA
how can you find out if a table can be redefined?
