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 / guest
1.no
2.archive mode enable level.
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How do you open a cluster administrator? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what are the types of connection load-balancing?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is grd?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Query processing is slow(eg select query)how will u solve that
What are the commands used in dcl? : sql server DBA
how can you record information about current session?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Why would you call update statistics? : sql server DBA