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 / m.madhusudan reddy
No
5) shut immediate
startup mount
alter database archivelog
alter database open
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is asm?
What the different topologies in which replication can be configured? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
when does an alert gets signaled?
Explain about your sql server dba experience? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is a system database and what is a user database? : sql server DBA
Why would you call update statistics? : sql server DBA
What is fill factor? : sql server DBA
what is the use of ocr?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
what are the performance views in an oracle rac environment?
What are the different types of database compression introduced in sql server 2008? : sql server DBA