
Listing 1
-------------------------------------------------
# written	: For R3BNKORA AIX node
# Date	: August 2006
# Script 	: begin_backup.sql
# Purpose   : It will place all oracle tablespaces into begin backup mode
# and hence will ensure database consistency before online backup is 
# taken using FlashCopy technique.
-----------------------------------------------------
#!/bin/ksh
connect /as sysdba
alter tablespace BNKORABTABD begin backup;
alter tablespace BNKORABTABI begin backup;
alter tablespace BNKORACLUD begin backup;
alter tablespace BNKORALOADD begin backup;
alter tablespace BNKORALOADI begin backup;
alter tablespace BNKORAPOOLD begin backup;
alter tablespace BNKORAPOOLI begin backup;
alter tablespace BNKORAPROTD begin backup;
alter tablespace BNKORAPROTI begin backup;
alter tablespace BNKORAROLL begin backup;
alter tablespace BNKORASOURCED begin backup;
alter tablespace BNKORASOURCEI begin backup;
alter tablespace BNKORASTABD begin backup;
alter tablespace BNKORASTABI begin backup;
alter tablespace BNKORATEMP begin backup;
alter tablespace BNKORAUSER1D begin backup;
alter tablespace BNKORAUSER1I begin backup;
alter tablespace SYSTEM begin backup;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

