-
编辑 删除
oracle 10g 动态拼接sql(内含plsql过程)
select name from user_queues; select 'exec dbms_streams_adm.remove_queue(queue_name => '''||name||''''from user_queues;
-
编辑 删除
oracle streams相关启_停_删capture_apply_propagation
--check streams environmentshow parameter aq_tm_processes --2show parameter global_names --trueshow parameter job_queue_processes --10 show parameter p...
-
编辑 删除
转载如何修改oracle数据库字符集_及如何绕过超集报错
SQL> conn /as sysdba Connected. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 236...
-
编辑 删除
在sqlplus如何续行及在os提示符下如何续行
sqlplus '/as sysdba'exec dbms_streams_adm(schema_name=>'test',- - exp userid=system/system \
-
编辑 删除
在rhel5上安装oracle10g
RHEL5上安装Oracle10g Release 2 (Oracle 11gR1基本相同) 刚出Oracle10g的时候就安装过，现在早就忘了具体的东西了，重新安装一遍，记下来，留个念想～～ ：）一、安装环境我是在vmware里虚拟的RHEL5，分配的...
-
编辑 删除
oracle10g_rman_syntax testing_upgrade catalog_transport tablespace
"TRANSPORT TABLESPACE" --从备份中为一或多个表空间创建可传输表空间 Creates transportable tablespace sets from backup for one or more tablespaces. ExamplesCreating Transporable Tablespac...
-
编辑 删除
oracle10g_rman_syntac testing_set newname_switch tempfile_datafile_all_tag
"SWITCH"Specify that a datafile copy is now the current datafile, that is, the datafile pointed to by the control file. This command is equivalent to the SQL statement ALTER DATABASE RENAME FILE a...
-
编辑 删除
oracle10g_rman_语法测试_spool_sql_startup
--spool就是把rman输出信息导入到一个文件中，如此文件打不开，rman就关闭spool功能，继续执行其它命令Spooling RMAN Output to a File: Example This example directs RMAN output to standard output for the back...
-
编辑 删除
oracle10g_rman_语法测试_show专题
Keywords and ParametersSyntax ElementDescriptionALLDisplays all user-entered CONFIGURE commands as well as default configurations.ARCHIVELOG BACKUP COPIESShows the currently configured...
-
编辑 删除
oracle10g_rman_语法测试_restore专题
The primary use of RESTORE is to restore files from backups or image copies. Typically, you restore when a media failure has damaged a current datafile, control file, or archived log or prior to perfo...
-
编辑 删除
oracle10g_rman_语法测试_reset database_allocate channel_
archivelog 'filename'|primary keybackupset primarykeybackuppiece 'media_handle'|primary key|tag='tag_name'controlfilecopy 'filename'|primary key|tag='tag_name' noduplicatesdatafilecopy 后同上datafilec...
-
编辑 删除
oracle10g_rman_语法测试_10
Use this clause in the following commands:DELETEREPORTUsing both RECOVERY WINDOW and REDUNDANCY clause in a single REPORT OBSOLETE or DELETE OBSOLETE command is not supported.Keywords a...
-
编辑 删除
oracle10g_rman_语法测试_8
Keywords and ParametersSyntax ElementDescriptionKEEPOverrides any configured retention policy for this backup or copy so that the backup is not obsolete. The BACKUP ... KEEP command speci...
-
编辑 删除
oracle10g_rman_语法测试_7
Keywords and ParametersSyntax ElementDescription%aSpecifies the activation ID of the database.%cSpecifies the copy number of the backup piece within a set of duplexed backup pieces. If...
-
编辑 删除
oracle10g_rman_语法测试_7
Executing an Operating System Copy Within RMAN: Example This example shuts down the database, makes a backup of datafile system01.dbf, then executes the UNIX ls command to display all backed ...
-
编辑 删除
oracle10g_rman_语法测试_7
ExamplesFLASHBACK DATABASE to a Specific SCN: Example The following command uses Flashback Database to return the database to the specified SCN:RMAN> FLASHBACK DATABASE TO SCN 46963;---select ...
-
编辑 删除
oracle10g_rman_语法测试_6
bash-3.00$ rman target sys/system@ora10g catalog rman/system@newlyRecovery Manager: Release 10.2.0.2.0 - Production on Tue Sep 22 06:46:21 2009Copyright (c) 1982, 2005, Oracle. All rights re...
-
编辑 删除
oracle10g_rman_语法测试_5
bash-3.00$ export ORACLE_SID=newly ---rman catalog库bash-3.00$ sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.2.0 - Production on Sat Sep 19 13:18:24 2009Copyright (c) 1982, 2005, Oracle. A...
-
编辑 删除
oracle10g_rman_语法测试_4
RMAN> configure backup optimization clear;--打回原形,就是恢复默认old RMAN configuration parameters:CONFIGURE BACKUP OPTIMIZATION ON;RMAN configuration parameters are successfully reset to default ...
-
编辑 删除
oracle10g_rman_语法测试_3
--恢复数据文件2的块12,13,你可以指定多少数据文件BLOCKRECOVER DATAFILE 2 BLOCK 12, 13 DATAFILE 3 BLOCK 5, 98, 99 DATAFILE 4 BLOCK 19;---恢复数据文件多个块,表空间多个块(tablespace多个块,以dba为标记)R...
