Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

Duplicate a Database Using RMAN - Use RMAN to create a duplicate, or clone, of a database from a recent backup.



Devadathan said...

Great stuff.. one more thing to dadd we need to disconnect from the SQL*plus after doing the "STARTUP FORCE NOMOUNT;" otherwise the RMAN session will wait after the media recovery to shutdown the database

printing stored script: Memory Script
{
shutdown clone;
startup clone nomount ;
}
executing script: Memory Script

Thanks

Dev

Ming Mendonca said...

We also need single or double quotes on the file names (at least that's what required on the Win2k platform):

DB_FILE_NAME_CONVERT=('/u02/oradata/TSH1/','/u02/oradata/DUP/')
LOG_FILE_NAME_CONVERT=("/u01/oradata/TSH1/","/u01/oradata/DUP/")
Great stuff. thanks

ming

Bryan said...

Hi Tim,

Thank you very much for your articles. It would be great if you could add some contents about how to create a duplicate database on a remote server.

Thank you,
Bryan

ravinder said...

It was of great help, but I was not able to figure out the last step i.e duplicate target database to dup(in my case the database's name is clone).I am getting the following error
RMAN-00571
RMAN-00569 ERROR MESSAGE STACK FOLLOWS
RMAN-00571
RMAN-00558:error encountered while parsing input commands
RMAN-01009: syntax error:found "clone":expecting one of "double-quoted-string,identifier,single-quoted-string"
RMAN-01007:at line 1 column 30 file:standard input

Can anyone help me out in this please

clyde said...

Hi!
I'm duplicating a database but after issuing DUPLICATE TARGET DATABASE TO DUP; rman replies with error RMAN-20208: UNTIL CHANGE is before RESETLOGS change.

what's wrong? How to figure correct time or scn for duplication?

ukrtelecom_oraadmin said...

Hi!
Work on Windows with Oracle 10g.
Thank's a lot!

Umair Mansoob said...

Timm i think there is small error in your duplicate target database to dup. iu think dup should be in quotation. "DUP"

Guy said...

Hi!,

oracle 9.2.0.7.0

Thanks this was an excellent description, we had a major issue where we had to duplicate a prob Db due to records being changed and asap... we mounted a new disk and ran according to script and all worked well. Only bug I found was that we had to connect to rman target, catalog and aux separately than it worked.
Thanks again.
Cheers

Andreas Lund said...

Brilliant article, I'm an Oracle newbie but I was able to do this both in Linux and Windows thanks to your clear and to-the-point instructions.

Michael said...

Typo, a remote server will
Do I only specify the path for LOG_FILE_NAME_CONVERT and not the filename even though I have three log files in a folder? Also, do the filenames have to be the same for both destinations?

Tim... said...

Hi.

This is to tell the DUPLICATE command where to find/place the datafiles and the archived redo logs. You should set both so they are placed in the correct location. Please ask any further question in the forum.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired