Do you want to infuse collaborative and unified access to database? Are you in having trouble in managing on-premise storage? Do you wish to reduce spending on technology infrastructure? If the answer to any of the questions is yes, then Oracle database update is a must-to-do thing for your enterprise.
Vast Edge offers one of the most sophisticated and secures database migration and update. Vast Edge is a ''Global Gold Partner'' of Oracle and has been mentioned in Forbes for migrating enterprises to the cloud. Here is how Vast Edge performs the upgrade:
Our experts install the software in a separate home directory while creating a pfile from spfile. The specialists at Vast Edge runs a pre-upgrade tool to check the pre-requisites before running the actual upgrade so that no setback occurs in the later stages of the upgrade. On top of that, we create a restore point in case of any crisis. Further, to avoid any kind of disaster Vast Edge also creates a Guaranteed Restore Point.
Restore Oracle 220.127.116.11 Database to Oracle 18.104.22.168 Database and then Upgrade.
Step 1: Create pfile according to your environment.
Step 2: Start database in no mount state.
SQL> startup nomount pfile='Location of parameter file';
Step 3: Restore the Control Files
Connect with RMAN and restore control file from backup.
RMAN> restore controlfile from 'location';
Step 4: Mount the database and catalog the backup pieces from new location
RMAN> alter database mount;
RMAN> catalog start with 'location of backup';
RMAN> Report schema;
Step 5: Generate the SET NEWNAME FOR DATAFILE command.
For example: - SET NEWNAME FOR DATAFILE 1 TO 'LOCATION OF DATAFILE TO BE RESTORED';
Step 6: Restore the database
ALLOCATE CHANNEL c1 device type disk; -----------------------? Allocate multiple channels
SET NEWNAME FOR DATAFILE 1 TO '/u01/oracle/oradata/prod/system.dbf';
SET NEWNAME FOR DATAFILE 2 TO '/u01/oracle/oradata/prod/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 3 TO '/u01/oracle/oradata/prod/sysaux.dbf';
SET NEWNAME FOR DATAFILE 4 TO '/u01/oracle/oradata/prod/users.dbf';
switch datafile all;
release channel c1;}
Step 7: Start the recover based the scn you got.
rman> recover database until scn 23207925635;
Step 8: Connect through sqlplus and change the location of redo logs.
SQL>Alter database rename file 'old location' TO 'new location';
Step 9: Shutdown database;
edit undo PARAMETER
alter database open reset log upgrade;
Step 10.1: Create undo tablespace undotbs datafile '+DATAC1/undotbs.dbf' size 5G
AUTOEXTEND ON NEXT 5m MAXSIZE 31G;
CREATE TEMPORARY TABLESPACE TEMP_NEW TEMPFILE '+DATAC1/tempnew_01.dbf' SIZE 5g autoextend on next 10m maxsize unlimited;
ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;
DROP TABLESPACE TEMP including contents and datafiles;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP_NEW;
Step 10.2: Shutdown immediate;
Edit pfile and make changes to parameterUNDO_MANAGEMENT='AUTO'
Step 11: START Database
Alter database open upgrade;
SQL> select name,open_mode,log_mode,flashback_on,switchover_status from v$database; STEPS TO UPGRADE DATABASE
Step 12: Need to run precheck script before upgrade and fix the issues.
Step 13: Run the ungrade script. (refer upgrade.log)
Step 14: To check the upgrade (refer check_upgrade.log)
Step 15: Need to run below script and database no need to be in upgrade mode.
Step 16: To recompile all the invalid objects after upgrade.
SQL> @$ORACLE_HOME/RDBMS/ADMIN/utlrp.sql Check Database Components:
col action_time for a30
col BUNDLE_SERIES for a15
col NAMESPACE for a10
col comments for a30
select * from dba_registry_history;
col comp_id for a10
col comp_name for a40
col version for a12
col status for a12
select comp_id, comp_name, version, status from dba_registry;
About Vast Edge - Simplified Cloud Solutions
Founded in the year 2004, Vast Edge is a leading IT Consulting Company and Global Service provider of Business Intelligence, big data analytics, cloud ERP, IoT platform, enterprise backup, and disaster recovery, Blockchain, Cassandra, AI/ML, and Integration solutions. We perform Application modernization, follow continuous change management, and implement advanced practices while working on the key areas of enhancing methodologies of project development.
Get a Free Assessment from our cloud experts.