CommVault 对于oracle IDA备份 对应SQL 脚本
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
1: 实例初始化：
2248 a7c 04/13 23:33:15 ### ::RecvOraParams() - Client Received:Client Name=[192.168.100.11] OraHome=[E:\oracle\product\10.2.0\db_1] SID=[CVDB1] oraUser=[administrator] OraName=[/] OraService=[] TnsAdmin=[] PFilePath=[] LogFilePath=[] Status=[32357744].
2248 a7c 04/13 23:33:15 ### ::RecvOraParams() - Client Received: DomainNT=[Win64-1]
2248 a7c 04/13 23:33:15 ### ::PreBrowse() - LogonUserW() for oraUser=[administrator] ntDomain=[Win64-1] ...
2248 a7c 04/13 23:33:15 ### ::SendMsgToOA() - To Ora Agent msgType=ORA_MSG_BROWSE_START 2248 a7c 04/13 23:33:15 ### ::RunBrowse() - new ClOraInfo
2248 a7c 04/13 23:33:15 ### ::BrowseInit()- Initialize0(oraUser[administrator] oraHome=[E:\oracle\product\10.2.0\db_1] oraSID=[CVDB1])
23:33:15 ### ::FillNTEnv() - SETENVIRONMENTVARIABLE(ORACLE_HOME=E:\oracle\product\10.2.0\db_1)
2248 a7c 04/13 23:33:15 ### ::FillNTEnv() - SETENVIRONMENTVARIABLE(ORACLE_SID=CVDB1)
2248 a7c 04/13 23:33:15 ### ::FillNTEnv() - SETENVIRONMENTVARIABLE(NLS_LANG=American_7ASCII)
2248 a7c 04/13 23:33:15 ### ::RunBrowse() - GetInfo(oraObjNameList=[B I]
2：实例配置属性：
sql query = SELECT decode(STATUS,'STARTED','2','MOUNTED','3','OPEN','5','0') FROM v$instance;
SQL> SQL> SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
D
-
5
sql query = SELECT INSTANCE_NAME from V$INSTANCE;
SQL> SQL> SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
INSTANCE_NAME
----------------
cvdb1
sql query = SELECT VERSION from V$INSTANCE;
SQL> SQL> SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
VERSION
-----------------
10.2.0.1.0
sql query = SELECT DATABASE_ROLE from V$DATABASE;
SQL> SQL> SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
DATABASE_ROLE
----------------
PRIMARY
Sql query = SELECT 'B,',TO_CHAR(b.DBID),',',TRIM(' ' FROM ),',',TRIM(' ' FROM b.LOG_MODE),',',TRIM(' ' FROM b.OPEN_MODE),',',TO_CHAR(b.CHECKPOINT_CHANGE#) FROM v$database b;
SQL> SQL> SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
'B TO_CHAR(B.DBID) ' TRIM(''FR ' TRIM(''FROMB ' TRIM(''FRO ' TO_CHAR(B.CHECKPOINT_CHANGE#)
-- ---------------------------------------- - --------- - ------------ - ---------- - ----------------------------------------
B, 1371490991 , CVDB1 , ARCHIVELOG , READ WRITE , 4719770
sql query = SELECT 'I,',TO_CHAR(ins.INSTANCE_NUMBER), ',',TRIM(' ' FROM ins.INSTANCE_NAME), ',',TRIM(' ' FROM ins.HOST_NAME),',',TRIM(' ' FROM ins.PARALLEL),',',TO_CHAR(ins.THREAD#) FROM v$instance ins;
SQL> SQL> SQL> SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> SQL>
'I TO_CHAR(INS.INSTANCE_NUMBER) ' TRIM(''FROMINS.I ' TRIM(''FROMINS.HOST_NAME) ' TRI ' TO_CHAR(INS.THREAD#)
-- ---------------------------------------- - ---------------- - ---------------------------------------------------------------- - --- - I, 1 , cvdb1 , WIN64-1 , NO , 1
3：子客户端配置属性：