Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
oracle_rename_db [2022/05/11 10:00] – [Using NID] andonovj | oracle_rename_db [2022/05/11 10:01] (current) – andonovj | ||
---|---|---|---|
Line 73: | Line 73: | ||
[oracle@temporaback admin]$ | [oracle@temporaback admin]$ | ||
+ | </ | ||
+ | |||
+ | |||
+ | Then we can change the pfile and startup the DB with reset logs: | ||
+ | |||
+ | |||
+ | < | ||
+ | [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. | ||
+ | |||
+ | 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 | ||
+ | Database Buffers | ||
+ | Redo Buffers | ||
+ | Database mounted. | ||
+ | SQL> alter database open resetlogs; | ||
+ | |||
+ | Database altered. | ||
+ | |||
+ | SQL> | ||
+ | |||
</ | </ |