/**** HOT Backup Script *******/
define INT_PWD =
define HOT_BACK_DIR =
/* Create Temporary Table with Tablespace Data */
drop table system.dsc_hot_stage;
create table system.dsc_hot_stage
(
tablespace_name varchar2(50),
file_name varchar2(250)
);
insert into system.dsc_hot_stage
select rtrim(tablespace_name),rtrim(file_name) from sys.dba_data_files;
commit;
/**** Set up the parameters for the spool file */
set feedback off
set heading off
set pagesize 0
set linesize 256
set verify off
set termout oN
set echo off
spool /hottobox.sql
select 'connect sys/&INT_PWD as sysdba' from dual;
select 'spool /hottobox.og' from dual;
-- Create Script to backup actual files to a directory
-- select 'host copy '||member|| ' &HOT_BACK_DIR' from v_$logfile;
select 'alter tablespace '|| tablespace_name||' begin backup;' c1,
'!scp '||file_name||' @ :' ||file_name c2,
'alter tablespace '|| tablespace_name||' end backup;' c1 from system.dsc_hot_stage;
-- Create Script to backup Control File to Trace
-- select 'alter database backup controlfile to trace;'
-- from dual;
-- select 'alter database backup controlfile to '||''''||
-- '&CTRL_BACK_DIR'||'/ctrlDOCS'||
-- to_char(sysdate,'MMDD')||''''||';' from dual;
select 'select distinct a.tablespace_name,b.status,b.time from dba_data_files a, v$backup b where a.file_id=b.file#;'
from dual;
select 'spool off' from dual;
select 'exit' from dual;
spool off
define INT_PWD =
define HOT_BACK_DIR =
/* Create Temporary Table with Tablespace Data */
drop table system.dsc_hot_stage;
create table system.dsc_hot_stage
(
tablespace_name varchar2(50),
file_name varchar2(250)
);
insert into system.dsc_hot_stage
select rtrim(tablespace_name),rtrim(file_name) from sys.dba_data_files;
commit;
/**** Set up the parameters for the spool file */
set feedback off
set heading off
set pagesize 0
set linesize 256
set verify off
set termout oN
set echo off
spool
select 'connect sys/&INT_PWD as sysdba' from dual;
select 'spool
-- Create Script to backup actual files to a directory
-- select 'host copy '||member|| ' &HOT_BACK_DIR' from v_$logfile;
select 'alter tablespace '|| tablespace_name||' begin backup;' c1,
'!scp '||file_name||' @ :' ||file_name c2,
'alter tablespace '|| tablespace_name||' end backup;' c1 from system.dsc_hot_stage;
-- Create Script to backup Control File to Trace
-- select 'alter database backup controlfile to trace;'
-- from dual;
-- select 'alter database backup controlfile to '||''''||
-- '&CTRL_BACK_DIR'||'/ctrlDOCS'||
-- to_char(sysdate,'MMDD')||''''||';' from dual;
select 'select distinct a.tablespace_name,b.status,b.time from dba_data_files a, v$backup b where a.file_id=b.file#;'
from dual;
select 'spool off' from dual;
select 'exit' from dual;
spool off