Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Create type and Grant on it. Oracle
  • Drop database in Oracle 10g Oracle
  • Drop all SPM baselines for SQL handle Oracle
  • All About oracle password and security from metalink Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Giving Grant on v$DATABASE Oracle
  • MYSQL and Oracle Comparison for Oracle DBA MYSQL
  • plan10g.sql good Oracle
  • upload.html PHP/MYSQL/Wordpress
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • Optimizer_Index init.ora parameter explaination. Oracle
  • To see how much time or progress of long transaction Oracle
  • FRA Information. Oracle
  • Renaming Oracle Instance Name Oracle
  • configUOCIOTTO.ora Oracle

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

  • Recovering lost SYS password Oracle
  • Composite Index creation tip from Vivek Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • CTAS with LONG Column for 7.x and 8 and 8i Oracle
  • ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME Oracle
  • moving lob object to other tablespace lob_mvmt.sql Oracle

Leave a Reply Cancel reply

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

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Good notes for shared pool Oracle
  • Physical Standby switchover with session active Oracle
  • Jai Shree Ram Oracle
  • Debugging Shell FIles Linux/Unix
  • before_trunc.sql Before Truncate table needs to execute following: Oracle
  • create user with unlimited quota Oracle
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • SYSOPER Mystery Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme