Showing posts with label Rename the Database with and without NID. Show all posts
Showing posts with label Rename the Database with and without NID. Show all posts

Tuesday, April 25, 2017

Rename the Database with and without NID

Check the below parameters and values.

show parameter db_name-->spfile
or
select name from v$database;

alter database backup controlfile to trace as '/oradata/dbname/c1text.sql';
shut immediate
mv /oradata/dbname/control01.ctl /oradata/dbname/control01.ctl_old

mv /oradata/dbname/control02.ctl /oradata/dbname/control02.ctl_old

startup nomount
alter system set db_name='test' scope=spfile;

select name,value from v$spparameter where name='db_name';

cp -p /oradata/dbname/c1text.sql /oradata/dbname/c1text.sql_bkp

vi /oradata/dbname/c1text.sql

There will be 2 set of controlfile creation script in SQL file.
Delete colplete 1st set and change below  first line in backup controlfile sql.

reuse ==>set
olddb ==>newdb
noresetlogs==>resetlogs


SQL>@ /oradata/dbname/c1text.sql
.
SQL>alter database open RESETLOGS;

select file#,name from v$datafile;
select file#,name from v$tempfile;

you will get renamed database  while query to v$database.

Rename DB With NID 

select tablespace_name,status from dba_tablespaces;
*********************************************
shut immediate
startup mount
select name,open_mode,log_mode,dbid from v$database;
##nid target=/ DBNAME=NEWTEST
nid target=/ DBNAME=NEWTEST SETNAME=Y
startup nomount
alter system set db_name='NEWTEST' scope=spfile;
shut immediate
startup
*********************************************


Convert snapshot standby database to Physical standby database: Dataguard 11gR2

Step 1 SQL> shutdown immediate; Step 2 SQL> startup nomount Step 3 SQL> alter database mount; Step 4 SQL>  ALTER DATABASE CONV...