Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • rm_backup_arch_file.ksh Linux/Unix
  • copying/removing directory with all its subdirectory Linux/Unix
  • Changing the Global Database Name Oracle
  • Monitor Long Running Job Oracle
  • Standby Database File Management in 10g with STANDBY_FILE_MANAGEMENT Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • Removing Blank lines from file using grep Linux/Unix
  • find_longsql.sql Oracle
  • Goldengate document from Porus Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • Library cahe Latches and internal explaination Oracle
  • New OFA for 11g Oracle
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • move_arch_files.ksh Linux/Unix

Oracle Data Direct to TAPE

Posted on 23-Aug-2005 By Admin No Comments on Oracle Data Direct to TAPE

Can one export directly to a tape drive?

—————————————–

One can use a tape device name instead of a normal file name. When using a device, one also needs to specify the VOLSIZE= parameter. Look at this example:

exp userid/password file=/dev/rmt0 table=emp volsize=1.2G

Note: The volume size is a number ending with a “m”, “k”, or “b” (M, K, or B). The default is bytes.

Back to top of file

——————————————————————————–

Can one archive directly to tape?

———————————–

Yes, set log_archive_dest = /dev/rmt0:100M in your INIT.ORA file and recycle the database.

You can also use ARCHMON (when available) which communicates with the ARCH background process. When the end of tape is reached, ARCH stops and signals ARCHMON to prompt the user for a new tape. When ARCHMON detects the new tape, it tells the ARCH process to resume the archiving operation. ARCMON requires regular operator monitoring and intervention.

$ archmon @P:TEST

Oracle, SQL scripts

Post navigation

Previous Post: Export Oracle data and Compress at same time
Next Post: Check Oracle installed products using one command

Related Posts

  • PLSQL Table Syntax 2 Oracle
  • lck.sql Oracle
  • Oracle Internal Good Websites 1 Oracle
  • Drop all SPM baselines for SQL handle Oracle
  • Roles and Stored Object behaviour Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle

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 (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • Guide to Linux System Command Mastery Linux/Unix
  • SCRIPT TO LIST RECURSIVE DEPENDENCY BETWEEN OBJECTS UTLDTREE.sql Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • scripts to take listener.log backup Linux/Unix
  • create PLAN_TABLE command. Oracle
  • move_arch_files.ksh Linux/Unix
  • Temporary Tablespace Information and restriction. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme