| Do I need to re-start to cloning process [message #640191] |
Thu, 23 July 2015 08:44  |
 |
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 #640200 is a reply to message #640191] |
Thu, 23 July 2015 09:33  |
gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, 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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
