-
编辑 删除
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...
-
编辑 删除
oracle10g_rman_语法测试_2
--ALLOCATE CHANNEL FOR MAINTENANCE--用于change,delete,crosscheck限制:1,仅用于rman提示符下,不能用于run中2,数据库必须打开3,不能指定通道id4,不能分配通道到一个共享会话5,手工分配通道(维护与正常)不能与...
-
编辑 删除
oracle10g_rman_语法测试_1
rman target / @/oracle/backup_db.rman --外部执行命令脚本RMAN> @/oracle/backup_db.rman --内部执行命令脚本---下列测试学习@@,其实就是@中再...
-
编辑 删除
oracle10g_impdp工具测试学习_之三_remap相关
expdp system/system schemas=newtbs dumpfile=dir:export_user_newtbs.dmp---注意：如果newtbs2用户不存在，imp job 会自动为你建立impdp system/system dumpfile=dir:export_user_newtbs.dmp remap_schema=newtbs:...
-
编辑 删除
oracle10g_备份控制文件_得到重建控制文件的脚本
sqlplus "/as sysdba"show parameter useralter database backup controlfile to trace;exit;到user目录下提取控制文件的相关脚本 重建控制文件sqlplus '/as sysdba'shutdown immediatestartup nomount--运行提取控...
-
编辑 删除
oracle10g_impdp工具测试学习_之二_transport_tablespaces
http://www.itpub.net/thread-988734-1-1.html --传输表空间遇到"ORA-00721: 发行版"问题http://yumianfeilong.com/html/2008/09/25/229.html --compatible的注明转下eygle大师的expdp transport_tables...
-
编辑 删除
oracle10g_impdp工具测试学习_之一
--users,sysaux,temp,sysaux表空间不能删除-bash-3.00$ impdp system/system dumpfile=other:expdp_full_db.dmp full=yImport: Release 10.2.0.2.0 - Production on Monday, 14 September, 2009 11:26:15Copyrig...
-
编辑 删除
oracle10g_alter table_测试3
SQL> SQL> SQL> show userUSER is "TBS_02"SQL> conn /as sysdbaConnected.SQL> select username from dba_users;USERNAME------------------------------TBS_02FS1ZXYSCOTTTESTAUDIT_TESTTSMSYSMDDATADIPMDSYSORDSY...
-
编辑 删除
oracle10g_create tablespace_测试_2
SQL> alter system set db_cache_size=10m scope=spfile;---为了创建非标准块大小的表空间,必配置的参数System altered.SQL> alter system set db_2k_cache_size=5m scope=spfile;--同上System altered.SQL> startup...
-
编辑 删除
oracle10g_create tablespace_测试_1
SQL> create user test identified by system account unlock;User created.SQL> grant resource,connect to test;Grant succeeded.SQL> create tablespace test datafile '/oracle/db/test01.dbf' size 10m;Tablesp...
-
编辑 删除
oracle10g_expdp工具测试学习_之一
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 <style.st1\:*{behavior.:url(#ieooui) }</...
-
编辑 删除
solaris 10_利用date修改主机时间
root@gxaaa3 # man dateReformatting page. Please Wait... doneUser Commands ...
