Skip to content

Instantly share code, notes, and snippets.

@freddenis

freddenis/rename_a_dg_8

Created July 15, 2016 05:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save freddenis/28393bb811878e2c397a10f5a4e811f1 to your computer and use it in GitHub Desktop.
Save freddenis/28393bb811878e2c397a10f5a4e811f1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
rename_a_dg_8
myclusterdb01:oracle \) sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sun May 1 18:10:03 2016
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ----------------------------------------------------------------
spfile string +DATAC1/mycluster/ASMPARAMETERFILE/registry.253.909092147
SQL> select instance_name from v$instance ;
INSTANCE_NAME
----------------
+ASM1
SQL> create pfile='/tmp/ASMpfile.ora' from spfile ;
File created.
SQL> create spfile='+RECO' from pfile='/tmp/ASMpfile.ora' ;
File created.
SQL>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment