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.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully

cd /u01/app/oracle/product/12.1.0/dbhome_1/network/admin
mv listener.ora _listener.ora

lsnrctl start

LSNRCTL for Linux: Version 12.1.0.1.0 -
ProductionCopyright Start Date  (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  31-JUL-2014 23:50:05
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level12.1.0.1.0 - Production
Log messages written 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                     LISTENER
Version    off Security              TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date   ON: Local OS Authentication SNMP         31-JUL-2014 23:50:05
Uptime           OFF Listener Log File      0 days  /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 command 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 =
      (SERVERADDRESS = (PROTOCOL = TCP)(HOST = source-int)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pdb1)
    )
  )

TNS Ping 
SQL*PlusUtility for Linux: ReleaseVersion 12.1.0.1.0 - Production
on Thu Jul 31 23:57:41 2014
Copyright (c) 19821997, 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