Backup Oracle Database using RMAN Mei 10, 2007
Posted by Tyo in Oracle.1 comment so far
connecting to RMAN via command line :rman TARGET SYS/target_pwd@target_strexample : rman target /
Configuring RMAN Environment :CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘d:\orclbackupora_df%t_s%s_s%p’;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP
FORMAT FOR DEVICE TYPE DISK TO ‘d:\orclbackupora_cf%F’;
CONFIGURE BACKUP OPTIMIZATION ON;
to view the configuration that has been made : Show all
to Backup Database : BACKUP DATABASE PLUS ARCHIVELOG;
if finish with RMAN to close the dialog type : EXIT
hope this will help.
Create Updateable Views using Trigger “instead of” Mei 10, 2007
Posted by Tyo in Oracle.add a comment
Usually if we create a view in oracle database, the view that we create is not updateable. we can modify view using instead of trigger model. (lagi…)
