Rastgele Yazılar : Oracle Datafile Name ve Path Değiştirme(ARCHIVELOG )
Rastgele Yazılar : ORACLE - XML - 1
Rastgele Yazılar : SQLite
Rastgele Yazılar : Listener Service' ine Şifre Atama
Rastgele Yazılar : Oracle'da Merge İşlemi
Rastgele Yazılar : Sık Kullanılan Rman Komutları ile İlgili Temel Bilgiler...
Rastgele Yazılar : Nedir bu Data Warehouse?
Rastgele Yazılar : SGA & PGA
Rastgele Yazılar : Recover Operasyonunun Test Edilmesi
Rastgele Yazılar : Slowly Changing Dimensions Nedir?
1- RAC node'larından biri ile veritabanına bağlanıp and mevcut control file durumunu kontrol ediyoruz.DATA disk grup altında control file'ın mevcut olduğunu görüyorum ve test sunucusunda başka disk grup ekli olmadığı için control file çoklama işlemini aynı disk grup altında yapacağım. -bash-3.00$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 14:30:53 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- +DATA/test/controlfile/current.261.814996359 2- Aşağıdaki şekilde '+DATA' disk grubunu ikinci control file için ekliyoruruz. SQL> alter system set control_files='+DATA/test/controlfile/current.261.814996359', '+DATA' scope=spfile sid='*'; System altered. SQL> exit 3- Veritabanını kapatıp nomount mode da açıyoruz. -bash-3.00$ srvctl stop database -d test -bash-3.00$ srvctl start database -d test -o nomount
4- Control_files parametrelerini kontrol ediyoruz. -bash-3.00$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 14:30:53 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string +DATA/test/controlfile/current .261.814996359, +DATA SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options 5- Rman' e bağlanıp restore komutuyla +DATA altında ikinci contol file'ın kopyasını oluşturuyoruz. -bash-3.00$ rman target / Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 10 14:31:57 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST (not mounted) RMAN> restore controlfile from '+DATA/test/controlfile/current.261.814996359'; Starting restore at 10-JUN-13 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=51 instance=TEST1 device type=DISK channel ORA_DISK_1: copied control file copy output file name=+DATA/test/controlfile/current.261.814996359 output file name=+DATA/test/controlfile/current.307.817742049 Finished restore at 10-JUN-13 RMAN> exit Recovery Manager complete.
6- Rman ile restore ettikten sonra output file name satırlarında belirtilen control file'ları set ederiz. -bash-3.00$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 14:35:18 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> alter system set control_files='+DATA/test/controlfile/current.261.814996359', '+DATA/test/controlfile/current.307.817742049' scope=spfile sid='*'; System altered. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options 7- Veritabanını kapatıp tekrar açıyoruz. -bash-3.00$ srvctl stop database -d test -bash-3.00$ srvctl start database -d test 8- Veritabanına bağlanıp control file 'ı listelediğimizde +DATA disk grubun altında control file'ın kopyasının oluştuğunu görüyoruz. -bash-3.00$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 10 15:57:37 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> show parameter control_files; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ control_files string +DATA/test/controlfile/current .261.814996359, +DATA/test/con trolfile/current.307.817742049 SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- +DATA/test/controlfile/current.261.814996359 +DATA/test/controlfile/current.307.817742049 SQL>