RESTORE from BACKUP
pfile --- edit file
spfile--- binarni fajl
[oracle@knjaz dbs]$cd $ORACLE_HOME/dbs ---/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initknjaz11.ora
[oracle@knjaz dbs]$more initknjaz11.ora --- kopiraj parametre u notepad i edituj
=============================================================================================
*.audit_file_dest='/u01/app/oracle/admin/knjaz11/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/KNJAZ11/controlfile/o1_mf_6j1bvc87_.ctl'
*.control_management_pack_access='NONE'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata'
*.db_domain=''
*.db_name='knjaz11'
*.diagnostic_dest='/u01/app/oracle'
*.log_archive_dest='/u01/app/oracle/arhive/knjaz11'
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=FALSE
*.sessions=445
*.sga_max_size=6G
*.sga_target=6G
*.standby_file_management='AUTO'
*.undo_retention=18000
*.undo_tablespace='UNDOTBS1'
sga_max_size=6G
sga_target=6G --- zavisi od memorije masine koliko ima ( masina ima 8G )
=============================================================================================
edituj
.bash_profile --- kao na produkciji
=============================================================================================
napravi putanje kao na produkciji
-------------------------------------
mkdir -p /u01/app/oracle/admin/knjaz11/adump
mkdir -p /u01/app/oracle/oradata/KNJAZ11/controlfile
mkdir -p /u01/app/oracle/arhive/knjaz11
mkdir -p /u01/app/oracle/oradata/KNJAZ11/datafile
mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1/dbs
mkdir -p /u01/app/oracle/oradata/KNJAZ11/onlinelog
proveri lokacije koje si napravio
--------------------------------------
ll /u01/app/oracle/admin/knjaz11/adump
ll /u01/app/oracle/oradata/KNJAZ11/controlfile
ll /u01/app/oracle/arhive/knjaz11
ll /u01/app/oracle/oradata/KNJAZ11/datafile
ll /u01/app/oracle/product/11.2.0/dbhome_1/dbs
ll /u01/app/oracle/oradata/KNJAZ11/onlinelog
=============================================================================================
napravi PFILE u $ORACLE_HOME/dbs initKNJAZ11.ora --- i kopiraj ono gore vec pripremljeno
=============================================================================================
*.audit_file_dest='/u01/app/oracle/admin/knjaz11/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/KNJAZ11/controlfile/o1_mf_6j1bvc87_.ctl'
*.control_management_pack_access='NONE'
*.db_block_size=8192
*.db_create_file_dest='/u01/app/oracle/oradata'
*.db_domain=''
*.db_name='knjaz11'
*.diagnostic_dest='/u01/app/oracle'
*.log_archive_dest='/u01/app/oracle/arhive/knjaz11'
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sec_case_sensitive_logon=FALSE
*.sessions=445
*.sga_max_size=6G
*.sga_target=6G
*.standby_file_management='AUTO'
*.undo_retention=18000
*.undo_tablespace='UNDOTBS1'
============================================================================================
probaj da se konektujes na bazu
sqlplus / as sysdba
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2238472 bytes
Variable Size 1107298296 bytes
Database Buffers 5301600256 bytes
Redo Buffers 2543616 bytes
============================================================================================
u slucaju da je initfile (pfile) malim slovima ili velikim , menja se na ovaj nacin
[oracle@restore dbs]$ mv initKNJAZ11.ora initknjaz11.ora
============================================================================================
rman target /
onda se setuje DBID ( pokupljen sa produkcije ) kada se konektujes na RMAN videces DBID
[oracle@ ]$SET DBID 4201214779
[oracle@ ]$restore controlfile from autobackup;
bice greska
mora ovako
RMAN>restore controlfile from 'lokacija gde je';
RMAN>alter database mount;
RMAN>catalog start with 'gde se backup nalazi'; --- govorim controlfile u gde je backup , posto je sada na novoj lokaciji
RMAN>list backup summary --- da vidimo dokle ce da radimo restore
RMAN>list backup tag LEVEL0_DISK; --- da vidimo sta ima u tom zapakovanom
5060173170 najveci SCN datafileova
RMAN> list backup of archivelog all; ---da vidimo koje arhive imamo
58985 sekvenca arhive --- trazi se sekvenca koja sadrzi arhive od SCN broja koja je u jednom fileu veca i manja, u svakom slucaju nece se pogresiti ako se uzme veca , radice malo duze
onda ide skripta za restore i recover
==========================================
RMAN>
run {
set until SEQUENCE 58985 thread 1;
restore database;
recover database;
}
=========================================
cekas dok ne zavrsi RESTORE (28 fajlova - primer )
kada zavrsi se posle 10 sati
RMAN>alter database open resetlogs;
database opened
setuj bazu u NoArchive logmode da ne pravi arhive bzv
conn /nohup
SQL>conn ops$tanasko
UBIJA SE :
SQL>drop package ops$tanasko.ap_mail_api
pregledaj JOB-ove koje treba da ukines
SQL>select * from dba_scheduler_jobs --- najbolje videti sa developerima sta treba ukinuti da JOB ne napravi sheet
--- job
select * from dba_network_acls; --- ACL lista
brise se :
execute dbms_scheduler.drop_job('UNI4_MASTER_JOB');
BRISANJE_NATURA
CHANGE_BATCH_SVE_LINIJE
DS_REPORT_SUM
DS_REPORT_SUM_ACT
FUTURA_STAMPA ZALIHE
JOB_UNIFOR
LAGER_MIN_ZALIHE
UNI4_440429
Aktiviraj LISENER
Napravi TNSNAMES
tek nakon ovoga pusti RAZVOJ na mrezu
da bi mogao da se nakacis na RAZVOJOS sa AppSrv moras da editujes paket ap_korisnik_api
passwd => p_password);
if l_retval = 0 then
return 'ok!';
else
if l_retval = 49 then
return 'fail!';
else
return 'ok!';
/* else
ap_mail_api.send_mail('sasa.djuric@knjaz.co.rs',
'Greska prilikom logovanja!',
'Korisnik: ' || p_username || chr(13) ||
chr(10) || 'Domen: ' || p_domain || chr(13) ||
chr(10) || 'Greska: ' || l_retval);*/
return 'fail!';
end if;
end if;
END;
