I'm looking for a cloning for dummies... because it's kicking my butt.
I've tried to use the following:
Create Full Clone
Create CloneDB
Clone Management
I've had zero success with any of them. This is what I have:
VMWare guest, running Redhat 5
11.2.0.3.15 db
datafiles, redo logs, control files, archive logs are on file system, (SAN mounted as a local file system)
has not mattered what size db, (35GB - 800GB)
I want to clone to an instance in the cloud.
In the cloud,
Oracle Linux 7 server instance.
cloning to 11.2.0.3.15 db home
datafiles, redo logs, control files, archive logs will be on ASM. (+DATA1 and +FRA01)
OEM cloning fails at various places, it has not been consistent where it fails nor has it been helpful in always telling me why it failed.
The only OEM clone option that's allowed me to change where the datafiles end up, (on ASM) has been Clone Management using the Classic Clone view.
CloneDB appears to want image backups and does not give me a Now option.
Full Clone, when you tell it the destination is ASM, checks the source ASM... (there is no source ASM disks).
The Classic Clone View allows the source to be file system based, destination is ASM based, but once it gets to some point, the clone steps fail. Sometimes it can't stop the clone, can't start the clone, the list goes on... Really, there seems to be no one step that always fails.
I've tried to also do the following:
rman
connect target /
connect catalog "rman/password@rman1"
connect auxiliary "sys/password@cloud1"
run {
set newname for datafile 1 to '+DATA1/cloud1/system01.dbf';
set newname for datafile 2 to '+DATA1/cloud1/sysaux01.dbf';
set newname for datafile 3 to '+DATA1/cloud1/undotbs01.dbf';
set newname for datafile 4 to '+DATA1/cloud1/users01.dbf';
set newname for datafile 5 to '+DATA1/cloud1/progprd5_data01.dbf';
set newname for datafile 6 to '+DATA1/cloud1/system02.dbf';
set newname for datafile 7 to '+DATA1/cloud1/progprd5_data02.dbf';
set newname for datafile 11 to '+DATA1/cloud1/statpack01.dbf';
duplicate target database to cloud1
pfile=/oracle/product/11.2.0/db/dbs/initcloud1.ora
logfile
'+FRA01/cloud1/redo01.log' size 500m,
'+FRA01/cloud1/redo02.log' size 500m,
'+FRA01/cloud1/redo03.log' size 500m,
'+FRA01/cloud1/redo04.log' size 500m,
'+FRA01/cloud1/redo05.log' size 500m;
}
This almost worked, but the listener blocks a db in a nomount state, so you can't connect remotely, you can't mount without controlfiles... I feel like an infinite loop, or who's on 1st...
Any ideas?