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

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

1 Answer

Answer :

Your database has to be in ARCHIVELOG mode.
by

Related questions

Will RMAN takes backups of read-only tablespaces?

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

Last Answer : No

WHY USE RMAN ? (for DBA

Description : WHY USE RMAN ? (for DBA

Last Answer : No extra costs Its available free ?RMAN introduced in Oracle 8 it has become simpler with newer versions and easier than user managed backups ?Proper security ?You are 100% sure your ... what need to backed up Knows what is required for recovery Knows what backups are redundant

Is it possible to backup your database without the use of an RMAN database to store the catalog?

Description : Is it possible to backup your database without the use of an RMAN database to store the catalog?

Last Answer : Yes, but the catalog would be stored in the controlfile.

WHAT IS RMAN ? (for DBA

Description : WHAT IS RMAN ? (for DBA

Last Answer : Recovery Manager is a tool that: manages the process of creating backups and also manages the process of restoring and recovering from them.

What are the common RMAN errors (with solutions)? (for DBA

Description : What are the common RMAN errors (with solutions)? (for DBA

Last Answer : Some of the common RMAN errors are: RMAN-20242: Specification does not match any archivelog in the recovery catalog. Add to RMAN script: sql 'alter system archive log current'; RMAN-06089: archived log xyz not found or out of sync with catalog Execute from RMAN: change archivelog all validate;

How does one create a RMAN recovery catalog? (for DBA

Description : How does one create a RMAN recovery catalog? (for DBA

Last Answer : Start by creating a database schema (usually called rman). Assign an appropriate tablespace to it and grant it the recovery_catalog_owner role. Look at this example: sqlplus sys SQL>create user ... . Look at this example: rman catalog rman/rman target backdba/backdba RMAN> register database;

What are the differences between EBU and RMAN? (for DBA

Description : What are the differences between EBU and RMAN? (for DBA

Last Answer : Enterprise Backup Utility (EBU) is a functionally rich, high performance interface for backing up Oracle7 databases. It is sometimes referred to as OEBU for Oracle Enterprise Backup Utility. The Oracle Recovery ... Oracle7's EBU utility. However, there is no direct upgrade path from EBU to RMAN.

What third party tools can be used with Oracle EBU/ RMAN? (for DBA

Description : What third party tools can be used with Oracle EBU/ RMAN? (for DBA

Last Answer : The following Media Management Software Vendors have integrated their media management software packages with Oracle Recovery Manager and Oracle7 Enterprise Backup Utility. The Media Management ... and Recovery Sterling Software's SAMS:Alexandria - formerly from Spectralogic Sun Solstice Backup

How does one backup a database using RMAN? (for DBA

Description : How does one backup a database using RMAN? (for DBA

Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.

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

What are the different kind of export backups?

Description : What are the different kind of export backups?

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

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.

What is the use of CONSISTENT (Ver 7) option in EXP command ?

Description : What is the use of CONSISTENT (Ver 7) option in EXP command ?

Last Answer : A flag to indicate whether a read consistent version of all the exported objects should be maintained.

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.

The work of each assistant needs to be reviewed by personnel of at least equal competence. Which of the following is not one of the objectives of this requirement? a. The conclusions expressed are consistent with the result of the work performed and support the opinion. b. The work performed and the results obtained have been adequately documented. c. The audit objectives have been achieved. d. All available evidences have been obtained, evaluated and documented

Description : The work of each assistant needs to be reviewed by personnel of at least equal competence. Which of the following is not one of the objectives of this requirement? a. The conclusions ... The audit objectives have been achieved. d. All available evidences have been obtained, evaluated and documented

Last Answer : All available evidences have been obtained, evaluated and documented

The work of each assistant needs to be reviewed by personnel of at least equal competence. Which of the following is not one of the objectives of this requirement? a. The conclusions expressed are consistent with the result of the work performed and support the opinion. b. The work performed and the results obtained have been adequately documented. c. The objectives of the audit procedures have been achieved. d. All available evidences have been obtained, evaluated and documented.

Description : The work of each assistant needs to be reviewed by personnel of at least equal competence. Which of the following is not one of the objectives of this requirement? a. The conclusions ... audit procedures have been achieved. d. All available evidences have been obtained, evaluated and documented.

Last Answer : All available evidences have been obtained, evaluated and documented.

If every requirement stated in the Software Requirement Specification (SRS) has only one interpretation, SRS is said to be (A) correct. (B) unambiguous. (C) consistent. (D) verifiable.

Description : If every requirement stated in the Software Requirement Specification (SRS) has only one interpretation, SRS is said to be (A) correct. (B) unambiguous. (C) consistent. (D) verifiable.

Last Answer : (B) unambiguous.

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Description : Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Last Answer : A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is ... and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

What is hot backup and how it can be taken?

Description : What is hot backup and how it can be taken?

Last Answer : Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.

Does Oracle write to data files in begin/hot backup mode? (for DBA

Description : Does Oracle write to data files in begin/hot backup mode? (for DBA

Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.

What is cold backup and hot backup (in case of Oracle)?

Description : What is cold backup and hot backup (in case of Oracle)?

Last Answer : ∙ Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, usually from the disk ... was done. The database is restored to the most consistent state without any loss of committed transactions.

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.

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!

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

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

How important is it to be consistent?

Description : How important is it to be consistent?

Last Answer : My personal opinion on this is that sometimes, consistency is just an excuse for lazy thinking. It's easier to make sure your actions are consistent with your past actions than to really ... blanket rule and follow it always regardless of whether it's really appropriate for a specific situation.

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Write the order of precedence for validation of a column in a table ?

Description : Write the order of precedence for validation of a column in a table ?

Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?

State the order in which these triggers are executed ?

Description : State the order in which these triggers are executed ?

Last Answer : POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.

How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

If a break order is set on a column would it affect columns which are under the column?

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

What is the purpose of the product order option in the column property sheet?

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER The above is a) Not an error b) Error - the string in single quotes ‘NORTH’ and ‘SOUTH’ c) Error - the string should be in double quotes d) Error - ORDER BY clause

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

What is the minimum number of instances you need to have in order to create a RAC?

Description : What is the minimum number of instances you need to have in order to create a RAC?

Last Answer : 1. You can create a RAC with just one server.

What is the most important module in Oracle Financials? (for DBA

Description : What is the most important module in Oracle Financials? (for DBA

Last Answer : The General Ledger (GL) module is the basis for all other Oracle Financial modules. All other modules provide information to it. If you implement Oracle Financials, you should switch your current GL ... with it first to give your implementation team a chance to be familiar with Oracle Financials.

31. Replacement of steam based hot water generation by solar system is an example of a) Matching energy usage to the requirement b) Maximising system efficiency c) Energy substitution d) Performance improvement

Description : Replacement of steam based hot water generation by solar system is an example of a) Matching energy usage to the requirement b) Maximising system efficiency c) Energy substitution d) Performance improvement

Last Answer : Energy substitution

Legitimate and consistent way to make about $500/mo working remotely?

Description : Legitimate and consistent way to make about $500/mo working remotely?

Last Answer : answer:Try mturk.com I’m not sure if $500 is likely, but I think it’s possible if you really dedicate yourself.

Marketers must take steps to make sure that pricing objectives they set are consistent with the organisation's ___________ and ___________ . A)advertising objectives; marketing objectives B)overall objectives; marketing objectives C)marketing objectives; promotional objectives D)overall objectives; promotional objectives

Description : Marketers must take steps to make sure that pricing objectives they set are consistent with the organisation's ___________ and ___________ . A)advertising objectives; marketing ... ; marketing objectives C)marketing objectives; promotional objectives D)overall objectives; promotional objectives

Last Answer : B)overall objectives; marketing objectives