Oracle 11.2 and SQL Developer 3.2.
For the data backup I use OEM/Rman to schedule a backup. My understanding, those are generally for the DATA only (physical backup).
Now I want to do the logic backup for the tables, packages/procedures, and triggers. I currently use Oracle's SQL Developer to export them as separate SQL files.
I just wonder if there are other options for backuping the tables, procedures, and triggers?
Currently, I am keep three types of backups:
1) scripts for creating user, role, and granting user privileges.
2) tables, packages/procedures, and triggers backed up via Oracle SQL Developer
3) ora data backed up via OEM
In the event of total DB crash, I'll run the scripts to create user, role, and grant privileges; Then log in as the authorized user, and run the sql scripts to create tables, packages/procedures,, and triggers; Finally recover the data via RMAN.
Is this a good practice for backup/recovery, or there are some better ways to do it?
Thanks.
Scott