Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

gDBClone snap not working for DBs with more than 30 datafiles

GUGGIFeb 22 2016 — edited Feb 22 2016

Not sure how popular gdbclone script has been. Lately I have tried to play with it and seem to find an issue with "gdbclone snap" part. I can use "gDBClone clone" to successfully create clones. But "gDBClone snap" has worked only if the number of datafiles in the master database is less than 30. I have tried this and I can create the snap clone successfully. But when I try to create the snapshot for a db with 30+ data files, the controlfile creation fails with ->

ORA-00059: maximum number of DB_FILES exceeded .

U can see this errror only if u run the script in debug mode. Without debug mode, the screen output seems to convey a wrong message.

Back to the issue, if I manually edit the control file creation script by adding the maxdatafiles parameter, it works and then I am able to run the next few scripts manually and the "SNAP" db is successfully created.

Has anyone encountered this issue with gdbclone ? Any thoughts ?


AU

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 21 2016
Added on Feb 22 2016
5 comments
460 views