Question
What is the most important action a DBA must perform after changing the database from NOARCHIVELOG TO ARCHIVELOG?
Answers
First of all take an offline backup of whole database (including the (datafile controlfile and redolog files). It is obvious that archive log process should be started by:
SQL>alter system Archivelog start;
Otherwise the database halts if unable to rotate redo logs   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Can you master back to xdcam disk?
  • Q Explain code access security.
  • Q Explain: a.) Intimate Shared Memory(ISM) b.) Engines c.) Mirroring
  • Q What are the advantages of using django for web development?
  • Q Does a class inherit constructors of its superclass in java programming?
  • Q The solution used to detect sugar in the urine is:
  • Q Why is it important for the amount of water intake to equal the amount of water output?
  • Q Which movement was launched by the Union Government to encourage people to voluntarily give up their subsidy amount given on LPG cylinders?
  • Q What is the role of repeater in a network?
  • Q Which is known as Rainbow metal?
  • Q The Union Government of India has given its approval for disinvestment of how much percent in the National Thermal Power Corporation (NTPC)?