oracle

Administrasi control file

cek lokasi : SQL> show parameter control_files; atau SQL> select name from v$controlfile; melihat isi control file : select * from V$CONTROLFILE_RECORD_SECTION order by type; untuk backup control file : SQL> alter database backup controlfile to trace; menambah control file : 1). shutdown database SQL > shutdown immediate 2). copy salah satu control file ke… Continue reading Administrasi control file

Advertisements