Database Reference
In-Depth Information
Before you can try to plug in the database you need to shut it down safely. Following along the command to add
the migrated database to the CDB is shown here:
SQL> create pluggable database ora11 as clone
2 using '/u01/app/oracle/admin/ora11/pdb/ora11.xml'
3 nocopy tempfile reuse;
Pluggable database created.
The operation is logged quite verbose in the alert.log as well:
2013-08-14 19:44:34.887000 +01:00
create pluggable database ora11
using '/u01/app/oracle/admin/ora11/pdb/ora11.xml'
nocopy tempfile reuse
****************************************************************
Pluggable Database ORA11 with pdb id - 4 is created as UNUSABLE.
If any errors are encountered before the pdb is marked as NEW,
then the pdb must be dropped
****************************************************************
Deleting old file#1 from file$
Deleting old file#2 from file$
Deleting old file#3 from file$
Deleting old file#4 from file$
Adding new file#13 to file$(old file#1)
Adding new file#14 to file$(old file#2)
Adding new file#15 to file$(old file#4)
Marking tablespace #2 invalid since it is not present in the describe file
2013-08-14 19:44:35.958000 +01:00
Successfully created internal service ora11 at open
ALTER SYSTEM: Flushing buffer cache inst=0 container=4 local
****************************************************************
Post plug operations are now complete.
Pluggable database ORA11 with pdb id - 4 is now marked as NEW.
****************************************************************
Completed: create pluggable database ora11
using '/u01/app/oracle/admin/ora11/pdb/ora11.xml'
nocopy tempfile reuse
Please resist the temptation to open the PDB straight away! Remember from the plug in violations view that you
must run the noncdp_to_pdb script fist! This is done by switching to the new PDB and executing the script:
SQL> alter session set container = 'ORA11';
Session altered
SQL> @?/rdbms/admin/noncdb_to_pdb
After the script has completed it is safe to use the PDB as any other PDB in the Container Database.
Search WWH ::
Custom Search