What are the different kind of export backups?

What are the different kind of export backups?
by

1 Answer

Answer :

Full back - Complete database
Incremental - Only affected tables from last incremental date/full
backup date.
Cumulative backup - Only affected table from the last cumulative
date/full backup date.
by

Related questions

What is the difference between online and offline backups? (for DBA

Description : What is the difference between online and offline backups? (for DBA

Last Answer : A hot backup is a backup performed while the database is online and available for read/write. Except for Oracle exports, one can only do on- line backups when running in ARCHIVELOG mode. A cold backup is a backup performed while the database is off-line and unavailable to its users.

How does one do on-line database backups? (for DBA

Description : How does one do on-line database backups? (for DBA

Last Answer : Each tablespace that needs to be backed-up must be switched into backup mode before copying the files out to secondary storage (tapes). Look at this simple example. ALTER TABLESPACE xyz ... files while in backup mode. This will lead to excessive database archiving and even database freezes.

How does one do off-line database backups? (for DBA

Description : How does one do off-line database backups? (for DBA

Last Answer : Shut down the database from sqlplus or server manager. Backup all files to secondary storage (eg. tapes). Ensure that you backup all data files, all control files and all log files. When ... at a convenient time, switch your database into ARCHIVELOG mode and perform hot (on-line) backups.

Will RMAN takes backups of read-only tablespaces?

Description : Will RMAN takes backups of read-only tablespaces?

Last Answer : No

What is the recommended method to make backups of a RAC environment?

Description : What is the recommended method to make backups of a RAC environment?

Last Answer : RMAN to make backups of the database, dd to backup your voting disk and hard copies of the OCR file.

What is the most important requirement in order to use RMAN to make consistent hot backups

Description : What is the most important requirement in order to use RMAN to make consistent hot backups

Last Answer : Your database has to be in ARCHIVELOG mode.

Can one import/export between different versions of Oracle? (for DBA

Description : Can one import/export between different versions of Oracle? (for DBA

Last Answer : Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. ... database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.

Can one export a subset of a table? (for DBA

Description : Can one export a subset of a table? (for DBA

Last Answer : From Oracle8i one can use the QUERY= export parameter to selectively unload a subset of the data from a table. Look at this example: exp scott/tiger tables=emp query=\"where deptno=10\"

How does one use the import/export utilities? (for DBA

Description : How does one use the import/export utilities? (for DBA

Last Answer : Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin directory. One can run them interactively, using command line parameters, or using parameter files. Look at the imp/exp parameters ... and export data with the "Schema Manager" GUI that ships with Oracle Enterprise Manager (OEM).

What is import/export and why does one need it? (for DBA

Description : What is import/export and why does one need it? (for DBA

Last Answer : The Oracle export (EXP) and import (IMP) utilities are used to perform logical database backup and recovery. They are also used to move Oracle data from one machine, database or schema to ... corruption. Ensure that all the data can be read. . Transporting tablespaces between databases . Etc.

How does one backup a database using the export utility? (for DBA

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

What are the common Import/ Export problems? (for DBA

Description : What are the common Import/ Export problems? (for DBA

Last Answer : ORA-00001: Unique constraint (...) violated - You are importing duplicate rows. Use IGNORE=NO to skip tables that already exist (imp will give an error if the object is re-created). ORA-01555: ... =Y import parameter to ignore these errors, but be careful as you might end up with duplicate rows.

How can one improve Import/ Export performance? (for DBA

Description : How can one improve Import/ Export performance? (for DBA

Last Answer : EXPORT: . Set the BUFFER parameter to a high value (e.g. 2M) . Set the RECORDLENGTH parameter to a high value (e.g. 64K) . Stop unnecessary applications to free-up ... the import parameter file to avoid time consuming ANALYZE statements . Remember to run the indexfile previously created

Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA

Description : Can one export to multiple files?/ Can one beat the Unix 2 Gig limit? (for DBA

Last Answer : From Oracle8i, the export utility supports multiple output files. This feature enables large exports to be divided into files whose sizes will not exceed any operating system limits (FILESIZE= parameter). When ... > scott.exp.gz & # feed the pipe exp userid=scott/tiger file=exp.pipe ...

What is COMPRESS and CONSISTENT setting in EXPORT utility?

Description : What is COMPRESS and CONSISTENT setting in EXPORT utility?

Last Answer : COMPRESS Simply: COMPRESS=n - Allocated space in database for imported table will be exactly as the space required to hold the data. COMPRESS=y - The INITIAL extent of the table would be ... . To minimize this possibility, export those tables at a time when updates are not being done.

Have you lost any files that you could have prevented with backups in the last year? Please say also if you haven't. This is kind of a statistic. Feel free to share horror stories. I've been there. Thanks :)

Description : Have you lost any files that you could have prevented with backups in the last year? Please say also if you haven't. This is kind of a statistic. Feel free to share horror stories. I've been there. Thanks :)

Last Answer : I haven’t but I work in the computer industry and know a lot of people who have. Hard disk failure is the usually the cause, but back in the days of floppies I knew someone who was keeping their backups “safe” by sticking them to a fridge with fridge magnets!

Which of the following can be used for reducing recovery time? a) Automatic failover b) By taking backup on a faster device c) Taking multiple backups – one in same location, another at different location d) All of the mentioned

Description : Which of the following can be used for reducing recovery time? a) Automatic failover b) By taking backup on a faster device c) Taking multiple backups – one in same location, another at different location d) All of the mentioned

Last Answer : All of the mentioned

Which of the following can be used for reducing recovery time? a) Automatic failover b) By taking backup on a faster device c) Taking multiple backups – one in same location, another at different location d) All of the mentioned

Description : Which of the following can be used for reducing recovery time? a) Automatic failover b) By taking backup on a faster device c) Taking multiple backups – one in same location, another at different location d) All of the mentioned

Last Answer : All of the mentioned

Is BitLocker disk encryption compatible with online/offline backups?

Description : Is BitLocker disk encryption compatible with online/offline backups?

Last Answer : answer:Are you completely settled on Bit Locker? it was developed by Microsoft and is almost all proprietary (not open source) software. Microsoft has worked with NSA and other organizations in the past. ... to make to you - just that BitLocker is somewhat suspect from a security point of view.

Why are my hourly 'Time Machine' backups so HUGE!

Description : Why are my hourly 'Time Machine' backups so HUGE!

Last Answer : Are you using a program like Parallels, that stores things in a huge file? There are a few other programs like that out there, too. You need to exclude those files. I’ll see if I can find the link I read a couple of years ago about this, and if so I’ll post it.

I've been using Backup on my Mac to back up my home folder. It has been putting these backups on my hard drive. Now I want to put all my backups on my Seagate external drive. Can I safely delete the backups that are on my hard drive since they're taking up 80 GB of space?

Description : I've been using Backup on my Mac to back up my home folder. It has been putting these backups on my hard drive. Now I want to put all my backups on my Seagate external drive. Can I safely delete the backups that are on my hard drive since they're taking up 80 GB of space?

Last Answer : Plug the seagate in and it will ask you if you want to use the drive for time machine. Say yes, wait until it does a backup then delete the backups on your hard drive.

What's best: CCC or SuperDuper for bootable backups on Leopard?

Description : What's best: CCC or SuperDuper for bootable backups on Leopard?

Last Answer : answer:CarbonCopyCloner is free. SuperDuper is $27.95 for full functionality. I would tend to assume that any slowness perceived would be a function of how much data was in the incremental change, as ... than just the software. Under the covers, many of those are very similar in how they operate.

If I relocate a Backups.backupdb file from one Time Machine drive onto another blank drive, will the Mac simply continue backing up to the volume as normal?

Description : If I relocate a Backups.backupdb file from one Time Machine drive onto another blank drive, will the Mac simply continue backing up to the volume as normal?

Last Answer : answer:oooh, good question, can’t test it at the moment, im not sure if time machine also identifies the volume of the drive, i’d have to get back on that one, currently not at home i mean, i could relocate it for you on the fly and test, i started fresh so i don’t care if it gets lost

Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Description : Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Last Answer : (a) Backups, access authorised are the techniques to secure data from damage and getting lost.

What are energy backups

Description : I will live alone but I do not understand the energy reserves. How it goes? Do I pay in advance or how is it? Thanks Minda

Last Answer : Well, you pay an amount every month as a deposit. A bill will be made at the end of the year and if you have an overpayment, they will refund your money.

Do you do regular backups of your main hard drive and any drive you store data on?

Description : Do you do regular backups of your main hard drive and any drive you store data on?

Last Answer : This is not my job, but sometimes I lost my important data, so I once decided to make a copy and save elsewhere. This was a fine point as this stores my important data which I need to use later. ... So the saved data is helpful for me. I have plan to buy Linux laptop next to overcome this problem.

Should I do daily backups of my site to overcome any hacking that could happen?

Description : Should I do daily backups of my site to overcome any hacking that could happen?

Last Answer : Today many website owners find they have issues with spam or being hacked. This can really damage a website and the downtime can destroy the site. People find it hard to maintain a site and ... backup from the day before, the hosting company could use your personal backup to restore your website.

What is the benefit of the Networking? A. File Sharing B. Easier access to Resources C. Easier Backups D. All of the Above

Description : What is the benefit of the Networking? A. File Sharing B. Easier access to Resources C. Easier Backups D. All of the Above

Last Answer : D. All of the Above

Which of the following is an example of an unmanaged storage utility set up to do automated backups? a) XDrive b) OmniDrive c) FreeDrive d) All of the mentioned

