Administrasi control file

cek lokasi :

SQL> show parameter control_files;


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=

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


3). startup database


Leave a Reply

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

You are commenting using your 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