My Oracle Support Banner

How to rename an Oracle 9.2 database on Alpha OpenVMS (Doc ID 405788.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.1 [Release 9.2]
HP OpenVMS Alpha
Digital Alpha OpenVMS
NOTE: In the images and/or the document content below, the user information, the object name information, the database name information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.



Purpose

Checked for relevance on 29-JUL-2011.
 
The purpose of this note is to provide instructions for renaming a non-production database. The information in this note has been tested against a default 9.2 database.

Scope

This information is intended to help you rename non production databases. This note is not intended for cloning a database. This method is designed to use the least amount of disk space while performing the rename. DBCA is not used, nor is export or import
used as part of the renaming process.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Introduction
 Structure Overview Before Rename
 Structure Overview After Rename
 Step 1. Prepare, but do not run, a sql script to recreate the controlfiles.
 Step 2. Backup the database and software(Oracle home).
 Step 3. Rename files to the new names using OpenVMS commands.
 Step 4. Recreate the control files and open the database using the new dbname and new sid.
 Step 5. Complete post rename steps.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.