Home » RDBMS Server » Server Administration » is it possible to move the datafiles from non CDB architecture to CDB architecture not just copy as (11.2.0.4 Windows 2012)
is it possible to move the datafiles from non CDB architecture to CDB architecture not just copy as [message #677409] Tue, 17 September 2019 18:18 Go to next message
juniordbanewbie
Messages: 239
Registered: April 2014
Senior Member
Dear all,

I need to migrate from 11.2.0.4 to 19c CDB?

here's my rough plan.

Run 19c preupgrade on existing 11.2.0.4 database
take rman backup on existing 11.2.0.4 database

install 19c binaries on windows 2016
restore 11.2.0.4 database rman backup

on actual migration day

backup archivelog in 11.2.0.4 database
restore archivelog backup in 19c database
open resetlogs upgrade in 19c database

Then create a CDB on the windows 2016 server
migrate the newly upgrade 19c database to the newly created CDB.

Of course this means that the new server 2016 will need to have double the space

is it possible to move the datafiles from non CDB architecture to CDB architecture not just copy as it is done during the non CDB to CDB conversion?

many thanks in advance!
Re: is it possible to move the datafiles from non CDB architecture to CDB architecture not just copy as [message #677414 is a reply to message #677409] Wed, 18 September 2019 01:32 Go to previous messageGo to next message
John Watson
Messages: 8086
Registered: January 2010
Location: Global Village
Senior Member
You do not seem to be following ANY of the possible upgrade methods. In fact, nowhere in your method do you actually upgrade. What document are you following?
Re: is it possible to move the datafiles from non CDB architecture to CDB architecture not just copy as [message #677419 is a reply to message #677414] Wed, 18 September 2019 04:25 Go to previous message
juniordbanewbie
Messages: 239
Registered: April 2014
Senior Member
Dear John,

with reference to https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=362188177247675&id=369644.1&displayIndex=4&_afrWindowMode =0&_adf.ctrl-state=qfy6to793_172#aref_section21

Frequently Asked Questions about Restoring Or Duplicating Between Different Versions And Platforms (Doc ID 369644.1)

Quote:


1) Can I restore or duplicate my previous version database using a later version of Oracle?
RMAN can restore a backup taken on an older database release into a newer release. The older backups must be taken on 9.2 or later release.


1. Install 11.2 binaries and latest patch sets on new host and prepare the 11.2 Oracle home per following Documentation - Database Upgrade Guide

2. Allow disk and/or tape backups to be accessible from the new host.

3. Restore backups to the 11.2 database and recover the database to a consistent point-in-time per this doc.

Database Backup and Recovery User's Guide
20 Performing RMAN Recovery: Advanced Scenarios
... Restoring a Database on a New Host'


Do not open the database at this time.

4. Manually upgrade the 10.2 database to 11.2 per the instructions in this documentation
On the actual day of migration or update,

I have to purge the recyclebbin

close the database

mount the database

take the last archivelog backup on the old database which is located in windows 2012

on the new machine windows 2016 where I installed 19c

Before I open the database I restore and recover the latest set of 11.2.0,4 archivelog backup

with reference to https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ALTER-DATABASE.html#GUID-8069872F-E680-4511-ADD8-A4E30AF67986


Quote:


ALTER DATABASE OPEN RESETLOGS UPGRADE;
next step will be to upgrade

next step will be to convert non cdb to cdb

looks like your country man Tim Hall already have this procedure

https://oracle-base.com/articles/19c/upgrading-to-19c#perform-preupgrade-actions

From oracle-base I realize that even from 12c1 ,we already can have the option of creating pluggable database with the move option

https://docs.oracle.com/database/121/SQLRF/statements_6010.htm#CCHEJDJD

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-PLUGGABLE-DATABASE.html#GUID-F2DBA8DD-EEA8-4BB7-A07F-78DC0 4DB1FFC


many thanks!
Previous Topic: ORA-00851: SGA_MAX_SIZE 1073741824 cannot be set to more than MEMORY_TARGET 738197504
Next Topic: how are the bits in ASSM calculated?
Goto Forum:
  


Current Time: Mon Dec 16 04:01:45 CST 2019