Differences

This shows you the differences between two versions of the page.

--- oracle_rename_db [2022/05/11 10:00] – created andonovj
+++ oracle_rename_db [2022/05/11 10:01] (current) – andonovj
@@ Line 43: / Line 43: @@
     /app/data/fast_recovery_area/orcltest/control02.ctl
-Change database ID and database name ORCLPROD to ORCLBACK? (Y/[N]) => Y
+Change database ID and database name OLDNAME to NEWNAME? (Y/[N]) => Y
 Proceeding with operation
@@ Line 73: / Line 73: @@
 [oracle@temporaback admin]$
+</Code>
+Then we can change the pfile and startup the DB with reset logs:
+<Code:bash|Startup the DB (After changing the init file>
+[oracle@temporaback dbs]$ vi initorclback.ora
+[oracle@temporaback dbs]$ sqlplus
+SQL*Plus: Release 12.2.0.1.0 Production on Wed May 11 11:46:45 2022
+Copyright (c) 1982, 2016, Oracle.  All rights reserved.
+Enter user-name: / as sysdba
+Connected to an idle instance.
+SQL> startup mount;
+ORACLE instance started.
+Total System Global Area 3724541952 bytes
+Fixed Size                  8627296 bytes
+Variable Size             872418208 bytes
+Database Buffers         2835349504 bytes
+Redo Buffers                8146944 bytes
+Database mounted.
+SQL> alter database open resetlogs;
+Database altered.
+SQL>
 </Code>