本繁體中文版使用機器翻譯,譯文僅供參考,若與英文版本牴觸,應以英文版本為準。
使用「SMO設定檔驗證」命令
貢獻者
建議變更
您可以執行設定檔驗證命令來驗證設定檔的設定。您必須先掛載資料庫、才能執行此命令。
語法
smo profile verify -profile profile_name \[-quiet \| -verbose\]
參數
-
設定檔
指定要驗證的設定檔。設定檔包含資料庫和其他資料庫資訊的識別碼。
-
-無聲
僅在主控台顯示錯誤訊息。預設為顯示錯誤和警告訊息。
-
-詳細
在主控台顯示錯誤、警告和資訊訊息。
範例
下列範例驗證設定檔:
smo profile verify -profile profileA -verbose [ INFO] SMO-13505: SnapDrive environment verification passed. [ INFO] SMO-13507: JDBC verification for "OS authenticated: NEWDB/hostA.rtp.com" passed. [ INFO] SMO-13506: SQLPlus verification for database SID "NEWDB" passed. Environment: [ORACLE_HOME=E:\app\Administrator\product\11.2.0\dbhome_1] [ INFO] SMO-07431: Saving starting state of the database: Database[NEWDB(OPEN)], Service[RUNNING]. [ INFO] SMO-07431: Saving starting state of the database: Database[NEWDB(OPEN)], Service[RUNNING]. [ INFO] SD-00016: Discovering storage resources for F:\. [ INFO] SD-00017: Finished storage discovery for F:\. [ INFO] SD-00016: Discovering storage resources for F:\. [ INFO] SD-00017: Finished storage discovery for F:\. [ INFO] SD-00016: Discovering storage resources for H:\. [ INFO] SD-00017: Finished storage discovery for H:\. [ INFO] SD-00016: Discovering storage resources for G:\. [ INFO] SD-00017: Finished storage discovery for G:\. [ INFO] SD-00016: Discovering storage resources for I:\. [ INFO] SD-00017: Finished storage discovery for I:\. [ WARN] SMO-05071: Database profile HADLEY is not eligible for fast restore: Restore Plan: Preview: The following components will be restored completely via: host side file copy restore F:\NEWDB\SYSAUX01.DBF F:\NEWDB\SYSTEM01.DBF F:\NEWDB\UNDOTBS01.DBF F:\NEWDB\USERS01.DBF Analysis: The following reasons prevent certain components from being restored completely via: storage side file system restore * Files in file system F:\ not part of the restore scope will be reverted. Components not in restore scope: F:\_TESTCLN\CONTROL01.CTL F:\_TESTCLN\REDO_1.LOG F:\_TESTCLN\REDO_2.LOG F:\_TESTCLN\REDO_3.LOG Components to restore: F:\NEWDB\SYSAUX01.DBF F:\NEWDB\SYSTEM01.DBF F:\NEWDB\UNDOTBS01.DBF F:\NEWDB\USERS01.DBF * Reasons denoted with an asterisk (*) are overridable. [ INFO] SMO-07433: Returning the database to its initial state: Database [NEWDB(OPEN)], Service[RUNNING]. [ INFO] SMO-13048: Profile Verify Operation Status: SUCCESS [ INFO] SMO-13049: Elapsed Time: 0:19:06.949 Operation Id [N5bc18bd5c3be27a795ce3857093a926a] succeeded.
相關資訊