Page Comparison

echo $TWO_TASK
pdb1
unset TWO_TASK

sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Thu Jul 31 23:25:18 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
CDB$ROOT@ORCL>

CDB$ROOT@ORCL> alter user system identified by oracle;
User altered. 

CDB$ROOT@ORCL> alter user sys identified by oracle;
User altered.

CDB$ROOT@ORCL> ALTER SESSION SET container = pdb1;

ALTER USER oe IDENTIFIED BY oe; 
ALTER USER oe ACCOUNT UNLOCK;
GRANT ALTER SESSION,      
CONNECT,     
CREATE MATERIALIZED VIEW,     
CREATE VIEW,     
QUERY REWRITE,     
RESOURCE TO oe;     
GRANT EXECUTE ON DBMS_LOCK TO oe;     
ALTER USER OE QUOTA UNLIMITED ON USERS;

SQL> drop table OE.CATEGORIES_TAB;

SQL> create directory TTORCL_TRG_DATA_PUMP_DIR as '/u01/app/oracle/admin/orcl/dpdump/';

SQL> exit

lsnrctl stop

LSNRCTL for Linux: Version 12.1.0.1.0 - Production 
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Log messages written to Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully

cd /u01/app/oracle/diag/tnslsnr/source/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=source-int)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.product/12.1.0/dbhome_1/network/admin
mv listener.ora _listener.ora

lsnrctl start

LSNRCTL for Linux: Version 12.1.0.1.0 
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 12.1.0.1.0 - Production
StartLog Datemessages written               31-JUL-2014 23:50:05
Uptime    to /u01/app/oracle/diag/tnslsnr/source/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=source-int)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                0 days 0 hr. 0 min.LISTENER
0Version  sec Trace Level               offTNSLSNR Securityfor Linux: Version 12.1.0.1.0 - Production
Start Date           ON: Local OS Authentication SNMP 31-JUL-2014 23:50:05
Uptime                   OFF Listener0 Logdays File0 hr. 0 min. 0 sec
Trace Level  /u01/app/oracle/diag/tnslsnr/source/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=source-int)(PORT=1521))) The listener supports no services The commandoff
completed successfully

lsnrctl service

LSNRCTL for Linux: Version 12.1.0.1.0 - Production
Copyright (c) 1991, 2013, Oracle.  All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=source-int)(PORT=552911521))
Services Summary...
Service "pdb1orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
TheService command"orclXDB" completed successfully

vi /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora

TTORCL_SRC =
  (DESCRIPTION =
    (CONNECTADDRESS_DATALIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = source-int)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb1)
    )
  )

TNS Ping Utility for SQL*PlusLinux: ReleaseVersion 12.1.0.1.0 - Production
onCopyright Thu Jul 31 23:57:41 2014
Copyright (c) 1982, 2013, Oracle.(c) 1997, 2013, Oracle.  All rights reserved.
LastUsed Successfulparameter login time: Thu Jul 31 2014 23:50:31 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
PDB1@ORCL> exit

sqlplus oe/oe@ttorcl_src

SQL*Plus: Release 12.1.0.1.0 Production
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Last Successful login time: Thu Jul 31 2014 23:50:31 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
PDB1@ORCL> exit

unset TWO_TASK

Unsetting of TWO_TASK was already done in a previous step so it is not strictly needed.

sqlplus / as sysdba

CDB$ROOT@ORCL> shutdown immediate

startup mount

ORACLE instance started.
Total System Global Area  413372416 bytes
Fixed Size		    2289016 bytes
Variable Size		  322962056 bytes
Database Buffers	   79691776 bytes
Redo Buffers		    8429568 bytes
Database mounted.

alter database archivelog;

Database altered.

alter database open;

Database altered.

archive log list

Database log mode	       Archive Mode
Automatic archival	       Enabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     104
Next log sequence to archive   106
Current log sequence	       106

exit

su - 

vi /usr/local/bin/del_arch.sh

#!/bin/bash
#
# set -x
###########################################
#  Function to echo usage
###########################################
usage ()
{
     echo
     echo "Usage: del_arch <dbsid> <retention_in_days>"
     echo  example: del_arch testdb 0.5
     echo
     echo  Default retention is 2 days
}
###########################################
#  Function to setup parameter variables
###########################################
setup_parameters ()
{
   system_hostname=`uname -n`
   program_name=`basename $0`
   dba_top=/u01/oracle/log
   log=${dba_top}/rman_${db}-`date +%d%m%Y%H%M`.log
   [ -d "${dba_top}" ] || mkdir ${dba_top}
}
###########################################
#  Function to change database environments
###########################################
change_db ()
{
 export ORAENV_ASK=NO
 export ORACLE_SID=$1
 . /usr/local/bin/oraenv >> /dev/null
}

###########################################
#  Function to Add text to logfile
###########################################
addLog()
{
  echo "`date +%d-%h-%Y:%H:%M:%S` : $1" >> ${log}
}
###################################
#  Function to purge archive logs #
###################################
run_delete ()
{
change_db ${db}
addLog "Start Delete with rentention ${retention}..."
echo "Start Delete with rentention ${retention}..."
rman append msglog=${log} <<!EOF
connect target /
run {
change archivelog all validate;
delete noprompt archivelog until time 'SYSDATE-${retention}';
}
!EOF
addLog "End Delete..."
}
##################
##### Main Program
##################
db=$1
PATH=$PATH:/usr/local/bin/:.
export TMP=/u03/tmp
retention=$2
if  [ -z "$retention" ]
then 
   retention=2
fi
if  [ -z "$db" ]
then
      usage
      exit 2
else
 setup_parameters
 change_db ${db}
 run_delete
fi