发布时间：2013-09-11 09:48:01
RMAN> backup tablespace ICMLFQ32;Starting backup at 10-SEP-13using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00005 name=/oradata/portaldb_ICMLFQ32_01.dbfchannel ORA_DISK_1: startin.........【阅读全文】
发布时间：2013-09-11 09:35:29
用rman备份数据库时，遇到如下信息RMAN-03009: failure of backup command on ORA_DISK_1 channelORA-19602: cannot backup or copy active file in NOARCHIVELOG modeRman需要在归档模式下SQL> connect sys/chaya as sysdbaSQL> shutdown immediate;SQL> startup mount;SQL> alter database archivelog;SQL> alter.........【阅读全文】
发布时间：2013-09-09 13:34:44
查看字符集SQL> select * from v$nls_parameters; 更改字符集：ALTER DATABASE character set INTERNAL_USE AL32UTF8;重启数据库。......【阅读全文】
发布时间：2013-08-29 20:33:13
imp icms/password@portaldb file=/home/oracle/icms.dmp fromuser=icms touser=icms ignore=y;出现 IMP-00058: ORACLE error 12154 encountered 错误。发现 /opt/oracle/product/11.2.0/db_1/network/admin/目录下没有listener.ora 、sqlnet.ora、 tnsnames.ora三个文件,需要手工添加并且更正文件权限为安装oracl.........【阅读全文】
