Will RMAN takes backups of read-only tablespaces?

Will RMAN takes backups of read-only tablespaces?
by

1 Answer

Answer :

No
by

Related questions

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 resize tablespaces and data files? (for DBA)

Description : Can one resize tablespaces and data files? (for DBA)

Last Answer : One can manually increase or decrease the size of a datafile from Oracle 7.2 using the command. ALTER DATABASE DATAFILE 'filename2' RESIZE 100M; Because you can change the ... UNLIMITED DEFAULT STORAGE (INITIAL 10240 NEXT 10240 MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0) ONLINE PERMANENT;

List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.

Can objects of the same Schema reside in different tablespaces.?

Description : Can objects of the same Schema reside in different tablespaces.?

Last Answer : Yes.

Can objects of the same schema reside in different tablespaces?

Description : Can objects of the same schema reside in different tablespaces?

Last Answer : Yes.

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

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.

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

Can objects of the same Schema reside in different tablespaces? –

Description : Can objects of the same Schema reside in different tablespaces? –

Last Answer : Yes.

System.effective_date system variable is read only True/False?

Description : System.effective_date system variable is read only True/False?

Last Answer : False

What is Read-Only Transaction ?

Description : What is Read-Only Transaction ?

Last Answer : A Read-Only transaction ensures that the results of each query executed in the transaction are consistant with respect to the same point in time.

Which part of the RDBMS takes care of the data dictionary?

Description : Which part of the RDBMS takes care of the data dictionary?

Last Answer : Data dictionary is a set of tables and database objects that is stored in a special area of the database and maintained exclusively by the kernel.

Which parameter can be used to set read level consistency across multiple queries?

Description : Which parameter can be used to set read level consistency across multiple queries?

Last Answer : Read only

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

Will a user be able to modify a table with SELECT only privilege?

Description : Will a user be able to modify a table with SELECT only privilege?

Last Answer : He won’t be able to UPDATE/INSERT into that table, but for some reason, he will still be able to lock a certain table.

Read the following four statements, (i), (ii), (iii) and (iv) and select the right option having both correct statements. Statements : (i) Z scheme of light reaction takes place in presence of PSI only. (ii) Only PSI is functional in cyclic photophosphorylation. (iii)Cyclic photophosphorylation results into synthesis of ATP and NADPH2. (iv) Stroma lamellae lack PSII as well as NADP. (a) (ii) and (iv) (b) (i) and (ii) (c) (ii) and (iii) (d) (iii) and (iv)

Description : Read the following four statements, (i), (ii), (iii) and (iv) and select the right option having both correct statements. Statements : (i) Z scheme of light reaction takes place in presence of PSI only. (ii) Only PSI is ... and (iv) (b) (i) and (ii) (c) (ii) and (iii) (d) (iii) and (iv)

Last Answer : (a) (ii) and (iv)

Why is the headline of a print advertisement such a critical component of the copy? A)It determines the final layout design. B)It is often the only part of the advertisement that is read. C)It takes up the most space. D)It links the copy to the signature. E)It links the artwork to the signature.

Description : Why is the headline of a print advertisement such a critical component of the copy? A)It determines the final layout design. B)It is often the only part of the advertisement that is read. C)It takes up the most space. D)It links the copy to the signature. E)It links the artwork to the signature.

Last Answer : B)It is often the only part of the advertisement that is read.

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

what is a display item?

Description : what is a display item?

Last Answer : Display items are similar to text items but store only fetched or assigned values. Operators cannot navigate to a display item or edit the value it contains.

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.

Are there any troubleshooting tips for OEM? (for DBA

Description : Are there any troubleshooting tips for OEM? (for DBA

Last Answer : . Create the OEM repository with a user (which will manage the OEM) and store it in a tablespace that does not share any data with other database users. It is a bad practice to create ... successfully. Check the log to see the results of the execution rather than relying on this status.