Skip to Main Content

Enterprise Manager

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.

cloud control db cloning issue

User_FGNCEApr 26 2018

em12c - 12.1.0.5

database - 11.2.0.4

So I am trying to clone a database thru cloud control using a full rman backup.  During the restore the database from rman backup step I receive the following error identified below.  Basically I get ora-00059: maximum number of DB_FILES exceeded.  It gets this parameter from a temporary init.ora file that the cloning process creates.  In the init.ora file it shows db_files=84.  The source database has this defined as db_files=1000.  Where does this come from?  And how can I change it?

contents of Memory Script:

{

   sql clone "alter system set  db_name =

''BORXESAM'' comment=

''Reset to original value by RMAN'' scope=spfile";

   sql clone "alter system reset  db_unique_name scope=spfile";

   shutdown clone immediate;

}

executing Memory Script

sql statement: alter system set  db_name =  ''BORXESAM'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 04/26/2018 08:37:42

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-06136: ORACLE error from auxiliary database: ORA-00059: maximum number of DB_FILES exceeded

Comments

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

Post Details

Locked on May 24 2018
Added on Apr 26 2018
0 comments
356 views