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
- 27458 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
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
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
What are the operating modes in which database mirroring runs? : sql server DBA
how does an oracle clusterware manage crs resources?
what is grd?
how can you process messages in order asynchronously?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you schedule a job in database?
what do you understand by fine-grained auditing?
how can you enable flashback feature?
What purpose does the model database server? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is the difference between dropping a database and taking a database offline? : sql server DBA
