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 to correction create the beach table

Write SQL to correction create the BEACH table, Write SQL to inset the data into the BEACH table

  Create queries in sql

Create queries in SQL that will provide the data to answer the business questions (they are listed below). In addition, create a Data Dictionary for the tables

  Write a pl-sql block

Write a PL/SQ block - Select the average salary of all employees in department number 20.

  Write sql commands to implement profile

Write SQL commands which would implement this profile. Next, write query that would list profile, profile resource name, and limit value for the new profile.

  Create a clustered index on the groupid column

Write the CREATE INDEX statements to create a clustered index on the GroupID column and a nonclustered index on the IndividuallD column of the GroupMembership table.

  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?

  Strategies for improving the performance of sql queries

Discuss some possible solutions and strategies for improving the performance of SQL queries and their ability to provide data to users and identify the performance or usability issues that need to be addressed.

  Describe the meaning of keyword exists and not exists

Describe the meaning of the keyword EXISTS. Describe how any and all relate to EXISTS and NOT EXISTS. Write a query which will display names of any customers who are interested in all artists.

  Play a significant role in the sql injection attack steps

Examine the critical manner in which different database systems (e.g., Oracle, MySQL, or Microsoft SQL Server-based, etc.) can play a significant role in the SQL injection attack steps.

  Create a new table named fictioncopies

Create a new table named FictionCopies using the data in the BookCode, Title, BranchNum, CopyNum, Quality, and Price columns for those books that have the type FIC.

  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."

  Write a select statement that joins the customers table

Write a SELECT statement that joins the Customers table to the Addresses table and returns these columns: FirstName, LastName, Line1, City, State, ZipCode.

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