Tyo Sites and Notes

A quite sometimes ago my friend asking about how to delete a datafile because he create too many datafiles in his tablespaces. i’m not sure why he want to do that, but because he said that it create a problem with some ORA error when he take the datafiles directly offline and delete it manual, then he restart the pc and then try to open the database via sqlplus. because i’m not in his place, i just assuming that the database state is in mount position but not open. since the oracle is still looking for the datafile that he is manually delete previously. (lagi…)

---

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.

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…)

ORA-00202: controlfile: ‘C:\ORACLE\ORADATA\ORACLE91\CONTROL02.CTL’

ORA-27091: skgfqio: unable to queue I/O

ORA-27070: skgfdisp: async read/write failed

OSD-04006: ReadFile() failure, unable to read from file

O/S-Error: (OS 23) Data error (cyclic redundancy check).

i find this problem on one of my server database. this problem will make oracle fail to mount and open. if you try to connect via sqlplus, you will get error message : Oracle is on initialization startup/shutdown. so you can not enter the database. (lagi…)