Description : Which of the following is an example of an unmanaged storage utility set up to do automated backups? a) XDrive b) OmniDrive c) FreeDrive d) All of the mentioned

Last Answer : All of the mentioned

What kind of jobs can one schedule with OEM? (for DBA

Description : What kind of jobs can one schedule with OEM? (for DBA

Last Answer : OEM comes with pre-defined jobs like Export, Import, run OS commands, run sql scripts, SQL*Plus commands etc. It also gives you the flexibility of scheduling custom jobs written with the TCL language.

What are the different objects that you cannot copy or reference in object groups?

Description : What are the different objects that you cannot copy or reference in object groups?

Last Answer : Objects of different modules Another object groups Individual block dependent items Program units.

What are the different types of segments?

Description : What are the different types of segments?

Last Answer : Data segment, index segment, rollback segment and temporary segment.

What are the different modes of mounting a Database with the Parallel Server ?

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

What are the Different Optimisation Techniques

Description : What are the Different Optimisation Techniques

Last Answer : The Various Optimisation techniques are a) Execute Plan :: we can see the plan of the query and change it accordingly based on the indexes b) Optimizer_hint :: set_item_property('DeptBlock', ... SQL statements reuse the cursor. f45run module = my_firstform userid = scott/tiger optimize_Tp = No

Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Description : Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

Last Answer : SELECT customer_no, payments from customer C1 WHERE 3

What are the different types of Coordinations of the Master with the Detail block?

Description : What are the different types of Coordinations of the Master with the Detail block?

Last Answer : POPULATE_GROUP(function) POPULATE_GROUP_WITH_QUERY(function) SET_GROUP_CHAR_CELL(procedure) SET_GROUPCELL(procedure) SET_GROUP_NUMBER_CELL(procedure)

What is a join ? Explain the different types of joins ?

Description : What is a join ? Explain the different types of joins ?

Last Answer : Join is a query which retrieves related columns or rows from multiple tables.Self Join - Joining the table with itself.Equi Join - Joining two tables by equating two common columns.Non-Equi Join - ... that query can also retrieve rows that do not have corresponding join value in the other table.

What are different modes of parameters used in functions and procedures?

Description : What are different modes of parameters used in functions and procedures?

Last Answer : IN -OUT -INOUT

What are different Oracle database objects?

Description : What are different Oracle database objects?

Last Answer : TABLES -VIEWS INDEXES -SYNONYMS -SEQUENCES -TABLESPACES etc

What is an UTL_FILE.What are different procedures and functions associated with it?

Description : What is an UTL_FILE.What are different procedures and functions associated with it?

Last Answer : UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, ... , PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What are the different type of a record group?

Description : What are the different type of a record group?

Last Answer : Query record group Static record group Non query record group

What are the different types of windows?

Description : What are the different types of windows?

Last Answer : Root window, secondary window.

What are the different types of Package Procedure ?

Description : What are the different types of Package Procedure ?

Last Answer : 1. Restricted package procedure. 2. Unrestricted package procedure.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

What are the different methods of backing up oracle database ?

Description : What are the different methods of backing up oracle database ?

Last Answer : Logical Backups - Cold Backups - Hot Backups (Archive log)

How will you swap objects into a different table space for an existing database ?

Description : How will you swap objects into a different table space for an existing database ?

Last Answer : Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop necessary objects. Run the script newfile.sql after altering the tablespaces. Import from the backup for the necessary objects.

What are different types of images?

Description : What are different types of images?

Last Answer : Boiler plate imagesImage Items

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.