change database id of database

SQL script to change database id of database.

shutdown immediate
startup mount
host nid target=/
disconnect
connect / as sysdba
startup mount
alter database open resetlogs;

Leave a Reply

Your email address will not be published. Required fields are marked *