Restore database to a different location using Brtools

[Former Member]

Hello together

We want to copy a System from a physical to a virtual Server. Unfortunately both platforms uses a different backup infrastructure. So we cannot direct restore the database from the physical system to the virtual system.

Now we attached a disk to the physical system. It is a windows system so we called the drive z:\. Now the plan was to restore the complete database to this additional drive and the copy the database to the virtual system and rename it.

The problem now is that Brtools want to stop the source system for the restore to the different location. Is there a possibility to restore the complete database to this additional drive without stopping the database on the system?

Thank for any help.

Regards

Simon

[Former Member]

rman duplicate is a great suggestion and works wonderfully, if you are used to rman (not that difficult)

If you do want to use brtools though,you can use the -m switch with brrestore to specify the new filesystem or drive e.g. brrestore —m all E:=F: K:=L:

See the docu for more http://help.sap.com/saphelp_nw73/helpdata/en/47/3075b666c73422e10000000a1553f6/frameset.htm

Or you can use the new_db_home/stage_db_home parameters of br*tools

http://help.sap.com/saphelp_nw73/helpdata/en/47/0b717c5aea5bebe10000000a1553f7/frameset.htm

[stefan_koehler]

Hi Simon,

why not using the "active duplication" option as the platform seems to be the same. No backup is needed in this case, the restore / duplication is performed from the running database.

http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDJGCFC

The example is about the same directory structure, but it also works for different file system layouts (check the second example below).

Regards

Stefan