top of page

CHANGE SID


SQL>alter database backup controlfile to trace as '/home/oracle/pajapatak';   
=========================================================================

[oracle@ ~]$more pajapatak  

 

nadji  Set #2. RESETLOGS case 

kopiraj sve ispod u notepad i edituj ( promeni SID )

CREATE CONTROLFILE SET DATABASE "RAZVOJOS" RESETLOGS FORCE LOGGING ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 2920
LOGFILE
  GROUP 4 '/u01/app/oracle/oradata/RAZVOJOS/onlinelog/o1_mf_4_6o82loxg_.log'  SIZ
E 250M BLOCKSIZE 512,
  GROUP 5 '/u01/app/oracle/oradata/RAZVOJOS/onlinelog/o1_mf_5_6o82m90b_.log'  SIZ
E 250M BLOCKSIZE 512,
  GROUP 6 '/u01/app/oracle/oradata/RAZVOJOS/onlinelog/o1_mf_6_6o82mlb8_.log'  SIZ
E 250M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_system_c5y2br3f_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_sysaux_c5y23s51_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_undotbs1_c5y2bqvg_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_users_c5y2bqtp_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br4g_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br4p_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br5l_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y79n80_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y79nfr_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y79nrm_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y7bgo2_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y7dsly_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_arhiva_c5ynd6qb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y7p5qb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y8rtsd_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5xtpo96_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5xwptd5_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ygblm3_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ygbm8w_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_pi_data_c5ynd7w0_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_pi_indx_c5ynfbdb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ygcwhw_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yghq1k_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yghqgh_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yh8mbx_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yl5znr_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ynd5kl_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2bqwb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br0v_.dbf'
CHARACTER SET EE8MSWIN1250
;


    
SQL>create pfile from spfile;                              --- napravili pfile

obrisi sada SPFILE

 

spusti bazu 
SQL>shutdown immediate;


obrisi controlfile > /u01/app/oracle/oradata/test22/datafile/RAZVOJOS/controlfile/o1_mf_c0wnjh3v_.ctl'

 

pfile --- izmeni sve na zeljeno ime SID a
-------------------------------------------------------------------------------------------------------------------------------------------
*.audit_file_dest='/u01/app/oracle/admin/razvojos/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/razvojos/datafile/RAZVOJOS/controlfile/o1_mf_c0wnjh3v_.ctl'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata/razvojos/datafile'
*.db_domain=''
*.db_name='razvojos'
*.diagnostic_dest='/u01/app/oracle'
*.log_archive_dest='/u01/app/oracle/archive/razvojos'
*.open_cursors=300
*.pga_aggregate_target=2599419904
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=555
*.sga_target=1610612736
*.undo_tablespace='UNDOTBS1'

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

izmeni lokacije na linuxu   tj. sve lokacije iz pfile  a   iznad boldirano

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------        startuj bazu u nomount stanje
SQL>startup nomount;
ako je pfile ok 
pusti 

******************************************************************************************************************************

CREATE CONTROLFILE SET DATABASE "RAZVOJOS" RESETLOGS FORCE LOGGING ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 2920
LOGFILE
  GROUP 4 '/u01/app/oracle/oradata/RAZVOJOS/onlinelog/o1_mf_4_6o82loxg_.log'  SIZ
E 250M BLOCKSIZE 512,
  GROUP 5 '/u01/app/oracle/oradata/RAZVOJOS/onlinelog/o1_mf_5_6o82m90b_.log'  SIZ
E 250M BLOCKSIZE 512,
  GROUP 6 '/u01/app/oracle/oradata/RAZVOJOS/onlinelog/o1_mf_6_6o82mlb8_.log'  SIZ
E 250M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_system_c5y2br3f_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_sysaux_c5y23s51_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_undotbs1_c5y2bqvg_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_users_c5y2bqtp_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br4g_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br4p_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br5l_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y79n80_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y79nfr_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y79nrm_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y7bgo2_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y7dsly_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_arhiva_c5ynd6qb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y7p5qb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y8rtsd_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5xtpo96_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5xwptd5_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ygblm3_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ygbm8w_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_pi_data_c5ynd7w0_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_pi_indx_c5ynfbdb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ygcwhw_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yghq1k_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yghqgh_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yh8mbx_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5yl5znr_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5ynd5kl_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2bqwb_.dbf',
  '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_aplikaci_c5y2br0v_.dbf'
CHARACTER SET EE8MSWIN1250

;

*************************************************************************************************************************************************************************************************

 

ako je sve ok ...
SQL>alter database open resetlogs;

 

i pusti komandu za rekreiranj temp file a

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/RAZVOJOS/datafile/o1_mf_temp_6j1bwxz3_.tmp' REUSE;

 

 

ako nece , napravi tmpfile

 

 

SQL>alter tablespace temp add tempfile size 1G autoextend on next 200M maxsize 15G;

 

 

promeni u .BASH_PROFILE   SID

 

© 2015 by Sasa Djuric

  • Twitter Square
  • facebook-square
bottom of page