Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


can rman FTP backup ?

Posted on 2006-05-29
Medium Priority
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
  • 2
  • 2
LVL 16

Expert Comment

ID: 16787179
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

ID: 16789464
I understand that, but RAMAN

Author Comment

ID: 16789502
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

MohanKNair earned 500 total points
ID: 16795525
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 copy_files.sh "/u01/oracle/data01.dbf"
3) put tablespace online
4) Repeat the steps 1-3 for all tablespaces

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

577 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