Listing 2 Oracle end backup

-------------------------------------------------------
#
# written    : For R3BNKORA AIX node
# Date       : August 2006
# Script     : end_backup.sql

# Purpose    : To bring all Oracle tablespaces back to normal state
---------------------------------------------------------
#!/bin/ksh
connect / as sysdba 
alter tablespace BNKORABTABD end backup;
alter tablespace BNKORABTABI end backup;
alter tablespace BNKORACLUD end backup;
alter tablespace BNKORALOADD end backup;
alter tablespace BNKORALOADI end backup;
alter tablespace BNKORAPOOLD end backup;
alter tablespace BNKORAPOOLI end backup;
alter tablespace BNKORAPROTD end backup;
alter tablespace BNKORAPROTI end backup;
alter tablespace BNKORAROLL end backup;
alter tablespace BNKORASOURCED end backup;
alter tablespace BNKORASOURCEI end backup;
alter tablespace BNKORASTABD end backup;
alter tablespace BNKORASTABI end backup;
alter tablespace BNKORATEMP end backup;
alter tablespace BNKORAUSER1D end backup;
alter tablespace BNKORAUSER1I end backup;
alter tablespace SYSTEM end backup;