RE: Another 12c Question

From: Scott Canaan <srcdco_at_rit.edu>
Date: Wed, 22 Jul 2015 14:37:01 +0000
Message-id: <3653B77DCF6DDA4ABAD1E9416F1876D75287F611_at_ex03mail01.ad.rit.edu>

Ok, I’m trying to clone a container database using SQL. I used the following clone.sql:

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "DBAXTECT" RESETLOGS ARCHIVELOG     MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 1022
    MAXINSTANCES 8
    MAXLOGHISTORY 1200
LOGFILE

  GROUP 1 ('/oracle/data/DBAXTECT/redo01a.log',
           '/oracle/data/DBAXTECT/mirror_files/redo01b.log') size 50m,
  GROUP 2 ('/oracle/data/DBAXTECT/redo02a.log',
           '/oracle/data/DBAXTECT/mirror_files/redo02b.log') size 50m,
  GROUP 3 ('/oracle/data/DBAXTECT/redo03a.log',
           '/oracle/data/DBAXTECT/mirror_files/redo03b.log') size 50m,
  GROUP 4 ('/oracle/data/DBAXTECT/redo04a.log',
          '/oracle/data/DBAXTECT/mirror_files/redo04b.log') size 50m,
  GROUP 5 ('/oracle/data/DBAXTECT/redo05a.log',
           '/oracle/data/DBAXTECT/mirror_files/redo05b.log') size 50m

DATAFILE
'/oracle/data/DBAXTECT/sys01.dbf',
'/oracle/data/DBAXTECT/sysaux01.dbf',
'/oracle/data/DBAXTECT/undotbs01.dbf',
'/oracle/data/DBAXTECT/users01.dbf';

When I tried to add in mention of the seed, it didn’t like that.

Now, all the seed knows is the container’s undo tablespace. It doesn’t know anything about its own system, sysaux, and users tablespaces. How do I get it to recognize them?

Scott Canaan ’88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)

(585) 475-7886 – work                (585) 339-8659 – cell

“Life is like a sewer, what you get out of it depends on what you put into it.” – Tom Lehrer

From: Seth Miller [mailto:sethmiller.sm_at_gmail.com] Sent: Monday, July 20, 2015 1:09 PM
To: Scott Canaan
Cc: oracle-l_at_freelists.org
Subject: Re: Another 12c Question

Scott,

Not only is it possible but there are at least as many ways to do it in 12c as there are in 11g. Assuming you are using rman duplicate, the biggest difference you need to be aware of is that the auxiliary instance has to be started with the enable_pluggable_database=true init parameter before executing the duplicate command.

Seth Miller

On Mon, Jul 20, 2015 at 10:02 AM, Scott Canaan <srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>> wrote: Now that I have the Oracle 12c container database created, I need to know if there’s a way to clone it. I know that cloning the PDB is easy, but I want to clone the container. Can I do that the same way that I did the 11g (and lower) databases or are there some significant changes that need to be made? Or is it not possible at all?

Thank you,

Scott Canaan ’88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)

(585) 475-7886 – work                (585) 339-8659 – cell

“Life is like a sewer, what you get out of it depends on what you put into it.” – Tom Lehrer

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 22 2015 - 16:37:01 CEST