This content has been marked as final. Show 2 replies
788420 wrote:if you're talking about copy one dbf file backup from one database and restore in it another database than its simply not possible .
My leader tell me that he can copy backed up file (incremental backed up file) from one database (orcl) to another database (orcl2) and restore it to another database then it work well. But he don't explain detail how to do it. About me that i don't think it is possible to do that. I want to ask you is it possible?
Thank in advance!
P/s: Sorry for my bad English.
however you can use Transporting Tablespaces Between Databases.
This technique is used to copy a set of tablespaces from one Oracle Database to another
copy backed up file (incremental backed up file) from one database (orcl) to another database (orcl2) and restore it to another databaseNo. not possible. A datafile "belongs" to a database that is identified by the DBID and DB_NAME in the file header.
An Incremental Backup as a BackupSet cannot be applied to another database as the corresponding Level0 backup wouldn't match.
Transportable Tablespaces is a method to "copy" a Tablespace (which may be a single datafile or multiple datafiles) to another database. But that does not and cannot use "incremental backups". It has to be a physical copy (not backup) of the datafile(s).
Hemant K Chitale