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 / 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 the different topologies in which replication can be configured? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
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?
how can you initialize log miner?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain about your sql server dba experience? : sql server DBA
what are the differences of where and if in SAS?
What is the difference between dropping a database and taking a database offline? : sql server 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
how can you create a user-defined lock?
how can you implement fine-grained auditing?