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 / sanju
shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
when does an alert gets signaled?
What is the default fill factor value? : sql server DBA
internal architecture
What would you do with an "in-doubt" distributed transaction?
What authentication modes does sql server support? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Explain about your sql server dba experience? : sql server DBA
how can you connect from 10g user to 11g user??
What are the commands used in dcl? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is dcl? : sql server DBA
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
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is logical system in sap basis