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
- 27942 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / binod
Noway, it can't be possibleto take ONLINE backup if the
database is running in an noarchievelog mode..
FOR altering the database into archieve log mode the
following steps should be consider-
1.shutdown your database
2.reopen the database but this time with the "mount" option
which will mount the instance but not open it.
3.Now your database can be back up
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can you enable flashback feature?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the steps you will take to improve performance of a poor performing query?
what is a user-defined lock?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what are the differences of where and if in SAS?
What are the operating modes in which database mirroring runs? : sql server DBA
when does an alert gets signaled?
how does an oracle clusterware manage crs resources?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What the different topologies in which replication can be configured? : sql server DBA
Query processing is slow(eg select query)how will u solve that
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
