Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • All About Trace Fils Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • Space padding in korn shell Linux/Unix
  • Paste command syntax Linux/Unix
  • Recovering lost SYS password Oracle
  • For Search and replace unix command. Linux/Unix
  • block_ident.sql Oracle
  • Parallel DML Oracle
  • Kernel Parameter setting explaination for Processes Parameter Linux/Unix
  • metalink all dynamic view reference notes. Oracle
  • Find total file sizes Linux/Unix
  • CPU speed on solaris Linux/Unix
  • Linux CPU info. Linux/Unix
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • alter database backup controlfile to trace Oracle

cold backup scripts to copy locally

Posted on 28-Oct-2009 By Admin No Comments on cold backup scripts to copy locally

==>cat SOX_BACKUP.ksh

#!/usr/bin/ksh

# +————————————————————————

# | Usage : ./SOX_BACKUP.ksh

# | Description : Cold Backup of Database. Automatically starts/stop the DB.

# +————————————————————————

. /export/home/oracle/FLRSTB.env

sqlplus -s /nolog << EOF > /mnt/ORACLEBACKUP/files.log

connect / as sysdba

set term off

set feedback off;

set head off;

set pagesize 150

select name||’ /mnt/ORACLEBACKUP/FLRPRD’ from v$datafile;

exit;

EOF

cat /mnt/ORACLEBACKUP/files.log|grep -v “Connected.” > /mnt/ORACLEBACKUP/files.dat

. /export/home/oracle/FLRSTB.env

sqlplus /nolog << EOF >> /mnt/ORACLEBACKUP/backup.log

connect / as sysdba

shutdown immediate;

exit;

EOF

echo “Backup Copy Started at :- `date` ” >>/mnt/ORACLEBACKUP/backup.log

nohup ./firecp.sh files.dat

echo “Backup Copy Ended at :- `date` ” >>/mnt/ORACLEBACKUP/backup.log

. /export/home/oracle/FLRSTB.env

sqlplus /nolog << EOF >> /mnt/ORACLEBACKUP/backup.log

connect / as sysdba

startup nomount;

alter database mount standby database;

exit;

EOF

oracle@sunrise*FLRSTB-/mnt/ORACLEBACKUP

==>

==>cat firecp.sh

#!/bin/ksh

# +————————————————————————

# | Usage : firescp.sh

# | filename – Flat file containing the operands for cp cmd

# | Description : Submits concurrent cp commands based on number of workers

# +————————————————————————

let WORKERS=5

LOGFILE=/mnt/ORACLEBACKUP/copy_dbfiles.log

while read -u3 CMDLINE

do

SRC_FILE=`echo ${CMDLINE}|awk ‘{print $1}’`

DST_FILE=`echo ${CMDLINE}|awk ‘{print $2}’`

echo “Now copying ${SRC_FILE} to ${DST_FILE}”|tee -a ${LOGFILE}

nohup /usr/bin/cp -p ${SRC_FILE} ${DST_FILE} 1>>${LOGFILE} 2>&1 &

sleep 1

while [[ `ps -ef|grep -v grep|grep “cp -p”|wc -l` -ge ${WORKERS} ]]

do

sleep 10

done

done 3<$1
wait

echo “SOX Copy of FLRPRD database is done”|mailx -s “Copy process done for FLRPRD on sunrise” bnair@1800flowers.com

Linux/Unix, shell

Post navigation

Previous Post: Oracle 10g for solaris 10
Next Post: process id based files and processes

Related Posts

  • checking connectivity between two servers Linux/Unix
  • Reading parameter file and printing Linux/Unix
  • good linux notes Linux/Unix
  • Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
  • secure crt settings Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Directory wise folder wise space usage Linux/Unix
  • How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
  • Drop database in Oracle 10g Oracle
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • send email from unix mailx with attachment. Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • process id based files and processes Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme