We have been running the rman backup to Amazon S3 using the aws library for several weeks now. It works fine. It is of course not viable in all situations, but should be an interesting alternative for small enterprises. We will soon launch a service for remote backup based on this technology.
oracle sys account and passwords
2008/12/16If you need to install some components in your Oracle database as sys, you could be in for a surprise. You can have different passwords in your password file (in $ORACLE_HOME/dbs) and inside the database. To make sure that the right one is used, perform the following using the role “sys as sysdba” in sqlplus directly on the database server:
sql> alter user sys identified by yourpasswordhere;
This problem could occur if you use the orapwd utility to create a new password for your instance *and* set it to something different than what you have inside of the database. I have seen it several times during migrations.
our man reports: it works
2008/12/01I ran the test with the aws library. It works as expected. I used the tag directive, but I am not sure if that got picked up or ignored. Will research further. I have one tiny database that will get backed up to Amazon once a week using the following syntax:
backup as compressed backupset copy of database tag 'some_tag';
Posted by ebraekke