Create Controlfile

21 November 2015 at 6:05 pm Tinggalkan komentar

CREATE CONTROLFILE SET DATABASE “ORAKU” RESETLOGS ARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 256
MAXINSTANCES 1
MAXLOGHISTORY 256
LOGFILE
GROUP 1 ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\REDO01.LOG’ SIZE 100M,
GROUP 2 ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\REDO02.LOG’ SIZE 100M,
GROUP 3 ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\REDO03.LOG’ SIZE 100M
DATAFILE
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\HRD01_1.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\HRD01_2.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\HRD01_3.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\HRD01_4.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\HRD01_5.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\INDX_HRD01_1.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\INDX_HRD01_2.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\INDX_HRD01_3.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\INDX_HRD01_4.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\INDX_HRD01_5.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\SYSAUX01.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\SYSTEM01.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\UNDOTBS01.DBF’,
‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\USERS01.DBF’
CHARACTER SET WE8MSWIN1252
;

RECOVER DATABASE USING BACKUP CONTROLFILE;

isi E:\app\Administrator\oradata\ORAKU\redo01.log

ALTER DATABASE OPEN RESETLOGS;

 

ALTER SYSTEM SET PROCESSES = 1000 SCOPE = SPFILE;
ALTER SYSTEM SET MAX_ENABLED_ROLES = 148 SCOPE = SPFILE;
ALTER SYSTEM SET TRANSACTIONS = 1000 SCOPE = SPFILE;

Janganlupa utk create ulang datafile temporary
ALTER TABLESPACE TEMP
ADD TEMPFILE ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\TEMP01.DBF’ SIZE 50M REUSE;
ALTER TABLESPACE TEMP01
ADD TEMPFILE ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\TEMP01_1.DBF’ SIZE 20M REUSE;
ALTER TABLESPACE TEMP01
ADD TEMPFILE ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\TEMP01_2.DBF’ SIZE 20M REUSE;
ALTER TABLESPACE TEMP01
ADD TEMPFILE ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\TEMP01_3.DBF’ SIZE 20M REUSE;
ALTER TABLESPACE TEMP01
ADD TEMPFILE ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\TEMP01_4.DBF’ SIZE 20M REUSE;
ALTER TABLESPACE TEMP01
ADD TEMPFILE ‘E:\APP\ADMINISTRATOR\ORADATA\ORAKU\TEMP01_5.DBF’ SIZE 20M REUSE;

 

SELECT name,value FROM v$parameter WHERE name IN (‘undo_management’,’undo_tablespace’);

create UNDO tablespace UNDOTBS datafile ‘E:\APP\ADMINISTRATOR\ORADATA\ORAHRD\UNDOTBS01_1.DBF’ size 1024m REUSE AUTOEXTEND ON NEXT 4096K MAXSIZE 1024M;
ALTER SYSTEM SET undo_tablespace = ‘UNDOTBS’ scope=spfile;

ALTER TABLESPACE UNDOTBS1 offline;
drop tablespace UNDOTBS1 including contents and datafiles;

ALTER SYSTEM SET fast_start_parallel_rollback=’FALSE’ scope=spfile;

Entry filed under: Uncategorized. Tags: .

Cara Merubah Serial Number Windows 8

Tinggalkan Balasan

Isikan data di bawah atau klik salah satu ikon untuk log in:

Logo WordPress.com

You are commenting using your WordPress.com account. Logout / Ubah )

Gambar Twitter

You are commenting using your Twitter account. Logout / Ubah )

Foto Facebook

You are commenting using your Facebook account. Logout / Ubah )

Foto Google+

You are commenting using your Google+ account. Logout / Ubah )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Twitter Jhoni

Kategori

Arsip

Kalender

November 2015
S S R K J S M
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
30  

%d blogger menyukai ini: