- 博客(21)
- 收藏
- 关注
原创 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 1789
原创 nomount 状态 编录也能查看备份信息--控制文件丢失也是nomount状态?
[oracle@Slave1Hadoop51 ~]$ rman target sys/ml123456@db01 catalog rcowner/rcowner@db02Recovery Manager: Release 10.2.0.1.0 - Production on Sat Feb 7 00:06:24 2015Copyright (c) 1982, 2005, O
2015-02-07 00:31:23 640
原创 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 892
原创 恢复编录-前奏曲
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 732
原创 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 837
原创 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 685
原创 oracle 监听
[oracle@MasterHadoop50 admin]$ lsnrctl statusLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-FEB-2015 00:09:17Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecti
2015-02-04 00:18:54 728
原创 常用rman命令
device type diskRMAN> validate device type disk backupset 37;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =====
2015-02-04 00:14:00 710
原创 找回被转移的备份文件 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 895
原创 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 721
原创 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 1122
原创 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 570
原创 Linux 虚拟机 ip与 oracle 用户名 密码
ssh Slave1Hadoop51ssh MasterHadoop50ssh Slave2Hadoop52ssh Slave1Hadoop51ssh MasterHadoop50ssh Slave2Hadoop52ssh Slave1Hadoop51ssh MasterHadoop50ssh Slave2Hadoop52ssh Slave1Hadoop51
2015-02-02 21:08:37 1884 1
原创 TNS-12541: TNS:no listener
[oracle@MasterHadoop50 wallet]$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2015 18:14:10Copyright (c) 1991, 2005, Oracle. All rights reserved.Welcome to LSNRCTL, type
2015-02-01 18:21:25 2236
原创 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 1211
原创 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 972
原创 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 4798
原创 rman 归档日志 crosscheck
RMAN> list backup of copy;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ================
2015-02-01 14:10:58 2017
原创 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 1022
原创 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 2373
原创 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 1769
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人