SQL> set line 45SQL> desc t Name                 Null?    Type -------------------- -------- -------------- EMPNO                         NUMBER(4) ENAME                         VARCHAR2(10) JOB                           VARCHAR2(9) MGR                           NUMBER(4) HIREDATE                      DATE SAL                           NUMBER(7,2) COMM                          NUMBER(7,2) DEPTNO                        NUMBER(2)
SQL> insert into t(ENAME) values('name&addr');Enter value for addr: old   1: insert into t(ENAME) values('name&addr')new   1: insert into t(ENAME) values('name')
1 row created.
SQL> set define offSQL> insert into t(ENAME) values('name&addr');
1 row created.

SQL> Set define OFF;

 SQL> Select 'Tom' || chr(38) || 'Jerry' from dual;

SQL> Select 'Tom' || '&' || 'Jerry' from dual;

SQL > Select 'test' || '''' from dual;

 SQL > Select 'test ''' from dual;

SQL > Select 'It' || chr(39) || 'fine' from dual;

SQL> show parameter remote_login_passwordfile
NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------remote_login_passwordfile            string      EXCLUSIVE
SQL>  show parameter sec_case_sensitive_logonNAME                                 TYPE                              VALUE------------------------------------ --------------------------------- ------------------------------sec_case_sensitive_logon             boolean                           TRUE
SQL> select * from v$pwfile_users where username = 'SYS';
USERNAME                       SYSDB SYSOP SYSAS------------------------------ ----- ----- -----SYS                            TRUE  TRUE  FALSE-- SYSDBA 应显示“TRUE”，否则密码文件设置存在问题。

run{allocate channel ch1 type disk;allocate channel ch2 type disk;allocate channel ch3 type disk;allocate channel ch4 type disk;crosscheck backup;crosscheck archivelog all;delete noprompt backup completed  before 'sysdate-7';delete noprompt archivelog all completed before 'sysdate-5';delete noprompt expired backup;backup as compressed backupset incremental level $BAK_LEVEL format '/data/backup/inc$BAK_LEVEL-%U_%T'  skip inaccessible filesperset 8 database;sql 'alter system archive log current';backup as compressed backupset format '/data/backup/arch_%U_%T' archivelog all not backed up;backup current controlfile tag='bak_ctlfile' format='/data/backup/ctl_file_%U_%T';backup spfile tag='spfile' format='/data/backup/spfile_%U_%T';release channel ch1;release channel ch2;release channel ch3;release channel ch4;}

grid@xxxxxx-b2 /home/grid> asmcmdkgfnGetFacility: facility=1119a2c28kgfnInitDiag: diagctx=11198d4b0kgfz_getFacility: facility=1119a2c28Error 4 querying length of attr ASM_DISCOVERY_ADDRESSError 4 querying length of attr ASM_STATIC_DISCOVERY_ADDRESSError 4 opening dom grid in 111a10090kgfn_get_beqinfo: publen=85, vlen=16
ASMCMD>

/u01/app/oracle/diag/rdbms/jiekedg/jiekedg/trace/jiekedg_pr00_36109.trc:ORA-01111: name for data file 18 is unknown - rename to correct fileORA-01110: data file 18: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED'ORA-01157: cannot identify/lock data file 18 - see DBWR trace fileORA-01111: name for data file 18 is unknown - rename to correct fileORA-01110: data file 18: '/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED'

alter system set standby_file_management=auto;
alter database recover managed standby database using current logfile disconnect from session;
select file_id,file_name from dba_data_files where file_id=18;
no rows selected

--执行此命令则可实际在 datafile 目录下创建原大小的数据文件，归档日志全部都传到备库的情况下alter database create datafile '/u01/app/oracle/product/11.2.0.4/db_1/dbs/UNNAMED' as '/data/jiekexuadg/datafile/jiekexu_data18.dbf';
alter system set standby_file_management=AUTO;
--启动 MRP0 进程ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;