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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s