Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> switch logfile vs. archive log current

switch logfile vs. archive log current

From: Schauss, Peter <pschauss_at_northropgrumman.com>
Date: Wed, 19 Mar 2003 06:15:55 -0800
Message-Id: <24715.322365@fatcity.com>


In my hot backup script, should I be using "alter system archive log current;"
instead of "alter system switch logfile;"?

At present this is what I am doing:

For each tablespace:

sqlplus internal << EOF
alter tablespace ERGO_USR begin backup;
exit
EOF
#

cp $DIR3/ERGO_USR.dbf $BACKUP_DIR$DIR3
#

sqlplus internal << EOF
alter tablespace ERGO_USR end backup;
alter system switch logfile;
exit
EOF For the last tablespace:

sqlplus internal << EOF
alter tablespace USERS begin backup;
exit
EOF
#

cp $DIR1/users01.dbf $BACKUP_DIR$DIR1
#

sqlplus internal << EOF
alter tablespace USERS end backup;
alter database backup controlfile to '$BACKUP_DIR$DIR1/control01.bak'; alter system switch logfile;
exit
EOF
#

Thanks,
Peter Schauss Received on Wed Mar 19 2003 - 08:15:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US