Backup - Restore
1.instaliran Linux
2.instaliran ORACLE_HOME
primarna
[oracle@knjaz15 ~]$ rman target /
3.pusta se skripta za export --- boldirano je to sto se menja u zavisnosti od lokacije i SID - a
run {
allocate channel ch_disk1 type disk maxpiecesize 20240M;
allocate channel ch_disk2 type disk maxpiecesize 20240M;
backup database format '/home/oracle/backup/knjaz15_rman_%U'
tag 'KNJAZ15_FULL_DB_BACKUP' plus archivelog format '/home/oracle/backup/knjaz15_arch_%U' delete input;
}
========================================================================================================================
ako izbaci gresku
RMAN-06059: expected archived log not found, loss of archived log compromises re
ORA-19625: error identifying file /u01/app/oracle/product/11.2.0/db_1/dbs/arch1_
ORA-27037: unable to obtain file status
pusti komandu
RMAN> crosscheck archivelog all; --- lokacija svih arhiva i da li se tamo nalaze
RMAN> report obsolete; --- izlistaj one arhive ili backup-e koji su zastareli ( retention policy )
RMAN> delete expired archivelog all; --- brisi zastarele
========================================================================================================================
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> ovo iznad je sve medju korak <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
startuj ponovo skriptu za backup
**********************************************************************************************************************************************
run {
allocate channel ch_disk1 type disk maxpiecesize 20240M;
allocate channel ch_disk2 type disk maxpiecesize 20240M;
backup database format '/home/oracle/backup/knjaz15_rman_%U'
tag 'KNJAZ15_FULL_DB_BACKUP' plus archivelog format '/home/oracle/backup/knjaz15_arch_%U' delete input;
}
**********************************************************************************************************************************************
4. napravi istu lokaciju gde ti je backup i na sekundarnoj masini --- /home/oracle/backup
kopiraj sa PRIMARNE na SEKUNDARNU masinu backup koji je skripta uradila /home/oracle/backup
5. [oracle@knjaz15 backup]$ scp /home/oracle/backup/* oracle@10.1.11.132:/home/oracle/backup
6. podigni SEKUNDARNU bazu u nomount mode
---------------------------------------------------------------------------------------------------------------------------
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> test <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
connect na SEKUNDARNU
RMAN> restore controlfile; --- error
RMAN> restore controlfile from autobackup; ---error RMAN-06495: must explicitly specify DBID with SET DBID command
---------------------------------------------------------------------------------------------------------------------------
DBID nacices ga kada se konektujes na primarnu bazu ( odakle se uzima backup )
primer:
connected to target database: KNJAZ15 (DBID=260230255)
sekundarna
7. RMAN>SET DBID 260230255; --- SET DBID
RMAN>restore controlfile from autobackup; --- error RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece --- controlfile nije na $ORACLE_HOME/dbs, vec je na drugom mestu /home/oracle/backup/
>>>>>>>>>>>>>>>>>>>>>>>>>> MORA MANUELNO DA SE KOPIRA CONTROLFILE sa PRIMARNE na SEKUNDARNU <<<<<<<<<<<<<<<<<<<<<<<<<
primarna > cd $ORACLE_HOME/dbs --- vidis koji je zadnji po datumu
8.scp /u01/app/oracle/product/11.2.0/db_1/dbs/c-260230255-20151028-00 oracle@10.1.11.132:/u01/app/oracle/product/11.2.0/db_1/dbs/
onda na standbay
9.RMAN>restore controlfile from autobackup; --- svaki put kada se izadje iz RMAN-a mora da se potera komanda SET DBID 260230255;
================================================================================================================================
za znati
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name KNJAZ15 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_knjaz15.f'; # default
****************************************************************************************************************************************************************
10. RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/backup/%F'; --- lokacija da kada radi backup CONTROLFILE stavi na lokaciju koja je u putanji
****************************************************************************************************************************************************************
SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> alter database mount;
******************************************************************************************************************************
11.[oracle@tstby132 dbs]$ rman target /
12. list backup;
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> nadjemo u backup-u sekvencu a uvek pisemo -1 nadjene <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
SCN broj zadnjeg data filea koji je backapovan, ( NAJVECI SCN broj od svih DATAFILEOVA )
ONDA sledece
13.RMAN> list backup of archive logs; ---- informacija o backupu archive logova
primer:
===============================================================================================
List of Archived Logs in backup set 19
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 189 3653364 28-OCT-15 3653425 28-OCT-15
NEXT SCN 3653425 -1 3653424 --- je prvi sledeci broj arhive koji je veci od SCN broja zadnjeg datafilea koji backapovan
===============================================================================================
sledi skripta koja radi restore and recovery
14.[oracle@knjaz15 ~]$ rman target /
run {
set until SCN 3653424;
restore database;
recover database;
}
=====================================================================================================
RMAN> list backup summary; --- lista kad je backup bio tj ,...HEDER backapa skracena verzija
=====================================================================================================
to je to :)