Listing 2
-------------------------------------------------------
#
# 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;


