#Change dbname postico full
Output file name=+DATA/test/datafile/users.890.957896209 tag=TAG20171020T181638 RECID=12 STAMP=957896209Ĭhannel ORA_DISK_1: starting full datafile backup setĬhannel ORA_DISK_1: specifying datafile(s) in backup setĬhannel ORA_DISK_1: starting piece 1 at 20-OCT-17Ĭhannel ORA_DISK_1: finished piece 1 at 20-OCT-17 RMAN> BACKUP AS COPY DATABASE FORMAT '+DATA' Ĭhannel ORA_DISK_1: starting datafile copy Recovery Manager: Release 11.2.0.4.0 - Production on Fri Oct 20 18:15:29 2017Ĭonnected to target database: TEST (DBID=2256023237, not open) Total System Global Area 3.8215E+10 bytes SQL> create spfile='+DATA/ORCL/spfileTEST.ora' from pfile='/tmp/testpfile' *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)' *.audit_file_dest='/u01/app/oracle/admin/ORCL/adump'
SQL> create pfile='/tmp/testpfile' from spfile='+DATA/ORCL/spfileORCL.ora' Succesfully changed database name and ID.
#Change dbname postico password
Modify parameter file and generate a new password file before restarting.ĭatabase ID for database TEST changed to 2256023237.Īll previous backups and archived redo logs for this database are unusable.ĭatabase is not aware of previous backups and archived logs in Recovery Area.ĭatabase has been shutdown, open database with RESETLOGS option. +RECO/orcl/controlfile/current.49661.957891589Ĭhange database ID and database name ORCL to TEST? (Y/) => YĬhanging database ID from 1485672324 to 2256023237Ĭontrol File +DATA/orcl/controlfile/current.824.957891589 - modifiedĬontrol File +RECO/orcl/controlfile/current.49661.957891589 - modifiedĭatafile +DATA/orcl/datafile/system.846.95789151 - dbid changed, wrote new nameĭatafile +DATA/orcl/datafile/sysaux.849.95789151 - dbid changed, wrote new nameĭatafile +DATA/orcl/datafile/undotbs1.844.95789151 - dbid changed, wrote new nameĭatafile +DATA/orcl/datafile/users.843.95789151 - dbid changed, wrote new nameĭatafile +DATA/orcl/datafile/undotbs2.880.95789161 - dbid changed, wrote new nameĭatafile +DATA/orcl/tempfile/temp.879.95789159 - dbid changed, wrote new nameĬontrol File +DATA/orcl/controlfile/current.824.957891589 - dbid changed, wrote new nameĬontrol File +RECO/orcl/controlfile/current.49661.957891589 - dbid changed, wrote new name All rights reserved.Ĭonnected to database ORCL (DBID=1485672324)
0 kommentar(er)
