2015年02月_5icode.top

原创 sqlldr提交两次，数据类型报错

[oracle@Slave1Hadoop51 script]$ cat ldr_case1.ctlLOAD DATAINFILE *INTO TABLE BONUSFIELDS TERMINATED BY ","(ENAME,JOB,SAL)BEGINDATASMITH,CLEAK,3904ALLEN,SALESMAN,2891WARD,SALESMAN,3128KING,PR

2015-02-27 00:36:14 1750

原创 nomount 状态编录也能查看备份信息--控制文件丢失也是nomount状态？

2015-02-07 00:31:23 619

原创 Linux 系统时间修改

[oracle@Slave1Hadoop51 ~]$ dateTue Feb 3 12:09:09 CST 2015[oracle@Slave1Hadoop51 ~]$ date Fri Feb 6 23:47:53 CST 2015date: extra operand `Feb'Try `date --help' for more information.[oracle

2015-02-06 23:56:33 843

原创恢复编录-前奏曲

RMAN> delete noprompt backup;allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=120 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=159 devtype=DISKallocated channel: ORA_DISK

2015-02-05 23:42:15 707

原创 Listener 静态注册、与动态注册 --可以远程连接别的机器的DBServer

Connecting to 192.168.55.56:22...Connection established.To escape to local shell, press 'Ctrl+Alt+]'.Last login: Tue Feb 3 07:45:35 2015 from 192.168.55.100[oracle@Slave1Hadoop51 ~]$ lsnrctl sta

2015-02-05 22:11:49 817

原创 Listener监听器静态注册--杂记

[oracle@Slave1Hadoop51 admin]$ cat listener.ora# listener.ora Network Configuration File: /u01/oracle/11G/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENE

2015-02-05 00:03:27 674

原创 oracle 监听

2015-02-04 00:18:54 710

原创常用rman命令

device type diskRMAN> validate device type disk backupset 37;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =====

2015-02-04 00:14:00 660

原创找回被转移的备份文件 delete expired ;catalog

RMAN> list backup of tablespace users;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- -----------

2015-02-03 23:04:10 881

原创 report need backup redundancy 1 tablespace users;删除"过期"备份

RMAN> report need backup redundancy 1 tablespace users;Report of files with less than 1 redundant backupsFile #bkps Name---- ----- -----------------------------------------------------4 0

2015-02-03 00:17:03 705

原创 report need backup备份冗余度

RMAN> delete backup;using channel ORA_DISK_1using channel ORA_DISK_2List of Backup PiecesBP Key BS Key Pc# Cp# Status Device Type Piece Name------- ------- --- --- ----------- ----------

2015-02-02 22:20:20 1106

原创 rman 进度条--待续定时计划

RMAN> list copy;List of Archived Log CopiesKey Thrd Seq S Low Time Name------- ---- ------- - --------- ----1 1 1 A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf2

2015-02-02 21:28:28 555

原创 Linux 虚拟机 ip与 oracle 用户名密码

ssh Slave1Hadoop51ssh MasterHadoop50ssh Slave2Hadoop52ssh Slave1Hadoop51ssh MasterHadoop50ssh Slave2Hadoop52ssh Slave1Hadoop51ssh MasterHadoop50ssh Slave2Hadoop52ssh Slave1Hadoop51

2015-02-02 21:08:37 1867 1

原创 TNS-12541: TNS:no listener

2015-02-01 18:21:25 2219

原创 backup 的路径

RMAN> show2> all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # defau

2015-02-01 15:41:55 1181

原创 could not translate tablespace name "TEST_TBS"

RMAN> list backup of tablespace TEST_TBS;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571:

2015-02-01 15:27:41 954

原创 drop tablespace TEST including contents and datafiles;

SQL> select t2.file#,t1.name tablespacename,t2.name from v$tablespace t1,v$datafile t2 where t1.ts# = t2.ts#; FILE# TABLESPACENAME NAME---------- ------------------------------ -----------

2015-02-01 15:03:29 4737

原创 rman 归档日志 crosscheck

RMAN> list backup of copy;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ================

2015-02-01 14:10:58 1924

原创 rm手动直接删除oracle的备份片段，用list backup查还显示出来

RMAN> list backup;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------64

2015-02-01 13:53:46 1004

原创 rman 屏幕日志输出到文件

RMAN> rman log /home/oracle/nosetdesc/logs/rman_log.txt;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============

2015-02-01 13:14:10 2335

原创 to mismatched status. Use CROSSCHECK command to fix status

RMAN> show all;RMAN configuration parameters are:CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

2015-02-01 12:32:10 1718

hzdxw的专栏