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 / 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
What is the default fill factor value? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What is the importance of a recovery model? : sql server DBA
how can you initialize log miner?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
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"?
how can you record information about current session?
What is transparent data encryption? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
how can you get actual data change values from previous transactions in oracle?