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
6. The database should run in Archive log mode because you
cant take online if your database is running in No archive
log mode.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the default port no on which sql server listens? : 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 is dbcc? : sql server DBA
Why would you use sql agent? : sql server DBA
What happens on checkpoint? : sql server DBA
internal architecture
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
what is grd?
Where do you find the default index fill factor and how to change it? : sql server DBA
What is replication? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how to restore files with rman?
How to start SQL Server in minimal configuration mode?