Hi,
I have 2 shell scripts ,one for taking hot backup of oracle Database while other is for progress bar.
But I don't have an idea hoe should I incorporate the shell script of progress bar in my hot backup code .
Please help.
My shell script for hot backup is as below:
********************************************************
/* Directory to hold the backups /
define HOT_BACK_DIR = &HOT_BACK_DIR
/ Hot Spool File /
--define SCRIPT_FILE = &HOT_BACK_DIR
/ Create Temporary Table with Tablespace Data /
drop table dsc_hot_stage;
create table dsc_hot_stage
(
tablespace_name varchar2(30),
file_name varchar2(200)
);
insert into dsc_hot_stage
select rtrim(tablespace_name),rtrim(file_name) from sys.dba_data_files;
/ Set up the parameters for the spool file */
set feedback off
set heading off
set pagesize 0
set linesize 128
set verify off
set termout oN
set echo off
spool /fcdata1/hotbkp_script/hotbkp.sql
select 'conn / as sysdba' from dual;
-- Create Script to backup Control File to Trace
select 'alter database backup controlfile to trace; '
FROM DUAL;
select 'host mkdir '||'&HOT_BACK_DIR'||to_char(sysdate,'yyyymmdd') from dual;
select 'host mkdir '||'&HOT_BACK_DIR'||to_char(sysdate,'yyyymmdd')||'/archive' from dual;
-- Create Script to backup actual files to a directory
select 'alter tablespace '|| tablespace_name||' begin backup;' c1,
'host cp '||file_name||' &HOT_BACK_DIR'||to_char(sysdate,'yyyymmdd') || '/' ||
substr(file_name,instr(rtrim(file_name),'/',-1,1)+1,length(rtrim(file_name))),
'host gzip '||' &HOT_BACK_DIR'||to_char(sysdate,'yyyymmdd') || '/' ||
substr(file_name,instr(rtrim(file_name),'/',-1,1)+1,length(rtrim(file_name)))
from dsc_hot_stage ,dual
union
select 'alter tablespace '|| tablespace_name||' end backup;' c1,
null, null
from dsc_hot_stage
group by tablespace_name,file_name order by 1;
select 'alter database backup controlfile to '||''''||'&HOT_BACK_DIR'||to_char(sysdate ,'yyyymmdd')||'/controlfile.ctl'||''''||';' from dual;
select '@/fcdata1/hotbkp_script/archive_switch.sql;' from dual;
select '@/fcdata1/hotbkp_script/archive_seq1.sql;' from dual;
select 'host sh /fcdata1/hotbkp_script/archive_files_move/dsbmove.sh' from dual;
spool off
set feedback off
set heading off
set pagesize 0
set linesize 128
set verify off
set termout oN
set echo off
spool /fcdata1/hotbkp_script/archive_files_move/currarchivedate.log
select '&HOT_BACK_DIR'||to_char(sysdate,'yyyymmdd')||'/archive' from dual;
spool off
select 'echo " Starting the actual Hot Backup " ' from dual;
@/fcdata1/hotbkp_script/archive_switch.sql;
@/fcdata1/hotbkp_script/archive_seq.sql;
@/fcdata1/hotbkp_script/hotbkp.sql;
**********************************************
Script for progress bar as below:
#!/bin/sh
i=50
echo "0--------20--------40-------60--------80-------100%"
while [ $i -ge 0 ]
do
echo "#\c"
sleep 1
i=`expr $i - 1`
done