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 / 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
What happens on checkpoint? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the use of recording information about current session?
Explain materialized views and how they are used.
How would you best determine why your MVIEW couldn't FAST REFRESH?
What would you do with an "in-doubt" distributed transaction?
how can you schedule a job in database?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is asm?
what do you understand by fine-grained auditing?
Where do you find the default index fill factor and how to change it? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How to start SQL Server in minimal configuration mode?
Explain about your sql server dba experience? : sql server DBA
how can you create a user-defined lock?