ITPub博客

错误事件：从另外一个库上导出的数据，在本台机器上做remap导入时遇到无法读取指定对象的元数据和数据的问题，错误如下图所示经查阅资料发现，如果去掉include塞选条件可以通过，因此，这可能是一个oracle10g的bug但是我只要导入这12张表怎么办规避方法可以在导出数据阶段进行include塞选然后在导入到另外一个...

SQL> alter database archivelog;alter database archivelog*ERROR at line 1:ORA-00265: instance recovery required,cannot set ARCHIVELOG mode原因为上次库非正常关闭导致数据库处于不一致状态，重新启动实例到mount状态即可SQL> shutdown immediateDatabase closed.Database dismo...

SQL> alter system setlog_archive_dest_1='/u02/archive_log/' scope=both;alter system setlog_archive_dest_1='/u02/archive_log/' scope=both*ERROR at line 1:ORA-32017: failure in updating SPFILEORA-16179: incremental changes to"log_archive_dest_1" not allowed with SPFILE在设...

1、  创建SWAP目录[root@node2 ~]# mkdir /u01/swapdir2、  创建SWAP文件[root@node2 ~]# dd if=/dev/zeroof=/u01/swapdir/myswap bs=1M count=20482048+0 records in2048+0 records out2147483648 bytes (2.1 GB) copied, 24.4351seconds, 87.9 MB/s[root@node2 ~]# ll -h /u01...

增加磁盘空间1、  在虚拟机上创建新的硬盘一直下一步至选固定大小创建完成2、  切片[root@node2 ~]# fdisk -l Disk /dev/sda: 8589 MB, 8589934592 bytes255 heads, 63 sectors/track, 1044 cylindersUnits = cylinders of 16065 * 51...

修改/etc/sysconfig/network-scripts/ifcfg-eth0文件[root@node1 ~]# vi/etc/sysconfig/network-scripts/ifcfg-eth0  # Intel Corporation 82540EM GigabitEthernet ControllerDEVICE=eth0BOOTPROTO=noneONBOOT=yesHWADDR=08:00:27:02:95:38TYPE=Ether...

RMAN> backup database include currentcontrolfile plus archivelog; Starting backup at 09-APR-14current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive logbackupsetchannel ORA_DISK_1: spec...

RMAN> crosscheck archivelog all; released channel: ORA_DISK_1released channel: ORA_DISK_2released channel: ORA_DISK_3allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=138 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=135 devtype=DISKal...

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPEDISK clear; old RMAN configuration parameters:CONFIGURE CHANNEL 2 DEVICE TYPE DISKFORMAT  '/u02/backup/rman/BJDB/disk2_1/BJDB_%U.bak',   '/u02/backup/rman/BJDB/disk2_2/BJDB_%U.bak';old RMAN configuration parameters ar...

1、首先在客户机中安装oracle客户端 2、安装完之后打开服务器的监听 [oracle@zhang admin]$ lsnrctl start   LSNRCTL for Linux: Version 10.2.0.1.0- Production on 07-APR-2014 12:55:53   Copyright (c) 1991, 2005, Oracle.  All rights reserved.   Starting ...

如果数据文件中存在多个实例的情况，就应该配置shared_server_sessions和shared_servers参数的值如：设置之前SQL> show parameter shared NAME                       &n...

在用数据泵导出emp表工资高于 2500 那些记录的时候报ORA-31693: Table data object"SCOTT"."EMP" failed to load/unload and is being skippeddue to error:ORA-00920: invalid relational operator的错误出现此错误的命令为[oracle@zhang u02]$ expdp scott/tigerdirectory=dump_dir dumpfile=sa...

ORA-16019: cannot use db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST1、  将归档日志路径LOG_ARCHIVE_DEST的值改为空idle>alter system setlog_archive_dest=''；2、  设置归档日志路径log_archive_dest_1的值 idle>alter system set ...

1、首先热备份数据库alter tablespace SYSTEM begin backup;! cp/u01/app/oracle/oradata/SAFE/system01.dbf /u02/backup/SAFEalter tablespace SYSTEM end backup;alter tablespace UNDOTBS1 begin backup;! cp /u01/app/oracle/oradata/SAFE/undotbs01.dbf/u02/backup/SAFEalter tablespace ...

1、将A库的日志文件拷贝到B库的宿主机中2、用日志挖掘的流程挖掘日志（注，用dbms_logmnr.add_logfile时路径要写拷贝的日志所在位置的绝对路径）

完全恢复：将数据库恢复按照日志恢复到最近时间点的恢复称做完全恢复不完全恢复：将数据库恢复按照日志恢复到某一时间点的恢复称作不完全恢复

热备必须在归档模式下进行用logmnr做日志挖掘需要用到最小补充日志1、添加最小补充日志idle>alter database add supplemental logdata; Database altered.2、  查询一下数据文件及其表空间 idle>select file_name,file_id,tablespace_name from dba_data_files;...

一致性备份优点：简单、快捷一致性备份缺点：要在数据库关闭的情况才能进行，不适于OLTP模式

1、现在系统中给归档日志建一个存储目录[oracle@zhang\:/export/home/oracle]$mkdir/software/cold_backup/2、查看一下数据库是否启用归档模式idle>archive log list;Database log mode              No Archive ModeAutomatic a...

1、增加一个日志组SQL> alter database add logfile group4('/u01/app/oracle/oradata/orcl/disk4/redo01.log') size 100m;2、给日志组增加一个成员SQL> alter database add logfile member'/u01/app/oracle/oradata/orcl/disk4/redo02.log' to group 4;3、手动切换当前日志组SQL> alter system switch lo...