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
- 24562 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / amit bhagat
1). No, online backups is not possible in Noarchive log
mode.
2) Shutdown immediate
Starup mount
alter database archivelog;
alterdatabase open;
3) Database should run in Archivelog mode so that online
backup can be taken.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Which autogrowth database setting is good? : sql server DBA
when does an alert gets signaled?
How do you open a cluster administrator? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what do you understand by flashback feature of oracle?
what are the performance views in an oracle rac environment?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is transparent data encryption? : sql server DBA
how can you communicate with operating system files from oracle?
What are statistics, under what circumstances they go out of date, how do you update them?
who owns the operating system files created by the utl_file package?
What are the commands you'd issue to show the explain plan for "select * from dual"?
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?
what are the types of connection load-balancing?
