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
- 24567 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohanamurali chittim
1.Ans) NO
5.Ans)go to mount state then give
alter database archivelog;
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are the steps you will take to improve performance of a poor performing query?
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
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How can you control the amount of free space in your index pages? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can a session indicate its interest in receiving alerts?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
what is logical system in sap basis
Explain about your sql server dba experience? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
