can rman FTP backup ?

Posted on 2006-05-29
Last Modified: 2012-05-05
I have 800 GB database, it became impossible to backup to disk due to space limitation. can rman FTP the backup piece to the media server during backup?  
I know rman did not backup to UNC mapped drive, so FTP would be a good solution.  if rman can not do this, then any have script to do the following:

put the tablespace in backup mode
ftp all files to the remote media server
out the tablespace online.

I could not find any way that I can ftp files while I am in sqlplus prompt.   I can call extrenal ftp to to the job, but I have about 300 datafiles that have unique names, but belong to diffrent users and directories, therefore, I don't want to write 300 scripts!

Question by:salasadi
    LVL 16

    Expert Comment

    Using RMAN it is not required to put tablespace in backup mode. RMAN does online backup of database blocks.
    You can specify the destination for backup datafiles to the new location. FTP can be done at the OS level only.

    Author Comment

    I understand that, but RAMAN

    Author Comment

    I understand that, but RMAN won't allow backup to UNC path or network share--have tp be attached phiscal drive.  having said that, 800 GB can not be duplicated to the same disk becuase there is no enough space.

    Unless RAMN have machanisim of FTP the backup set after upon completion, then free the space, RMAN not going to be feasable --in this case.

    therefore, I was looking for "Silver-Bulet" solution to put the tapespace in backup mode, then FTP (Instead copy) datafiles, then put tablespace back online.  I could find any way to call FTP from sqlplus.  
    LVL 16

    Accepted Solution

    Backup and FTP tablespaces one by one. Write a script which will ftp the file.

    1) Using sql*plus put tablespace in backup mode
    2) using the script ftp datafiles to network share. use host command in sql*plus to execute a host command.
    SQL> host "/u01/oracle/data01.dbf"
    3) put tablespace online
    4) Repeat the steps 1-3 for all tablespaces

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Suggested Solutions

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now