|
上完1Z0-052第14章,开始 1Z0-052第6章网络
1Z0-052共19章(上完5章),1Z0-053共21章(上完2章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的7章
配置可恢复性,磁盘组添加新控制文件:
- [oracle@station90 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 24 19:28:46 2017
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected.
- SQL> show parameter control_files
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- control_files string +DATA/orcl/controlfile/current
- .260.816169631, +FRA/orcl/cont
- rolfile/current.256.816169633
- SQL> alter system set coontrol_files='+DATA/orcl/controlfile/current.260.816169631','+FRA/orcl/controlfile/current.256.816169633','/home/oracle/controlfile/control03.ctl' ;
- alter system set coontrol_files='+DATA/orcl/controlfile/current.260.816169631','+FRA/orcl/controlfile/current.256.816169633','/home/oracle/controlfile/control03.ctl'
- *
- ERROR at line 1:
- ORA-02065: illegal option for ALTER SYSTEM
- SQL> alter system set control_files='+DATA/orcl/controlfile/current.260.816169631','+FRA/orcl/controlfile/current.256.816169633','/home/oracle/controlfile/control03.ctl' ;
- alter system set control_files='+DATA/orcl/controlfile/current.260.816169631','+FRA/orcl/controlfile/current.256.816169633','/home/oracle/controlfile/control03.ctl'
- *
- ERROR at line 1:
- ORA-02095: specified initialization parameter cannot be modified
- SQL> alter system set control_files='+DATA/orcl/controlfile/current.260.816169631','+FRA/orcl/controlfile/current.256.816169633','/home/oracle/controlfile/control03.ctl' scope=spfile;
- System altered.
- SQL> shutdown immediate
- Database closed.
- Database dismounted.
- ORACLE instance shut down.
- SQL> SQL>
- SQL>
- SQL> startup
- ORA-00443: background process "PMON" did not start
- SQL> startup
- ORACLE instance started.
- Total System Global Area 6680915968 bytes
- Fixed Size 2213936 bytes
- Variable Size 3556771792 bytes
- Database Buffers 3087007744 bytes
- Redo Buffers 34922496 bytes
- ORA-00205: error in identifying control file, check alert log for more info
- SQL> alter database mount;
- Database altered.
- SQL> alter database open ;
- Database altered.
- SQL> show parameter control_files
- NAME TYPE VALUE
- ------------------------------------ ----------- ------------------------------
- control_files string +DATA/orcl/controlfile/current
- .260.816169631, +FRA/orcl/cont
- rolfile/current.256.816169633,
- /home/oracle/controlfile/cont
- rol03.ctl
- SQL>
复制代码- ASMCMD> cp Current.260.816169631 /home/oracle/controlfile/control03.ctl
- copying +DATA/ORCL/CONTROLFILE/Current.260.816169631 -> /home/oracle/controlfile/control03.ctl
复制代码
配置可恢复性,磁盘组添加新日志成员和日志组:- select * from v$thread;
- select * from v$log;
- select * from v$logfile;
- alter database add logfile group 4 size 52428800;
- alter system switch logfile;
- alter database drop logfile group 2;
- alter system checkpoint;
- alter database drop logfile group 4;
- alter database add logfile member '/home/oracle/redologfile/redo01.log' to group 1;
- alter system switch logfile;
- alter system switch logfile;
- alter system switch logfile;
- alter database drop logfile member '/home/oracle/redologfile/redo01.log';
- alter system switch logfile;
- alter database drop logfile member '/home/oracle/redologfile/redo01.log';
- ------
复制代码
监听器静态注册:
- # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
- # Generated by Oracle configuration tools.
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (GLOBAL_DBNAME = orcl.example.com)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
- (SID_NAME = orcl)
- )
- )
- LISTENER =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
- )
- ADR_BASE_LISTENER = /u01/app/oracle
- ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
复制代码
- # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
- # Generated by Oracle configuration tools.
- SID_LIST_L2 =
- (SID_LIST =
- (SID_DESC =
- (GLOBAL_DBNAME = orcl.example.com)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
- (SID_NAME = orcl)
- )
- (SID_DESC =
- (GLOBAL_DBNAME = rcat.example.com)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
- (SID_NAME = rcat)
- )
- )
- L2 =
- (DESCRIPTION_LIST =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1526))
- )
- )
- ADR_BASE_L2 = /u01/app/oracle
- SID_LIST_LISTENER =
- (SID_LIST =
- (SID_DESC =
- (GLOBAL_DBNAME = orcl.example.com)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
- (SID_NAME = orcl)
- )
- (SID_DESC =
- (GLOBAL_DBNAME = rcat.example.com)
- (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
- (SID_NAME = rcat)
- )
- )
- LISTENER =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
- )
- ADR_BASE_LISTENER = /u01/app/oracle
- ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON
复制代码- # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/grid/network/admin/tnsnames.ora
- # Generated by Oracle configuration tools.
- APPLE =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1521))
- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT = 1526))
- (LOAD_BALANCE = yes)
- )
- (CONNECT_DATA =
- (SERVICE_NAME = orcl.example.com)
- )
- )
- RCAT =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = rcat.example.com)
- )
- )
- FOR1526 =
- (DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
- (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1526))
- )
- )
- ORCL =
- (DESCRIPTION =
- (ADDRESS = (PROTOCOL = TCP)(HOST = station90.example.com)(PORT = 1521))
- (CONNECT_DATA =
- (SERVER = DEDICATED)
- (SERVICE_NAME = orcl.example.com)
- )
- )
复制代码
|
|