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 direktori yang diinginkan

3). startup nomount

SQL > startup nomount

SQL > alter system set control_files=
‘/oradata/oracle/ts/control01.ctl’,
‘/oradata/oracle/ts/control02.ctl’,
‘/oradata/oracle/ts/control03.ctl’,
‘/data1/oracle/control04.ctl’
scope=spfile;

SQL > shutdown immediate

4). startup

SQL > startup

5). cek

SQL > select name from v$controlfile;

Drop control file

1). shutdown db

2). ambil control file

control_files=’/oradata/oracle/ts/control01.ctl’,
‘/oradata/oracle/ts/control02.ctl’,
‘/oradata/oracle/ts/control03.ctl’

3). startup database