Oracle RMAN backup compression full and incremental

Full backup compression scripts :

backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_df2_%d_%t_%s_%p_%U';

Incremental backup compression scripts :

backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_inc_%d_%t_%s_%p_%U';

Log:


[oracle@OEL564ASMN1 scripts]$ rman target/

Recovery Manager: Release 11.2.0.3.0 - Production on Wed Oct 12 14:50:09 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ASMDB (DBID=624768357)

RMAN> backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 0 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_df2_%d_%t_%s_%p_%U';

Starting backup at 12-OCT-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=57 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/asmdb/datafile/system.256.880569463
input datafile file number=00002 name=+DATA/asmdb/datafile/sysaux.257.880569467
input datafile file number=00005 name=+DATA/asmdb/datafile/example.265.880569629
input datafile file number=00006 name=+DATA/asmdb/datafile/test_tbs.267.881349853
input datafile file number=00003 name=+DATA/asmdb/datafile/undotbs1.258.880569467
input datafile file number=00004 name=+DATA/asmdb/datafile/users.259.880569471
input datafile file number=00007 name=+DATA/asmdb/datafile/tbs_user_data_1.268.882462007
input datafile file number=00008 name=+DATA/asmdb/datafile/tbs_user_data_1.269.882458361
channel ORA_DISK_1: starting piece 1 at 12-OCT-16
channel ORA_DISK_1: finished piece 1 at 12-OCT-16
piece handle=+RMAN_BACKUP/rman_bkp_df2_asmdb_925051814_18_1_0iri6at6_1_1 tag=ORCL_FULL comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:35
Finished backup at 12-OCT-16

Starting Control File and SPFILE Autobackup at 12-OCT-16
piece handle=+FRA/asmdb/autobackup/2016_10_12/s_925051911.360.925051913 comment=NONE
Finished Control File and SPFILE Autobackup at 12-OCT-16

RMAN>
RMAN> backup AS COMPRESSED BACKUPSET INCREMENTAL LEVEL 1 database tag ORCL_FULL format '+RMAN_BACKUP/rman_bkp_inc_%d_%t_%s_%p_%U';

Starting backup at 12-OCT-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/asmdb/datafile/system.256.880569463
input datafile file number=00002 name=+DATA/asmdb/datafile/sysaux.257.880569467
input datafile file number=00005 name=+DATA/asmdb/datafile/example.265.880569629
input datafile file number=00006 name=+DATA/asmdb/datafile/test_tbs.267.881349853
input datafile file number=00003 name=+DATA/asmdb/datafile/undotbs1.258.880569467
input datafile file number=00004 name=+DATA/asmdb/datafile/users.259.880569471
input datafile file number=00007 name=+DATA/asmdb/datafile/tbs_user_data_1.268.882462007
input datafile file number=00008 name=+DATA/asmdb/datafile/tbs_user_data_1.269.882458361
channel ORA_DISK_1: starting piece 1 at 12-OCT-16
channel ORA_DISK_1: finished piece 1 at 12-OCT-16
piece handle=+RMAN_BACKUP/rman_bkp_inc_asmdb_925052081_22_1_0mri6b5h_1_1 tag=ORCL_FULL comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 12-OCT-16

Starting Control File and SPFILE Autobackup at 12-OCT-16
piece handle=+FRA/asmdb/autobackup/2016_10_12/s_925052147.359.925052147 comment=NONE
Finished Control File and SPFILE Autobackup at 12-OCT-16

RMAN> exit


Recovery Manager complete.

[oracle@OEL564ASMN1 scripts]$

ORA-03113: end-of-file on communication channel (ORA-19809: limit exceeded for recovery files)

Cause: Archive log location are full.

SQL> startup;
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2177456 bytes
Variable Size            1342178896 bytes
Database Buffers          788529152 bytes
Redo Buffers                5001216 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 3952
Session ID: 127 Serial number: 3


SQL>

From Alert Log

ARC0: STARTING ARCH PROCESSES COMPLETE
Errors in file d:\app\diag\rdbms\orcl\orcl\trace\orcl_ora_3952.trc:
ORA-16038: log 1 sequence# 1420 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: 'D:\APP\ORADATA\ORCL\REDO_01.LOG'
USER (ospid: 3952): terminating the instance due to error 16038
Instance terminated by USER, pid = 3952


Solution:

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size                  2177456 bytes
Variable Size            1342178896 bytes
Database Buffers          788529152 bytes
Redo Buffers                5001216 bytes
Database mounted.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=400G scope=both;

System altered.

SQL> alter database open;

Database altered.

SQL>

Weblogic server started but console is not opening.

Check the Weblogic server log ($DOMAIN_HOME/servers/AdminServer/security) for making sure that Weblogic server are started successfully.

If service started successfully check the firewall is blocking or not. If firewall is blocking then stop the firewall.

[root@weblogic2 oracle]# chkconfig iptables off
[root@weblogic2 oracle]#
[root@weblogic2 oracle]#
[root@weblogic2 oracle]# service iptables stop
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@weblogic2 oracle]#