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
- 27620 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sanju
shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a system database and what is a user database? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What the different types of replication and why are they used? : sql server DBA
Why would you call update statistics? : sql server DBA
what is the diffrence between core dba and apps dba?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Explain materialized views and how they are used.
What are the commands you'd issue to show the explain plan for "select * from dual"?
what is a crs resource?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you process messages in order asynchronously?
What are the steps you will take to improve performance of a poor performing query?
how can you initialize log miner?
