After introducing Java stored procedures in Oracle database and its development steps, this paper discusses how to develop Java stored procedures to achieve Oracle remote logical backup and restoration through an example. Practice shows that Java stored procedure dose not only have the advantages of improving the efficiency and maintainability of system, and enhancing system security, etc., but also provides a good solution to the client to achieve complex application in the network environment.