Shulou(Shulou.com)06/01 Report--

In this article, we introduce other technologies of upgrade and migration.

Main steps for rman upgrade

1. In the source database 11.2, check the concurrent collection setting SQL > select dbms_stats.get_prefs ('CONCURRENT') from dual for obtaining statistical objects DBMS_STATS.GET_PREFS ('CONCURRENT')-FALSESQL >

If the concurrent collection setting unit 'FALSE', makes the following settings

Begindbms_stats.set_global_prefs ('CONCURRENT','FALSE'); end;/2, execute dbupgdiag.sql in the source database to collect diagnostic information

Cp dbupgdiag.sql $ORACLE_HOME/rdbms/admin

$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP Data Miningand Real Application Testing optionsSQL > @? / rdbms/admin/dbupgdiag.sqlEnter value for 1: / tmpSQL > @? / rdbms/admin/preupgrd.sqlResults of the checks are located at: / u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/preupgrade.logPre-Upgrade Fixup Script (run in source database environment): / u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/preupgrade_fixups.sqlPost-Upgrade Fixup Script (run shortly after upgrade): / u01/app/oracle/cfgtoollogs/CDBXF/preupgrade/postupgrade_fixups.sql3, perform rman backup in source database 11g Here we use compressed backup.

Bakcup_cdbxf.sh

#

Rman target / log=/rmanbak/cdbxf/cdbxf11gbak_20190629.log

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.