User Account

All Pages

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

  Write sql statement to create stored procedure

Write SQL statement which creates stored procedure with one int input parameter. The stored procedure selects the supplierId field and the total of all Count field values for each group of supplierId's from the Part table.

  Perform some basic sql join commands

Perform the following from the SQLZoo site. In the labs at school, you can generate a .pdf by printing the page to the pseudo printer CutePDF Writer. If you use the Chrome browser, it has a built-in feature for creating PDFs.

  Write sql create table statement to create pet table

Write an SQL CREATE TABLE statement to create the PET table without referential integrity constraint on OwnerID in PET.

  Identify the choice that best completes the statement

Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?

  Create a script file containing the pl/sql code

For the lab, you will need to create a script file containing the PL/SQL code that will address the lab steps below. Run the script file in your SQL*Plus session using the SET ECHO ON session command at the beginning to capture both the PL/SQL blo..

  Describe conceptually how an sql retrieval query

Question 1: Describe conceptually how an SQL retrieval query will be executed by specifying the conceptual order of executing each of the six clauses?

  Relational schema of a firm database - write a sql query

Display the vendor ID and vendor name of the items whose item quantity is the largest and display the item ID and item quantity of all items whoseitem quantity is less than the average quantity. Also display the average quantity

  Description of vulnerability, exploit and attack software

Describe the vulnerability that the attack exploits, including how or why the vulnerability exists; what versions of software are vulnerable.

  Important considerations when selecting network hardware

As a network administrator, what do you think are the most important considerations when selecting network hardware? Why?

  Write a select statement that returns three columns

Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns.

  Create the needed tables in the sql server environment

Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.

  Write a perl subroutine for temperature conversion

Write a perl subroutine for temperature conversion named ' convert_temp '. It should be able to handle both Fahrenheit to Celsius conversions as well as Celsius to Fahrenheit conversions.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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