How do you understand this Oracle Documentation
Hi,
Could you please tell me how you understand the last sentence of the following paragraph. Please read it more than once and analyze the exacte meaning of each word:
Quote:
You can skip all tablespaces in the target database except the SYSTEM tablespace, undo tablespaces, and tablespaces containing rollback segments. RMAN does not check for completeness. For example, you can duplicate a data tablespace but not the tablespace containing the index for the data, or duplicate a tablespace that contains only one partition of a partitioned table.
The entire document can be found under:
http://download-west.oracle.com/docs...ta27.htm#81553
Re: How do you understand this Oracle Documentation
Quote:
Originally posted by mike9
Hi,
Could you please tell me how you understand the last sentence of the following paragraph. Please read it more than once and analyze the exacte meaning of each word:
The entire document can be found under:
http://download-west.oracle.com/docs...ta27.htm#81553
Everytime I have duplicated a database using rman, I have duplicated the whole database. In fact, I did not know you could use rman to duplicate part of a database. But it would make sense the the duplicated database must have a complete data dictionary. But it seems that you can duplicate a database without duplicated the indexes if they are in their own tablespace, or it seems that you can duplicates one or more partitions in a partitioned table if the ones skipped are in their own tablespaces.
So unless you are doing an incomplete duplication of a database, this section doesn't matter. IMHO, doing a complete duplication of a database from a backup should be a simple thing to do.
Re: Re: How do you understand this Oracle Documentation
Quote:
Originally posted by gandolf989
... So unless you are doing an incomplete duplication of a database, this section doesn't matter. IMHO, doing a complete duplication of a database from a backup should be a simple thing to do.
The problem is that our DWH DB has a size of 2.6 TB. To have accurate data on our integration DB we would like to duplicate only the tablespaces containing the most recent data.
How do you understand this Oracle Documentation
I understand it STANKS!
The problem is that Oracle has different people write different chapters in these docs and some have a better grip on the language then others.
Notwithstanding, there should be some type of audit in place for some consistency.
No speka di engleesh.
There is a lot to be said for keeping things simple, although some (and you know who you are) would disagree.