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!

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
382 views