2015-08-05 05:20 PM - edited 2015-08-05 06:05 PM
We wantora_infoednonprd_bkp ed to create a copy of a Prod Oracle database, and use the copy for reports. The following is my question:
1. Could it be achived by using SM for Oracle, and eseential it is using Flexclone. Correct?
2. Without SM for Oracle, can I only use Flexclone to do that? If yes, how? and how to resolve the consisitency issue beween logs and datafiles?
Thank you very much for your inputs.
2015-08-06 03:26 AM
You are correct, If you need to have a application consistent copy of the database you need to create a clone from SMO.
Normal flexclone will not be application consistent.
2015-08-06 03:53 AM - edited 2015-08-06 03:55 AM
what if I put Orace DB in Hot backup mode or stop writting to DB before flexclone all related Oracle volumes together? Are there any workaround by using flexclone instead of SMO
2015-08-07 01:27 AM
you may be able to do a app consistent using RMAN, but we strongly recommend to use SMO for application consistent clone.
As I mentioned before, direct flexclone will not be app consistent.
2015-08-08 05:51 AM
In hot backup mode, then do flexclone to all DB volumes involved, will that cause inconsistency as well?
Could you please tell me a little bit of more on using RMAN to keep the consistency, how?
2015-08-14 04:09 AM
Please share your experience to ensure Oracle database consistency when using Flexclone to clone DB.
for instance, what steps to take to use RMAN to keep DB consistency?