Home » RDBMS Server » Backup & Recovery » Do I need to re-start to cloning process (11g.r2 Oracle Database)
Do I need to re-start to cloning process [message #640191] Thu, 23 July 2015 08:44 Go to next message
dcsmayei
Messages: 1
Registered: July 2015
Location: South Africa
Junior Member
Hi,

I am refreshing (cloning) a Test database with the Production database using RMAN with the following main script:
rman target sys/manager@ukznint auxiliary sys/manager@compi03 log=refresh.log << EOF
run {
duplicate target database to "compi03" from active database
DB_FILE_NAME_CONVERT '/data/ukznint','/mount/vol-01/data/compi03'
logfile group 1 ('/mount/vol-01/data/compi03/redo01.log') size 500M,
group 2 ('/mount/vol-01/data/compi03/redo02.log') size 500M,
group 3 ('/mount/vol-01/data/compi03/redo03.log') size 500M;
}
EOF

This is a 11 hour job to complete creating a refreshed test database on a different server from prod. However, I had to urgently extend the Prod database by adding another datafile to the 'data' tablespace. This seems to have stopped the cloning process, hanging on the new datafile I just added. Do I need to re-start the above script or is there a method/way/script to run so that the RMAN script above can continue creating the Test database?

All suggestions welcomed as this an urgent call for help.

Kind Regards
Ahmed
Re: Do I need to re-start to cloning process [message #640194 is a reply to message #640191] Thu, 23 July 2015 08:54 Go to previous messageGo to next message
BlackSwan
Messages: 25858
Registered: January 2009
Location: SoCal
Senior Member
>All suggestions welcomed as this an urgent call for help.

why is it urgent for us to solve this problem for you?

The sooner you restart this job, the sooner it will be finished.
Re: Do I need to re-start to cloning process [message #640200 is a reply to message #640191] Thu, 23 July 2015 09:33 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
If memory serves me correctly, add the datafile to the clone. As long as it has the same path I believe RMAN will continue. However, I may be wrong as I haven't cloned a database for a couple of years.
icon10.gif  Re: Do I need to re-start to cloning process [message #640241 is a reply to message #640191] Fri, 24 July 2015 10:55 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member

1) Stop the cloning if it's "hung"
2) Add channels to do cloning in parallel
3) Start cloning process, it will skip already copied files.
Good luck!
Cool
Re: Do I need to re-start to cloning process [message #640764 is a reply to message #640241] Tue, 04 August 2015 20:08 Go to previous message
OCNoles
Messages: 1
Registered: August 2015
Location: Orlando
Junior Member

Thanks for information.
Previous Topic: restore win oracle 10.2 cold backup to different drive
Next Topic: Unable to take backup
Goto Forum:
  


Current Time: Fri Feb 23 19:22:17 CST 2018

Total time taken to generate the page: 0.08348 seconds