I have moved to erudans.wordpress.com, it has more customization options and allows wide articles.
Thanks!
Thanks!
Oracle database technology blog
"The Block Change Tracking File . By default, when doing an incremental backup, any datafile that has changed in any way will be backed up. This can make incremental backups take longer and will make them larger. RMAN offers the ability to just back up changed database blocks. This can make your incremental database backups much smaller and shorter. " (Freeman, Hart - Oracle RMAN 11g Backup and Recovery)This stating that the whole datafile will be backed up, which is not very correct. The incremental backup works on block level disregarding BCTF.
SELECT STATUS, FILENAME FROM V$BLOCK_CHANGE_TRACKING; STATUS FILENAME ---------- ------------------------------------------ DISABLED update t1 set t='TEST1' where c>100000 and c<101000; 12987 rows updated. commit; Commit complete.
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/u01/oracle/oradata/fast_recovery_area/ED12/chtf01.dbf' REUSE; Database altered. SQL> update t1 set t='TEST1' where c>100000 and c<101000 12987 rows updated. SQL> commit; Commit complete.
RMAN> backup incremental level 0 database;
Starting backup at 24-SEP-16
RMAN> SQL 'ALTER SESSION SET NLS_DATE_FORMAT="DD.MM.YYYY HH24:MI:SS"';
sql statement: ALTER SESSION SET NLS_DATE_FORMAT="DD.MM.YYYY HH24:MI:SS"
RMAN> backup incremental level 0 database;
Starting backup at 24-SEP-16
export NLS_DATE_FORMAT='YY/MM/DD HH24:MI'
rman target /
RMAN>
Starting backup at 16/09/24 16:39
RMAN> run {
2> host 'date';
3> backup incremental level 0 database;
4> host 'date';
5> }
Sat Sep 24 16:09:57 BST 2016
host command complete
Starting backup at 24-SEP-16
[oracle@single1 ~]$ srvctl add -h
The SRVCTL add command adds the configuration and the Oracle Restart application to the OCR for the cluster database, named instances, named services, or for the named nodes.
Usage: srvctl add database -db-oraclehome [-domain ] [-spfile ] [-pwfile ] [-role {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY | FAR_SYNC}] [-startoption ] [-stopoption ] [-dbname ] [-instance ] [-policy {AUTOMATIC | MANUAL | NORESTART}] [-diskgroup " "]
srvctl add database -db ED12 -oraclehome /u01/oracle/product/12.1.0/dbhome_1 -spfile '/u01/oracle/product/12.1.0/dbhome_1/dbs/spfileED12.ora' -policy AUTOMATIC -startoption OPEN -stopoption IMMEDIATE
[oracle@single1 ~]$ srvctl status database -d ED12
Database is not running.
[oracle@single1 ~]$ srvctl start database -d ED12
[oracle@single1 ~]$ ps -ef | grep pmon
oracle 2737 1 0 12:10 ? 00:00:00 asm_pmon_+ASM
oracle 3140 1 0 12:27 ? 00:00:00 ora_pmon_ED12
oracle 3351 2906 0 12:27 pts/0 00:00:00 grep pmon
[oracle@single1 ~]$ srvctl stop database -d ED12
[oracle@single1 ~]$ srvctl remove database -d Ed12 -f
[oracle@single1 ~]$ srvctl status database -d Ed12
PRCD-1120 : The resource for database Ed12 could not be found.
PRCR-1001 : Resource ora.ed12.db does not exist
[oracle@single1 ~]$ srvctl add database -d ED12 -o /u01/oracle/product/12.1.0/dbhome_1 -p '/u01/oracle/product/12.1.0/dbhome_1/dbs/spfileED12.ora' -y AUTOMATIC -s OPEN -t IMMEDIATE
[oracle@single1 ~]$ srvctl start database -d ED12
[oracle@single1 ~]$ ps -ef | grep pmon
oracle 2711 1 0 12:31 ? 00:00:00 asm_pmon_+ASM
oracle 3360 1 0 12:36 ? 00:00:00 ora_pmon_ED12
oracle 3773 2558 0 12:44 pts/0 00:00:00 grep pmon
[oracle@single1 ~]$ cat /etc/sysctl.conf | grep vm vm.nr_hugepages = 454 [oracle@single1 ~]$ ulimit -l 217728 [root@single1 ~]# grep Huge /proc/meminfo HugePages_Total: 447 HugePages_Free: 447 HugePages_Rsvd: 0 HugePages_Surp: 0 Hugepagesize: 2048 kB
Starting ORACLE instance (normal) (OS id: 2308) Thu Sep 08 00:52:56 2016 CLI notifier numLatches:3 maxDescs:519 Thu Sep 08 00:52:56 2016 ********************************************************************** Thu Sep 08 00:52:56 2016 Dump of system resources acquired for SHARED GLOBAL AREA (SGA) Thu Sep 08 00:52:56 2016 Per process system memlock (soft) limit = 213M Thu Sep 08 00:52:56 2016 Expected per process system memlock (soft) limit to lock SHARED GLOBAL AREA (SGA) into memory: 902M Thu Sep 08 00:52:56 2016 Available system pagesizes: 4K, 2048K Thu Sep 08 00:52:56 2016 Supported system pagesize(s): Thu Sep 08 00:52:56 2016 PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) Thu Sep 08 00:52:56 2016 4K Configured 5 228357 NONE Thu Sep 08 00:52:56 2016 2048K 447 451 5 NONE Thu Sep 08 00:52:56 2016 RECOMMENDATION: Thu Sep 08 00:52:56 2016 1. For optimal performance, configure system with expected number of pages for every supported system pagesize prior to the next instance restart operation. Thu Sep 08 00:52:56 2016 2. Increase per process memlock (soft) limit to at least 902MB to lock 100% of SHARED GLOBAL AREA (SGA) pages into physical memory Thu Sep 08 00:52:56 2016 **********************************************************************
[root@single1 ~]# grep Huge /proc/meminfo
HugePages_Total: 447
HugePages_Free: 442
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
[oracle@single1 ED12]$ vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id wa st
9 5 327268 8276 76 2548 25329 5873 111710 5943 7419 3964 1 81 9 10 0
8 9 327192 8304 76 2780 31724 4704 147192 4712 7993 4184 1 86 0 13 0
12 6 327416 8208 76 2604 35900 5240 150804 5240 9309 4434 0 98 0 2 0
13 6 327312 8092 76 2876 43788 5624 120172 5640 9220 3972 1 94 0 5 0
9 5 327156 8268 76 3188 41672 5416 144988 5416 9602 4268 0 96 0 4 0
11 7 326944 8332 76 2856 42608 6332 132128 6356 9086 4061 1 94 0 5 0
14 8 327288 8072 76 2880 40352 5416 114864 5436 9221 4477 0 75 0 25 0
10 4 327464 8128 76 2608 40860 5144 125752 5240 8501 4199 1 78 0 21 0
10 7 327468 8092 80 2652 38696 3784 137976 3828 8758 3978 0 98 0 2 0
11 9 327364 8224 80 2816 40768 3692 138048 3704 8603 3874 0 91 0 9 0
12 5 327492 8472 88 2620 45792 4200 146660 4244 9484 4267 1 94 0 5 0
8 4 327396 8264 88 2896 42648 5616 124336 5616 9898 4251 1 96 0 3 0
11 5 327352 8116 84 2752 35832 5616 124496 5640 8382 4228 0 92 0 8 0
10 7 327272 8148 88 2700 35352 6628 117264 6628 8418 4152 1 96 0 3 0