News

  1. Home
  2. All posts
All posts, Oracle by Team Ajara

Create Oracle service after DB restore to new server

 

Oracle Service creation after DB restore.

Restore activity can be from Disk backup or tape backup or flash copy (with OS commands),but the service creation and configuration is same for the below two Cases.

 

For example ,we have restored  the backup of  database to different server for the following reasons.

  • For backup verification, for example quarterly or half yearly restore activities purpose or for DR purpose.
  • To restore some missed/deleted/dropped tables and copying them to original database on source.
  • For Performance test purpose on different server.

 

Assuming the DB restore completed and service configuration is pending.

Case 1:

In this case, source DB and target DB name and service name is same.

 

Syntax:

To add service:

srvctl add service -s <service name> -db < DB unique name>  -pdb <pdb name>

To start service:

srvctl  start service -s <service name> -db <DB unique name>

To check status of service:

srvctl status  service -s <service name> -db <DB unique name>

 

  • DB: ORCLP
  • Database Unique Name: UORCLP
  • Pluggable Database Name: PDBORCLP

 

 

#Service configuration

$srvctl add service -s ORCLP.AJARA.COM -db UORCLP -pdb PDBORCLP

$srvctl start service -s ORCLP.AJARA.COM -db UORCLP

$srvctl status service -s ORCLP.AJARA.COM -db UORCLP

 

Case 2:

In this case, source DB and target DB name and service names are different.

 

  • Source DB: ORCLP
  • Source DB Unique Name: UORCLP
  • Source Pluggable DB Name: PDBORCLP
  • Target DB: ORCLT
  • Target DB Unique Name: UORCLT
  • Target Pluggable DB Name: PDBORCLT

 

$vi rename_pdb.sql

connect / as sysdba
spool $ORACLE_HOME/rename_pdb.log
shutdown immediate;
startup pfile=’$ORACLE_HOME/dbs/initORCLT.ora’;
alter database rename GLOBAL_NAME to ORCLT.AJARA.COM;
alter pluggable database PDBORCLP close immediate;
alter pluggable database PDBORCLP open read write restricted;
alter pluggable database PDBORCLP rename global_name to PDBORCLT;
show pdbs
alter database rename GLOBAL_NAME to PDBORCLT.AJARA.COM;
alter pluggable database PDBORCLT close immediate;
alter pluggable database PDBORCLT open read write;
alter system register;
spool off
quit

SQL> @rename_pdb.sql

SQL> exit

 

#Service creation

$srvctl add service -s ORCLPTAJARA.COM -db UORCLT -pdb PDBORCLT

$srvctl start service -s ORCLT.AJARA.COM -db UORCLT

$srvctl status service -s ORCLT.AJARA.COM -db UORCLT

 

See also: