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

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

1 Answer

Answer :

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

Related questions

How many alert logs exist in a RAC environment?

Description : How many alert logs exist in a RAC environment?

Last Answer : One for each instance.

Which command will we use to manage (stop, start…) RAC services in command-line mode?

Description : Which command will we use to manage (stop, start…) RAC services in command-line mode?

Last Answer : srvctl

What is the difference between normal views and RAC views?

Description : What is the difference between normal views and RAC views?

Last Answer : RAC views has the prefix ‘G’. For example, GV$SESSION instead of V$SESSION

What RAC component is used for communication between instances?

Description : What RAC component is used for communication between instances?

Last Answer : Private Interconnect.

What was RAC previous name before it was called RAC?

Description : What was RAC previous name before it was called RAC?

Last Answer : OPS: Oracle Parallel Server

Can you have many database versions in the same RAC?

Description : Can you have many database versions in the same RAC?

Last Answer : Yes, but Clusterware version must be greater than the greater database version.

Name two specific RAC background processes

Description : Name two specific RAC background processes

Last Answer : RAC processes are: LMON, LMDx, LMSn, LKCx and DIAG.

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 command would you use to check the availability of the RAC system?

Description : What command would you use to check the availability of the RAC system?

Last Answer : crs_stat -t -v (-t -v are optional)

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.

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.

Will RMAN takes backups of read-only tablespaces?

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

Last Answer : No

Why are OPS$ accounts a security risk in a client/server environment? (for DBA

Description : Why are OPS$ accounts a security risk in a client/server environment? (for DBA

Last Answer : f you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be sure who they really are. With terminals, you can rely on operating system passwords, with Windows, you ... of whether you have identified your ID with a password or defined it to be IDENTIFIED EXTERNALLY.

What is the full form of 'RAC' ? -How To ?

Description : What is the full form of 'RAC' ? -How To ?

Last Answer : The full form of 'RAC' is Reservation Against Cancellation

RAC stands for A. Reservation Against Cancellation B. Reservation Against Collection C. Reservation against cancel D. None of These

Description : RAC stands for A. Reservation Against Cancellation B. Reservation Against Collection C. Reservation against cancel D. None of These

Last Answer : A [Reservation Against Cancellation]

Horse power of I.C. engines can be expressed as RAC rating, SAE rating, or DIN rating. To which countries these standards belong ?

Description : Horse power of I.C. engines can be expressed as RAC rating, SAE rating, or DIN rating. To which countries these standards belong ?

Last Answer : U.K., USA and Germany respectively.

. A permanent DRDO exhibition known as Darpan is established at (a) VRDE (b) INMAS (c) DRDE (d) RAC

Description : . A permanent DRDO exhibition known as Darpan is established at (a) VRDE (b) INMAS (c) DRDE (d) RAC

Last Answer : (d) RAC

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

Which of the above methods is the faster method?

Description : Which of the above methods is the faster method?

Last Answer : performing the calculation in the query is faster.

The technique called Gamete Intra Fallopian Transfer (GIFT) is recommended for those females (a) who cannot produce an ovum (b) who cannot retain the fetus inside uterus (c) whose cervical canal is too narrow to allow passage for the sperms (d) who cannot provide suitable environment for fertilisation.

Description : The technique called Gamete Intra Fallopian Transfer (GIFT) is recommended for those females (a) who cannot produce an ovum (b) who cannot retain the fetus inside uterus (c) whose cervical ... narrow to allow passage for the sperms (d) who cannot provide suitable environment for fertilisation.

Last Answer : (a) who cannot produce an ovum

What is The recommended method for cleaning sharp instruments is to?

Description : What is The recommended method for cleaning sharp instruments is to?

Last Answer : Need answer

What is the most highly recommended facial hair removal method for women?

Description : What is the most highly recommended facial hair removal method for women?

Last Answer : Shaving is still the best home removal system. Profesional removal would be best to get lazer removal since it will be permanent after a few treatments. The most recommended facial hair removal method for women is waxing or using a nair.

What method of hand hygiene is recommended for healthcare personnel in response to COVID-19?

Description : What method of hand hygiene is recommended for healthcare personnel in response to COVID-19?

Last Answer : Government continues to recommend the use of alcohol based hand sanitizer as the means of ensuring hand hygiene. It effectively reduces the number of microbes or pathogens that may be present on ... the restroom or public utilities and when soap and water is not available, always use sanitizers.

The method of design of flexible pavement as recommended by IRC is (A) Group index method (B) CBR method (C) Westergaard method (D) Benkelman beam method

Description : The method of design of flexible pavement as recommended by IRC is (A) Group index method (B) CBR method (C) Westergaard method (D) Benkelman beam method

Last Answer : Answer: Option B

Which one of the following is not recommended as a method for a company to protect itself against sexual harassment charges? A. Develop a zero-tolerance policy on harassment and communicate it to employees. B. Retaliate swiftly against employees who bring forth charges of harassment. C. Give swift and sure punishment to harassers. D. Train managers at all levels on sexual harassment issues.

Description : Which one of the following is not recommended as a method for a company to protect itself against sexual harassment charges? A. Develop a zero-tolerance policy on harassment and communicate it to ... and sure punishment to harassers. D. Train managers at all levels on sexual harassment issues.

Last Answer : B. Retaliate swiftly against employees who bring forth charges of harassment.

Can you make collection of Statistics for tables automatically?

Description : Can you make collection of Statistics for tables automatically?

Last Answer : YES. Oracle databse has default, scheduled job "gather_stats_job" that analyses stats on a daily basis during the maintenance window time. There are two scheduled activities related to ... GATHER_STATS_JOB'); Oracle collects optimizer statistics for SQL via the default of autostats_target = auto.

Can you make a Datafile auto extendible? If yes how?

Description : Can you make a Datafile auto extendible? If yes how?

Last Answer : YES. A Datafile can be auto extendible. Here's how to enable auto extend on a Datafile: SQL>alter database datafile '/u01/app/oracle/product/10.2.0/oradata/DBSID/EXAMPLE01.DBF' autoextend on; ... 'alter database datafile '|| file_name|| ' '|| ' autoextend on;' from dba_data_files; SQL>@runts

What does "jumps off the screen" mean?

Description : What does "jumps off the screen" mean?

Last Answer : answer:AMD is a relatively small manufacturer but well established in the industry. In this context, AMD jumps off the screen at the guy doing the research into acquiring companies for ... chip manufacturing division, but AMD is the one that really stands out from an acquisition perspective.

How to add conditions in select statement in oracle?

Description : How to add conditions in select statement in oracle?

Last Answer : Just add the decode

How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Description : How can I dump an oracle schema to a LOCAL file over a network connection from sqlplus?

Last Answer : By connecting and spooling are you excluding the exp/imp commands (or expdb/impdb in 10g)?

What are the two ways to incorporate images into a oracle forms application?

Description : What are the two ways to incorporate images into a oracle forms application?

Last Answer : Boilerplate Images Image_items

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

What are the types of visual attribute settings?

Description : What are the types of visual attribute settings?

Last Answer : Custom Visual attributes Default visual attributes Named Visual attributes. Window

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