Describe theways to backup an oracle database

Assignment Help PL-SQL Programming
Reference no: EM13849560

Q1. Describe three ways to backup an Oracle database

1. Incremental backups - this method will store only blocks that have changed since the previous backup. This will allow backups to be more compact and will provide faster recovery.

2. Binary compression - this method is integrated with Oracle Database and will reduce the size of the backups

3. Automated database duplication - creates a copy of your database with various storage configurations, specifically direct duplication between ADM databases

Q2. Describe the advantages/disadvantages and what is happening between archivelog mode and no archivelog mode. How does it affect backup and recovery?

Q3. Describe the jobs mechanism in Oracle. How are they scheduled?

Q4. We've been using pluggable databases all course long....describe the benefits of using pluggable databases. Why would you not use a pluggable database?

Q5. Describe the jobs mechanism in Oracle. How are they scheduled?

The choice of using ARCHIVELOG mode or not depends on system requirements. ARCHIVELOG mode allows for full backups and should be enabled for mission-critical data. If a database is in NOARCHIVELOG mode, then a backup can only be recovered to the point of the last full backup. Any additional changes made after this point are not logged, so they cannot be recovered. Also, in this mode, tablespace backups cannot be performed while the database is online. They must be performed while the database is closed (Choosing Between NOARCHIVELOG and ARCHIVELOG Mode, n.d.).

ARCHIVELOG mode essentially enables the use of redo logs to archive transactions. It offers three advantages:

A full database recovery can be performed with a combination of the last full database backup and the online redo log files.

You can use a backup taken while the database is open and in normal use.

You can keep a redundant, standby database current with its original counterpart by continuously applying the redo log produced by the original database to the standby.

The one major disadvantage of ARCHIVELOG mode is that it requires additional space in order to store the log information.

NOARCHIVE mode does have its advantages. Because there is no writing of transactions to a redo log, performance is increased.

To perform a "cold" backup in NOARCHIVELOG mode, the following steps are required:

Shut down the database

Create backup copies of all the data files, control files, and temporary database files

Restart the database

To perform a "hot" back with ARCHIVELOG mode, the following steps are required:

Alter the database/tablespace into backup mode

Copy the data files with an OS utility

Alter the database/tablespace out of backup mode

Archive the current online redo log

Backup the control file

Backup any archive redo log files generated during the backup

Reference no: EM13849560

Questions Cloud

The database design proposal assignment : The Database Design Proposal assignment
Information security awareness training : Information Security Awareness Training
Problem solving in your community : Problem Solving in Your Community- Write a 2 page paper. Address the following in your paper: Explain a problem in your community and how you might solve this problem if you were a police officer
Analyze the practice of dumping dangerous drugs overseas : Follow the link below, read the article and analyze the practice of "dumping" dangerous drugs overseas. Can an American company be penalized for marketing a product deemed unsafe by the U.S., if it is not also banned by the foreign government
Describe theways to backup an oracle database : Describe three ways to backup an Oracle database
Compensation of salespersons from fixed annual salaries : Change the compensation of salespersons from fixed annual salaries totaling $150,000 to total salaries of $60,000 plus a 5% commission on sale
Investor information-company information : You will be asked to select a company that is publically traded. You must research and secure the SEC 10-K Annual Report for the most recent year. This is often available at the company web site. Look for "Investor Information" or "Company Informa..
Identify a relevant thesis statement or question : Identify a relevant Thesis Statement or Question from the article - Identify the strengths and weaknesses of the article based on the Thesis Statement
How do civil law systems of justice differ from common law : How do civil law systems of justice differ from common law systems of justice? How have some civil law traditions affected the United States

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd