Get-OracleSnapshotTime

NAME Get-OracleSnapshotTime



SYNOPSIS

Query an Oracle database to get the an AWR Snapshot Timestamp, based on Snapshot and DB IDs.





SYNTAX

Get-OracleSnapshotTime [-TargetDB] <String> [[-DBUser] <String>] [-PasswordPrompt] [-DBID] <BigInteger>

[-Snapshot] <BigInteger> [-Mark] <String> [-ErrorLog] [[-ErrorLogFile] <String>] [<CommonParameters>]





DESCRIPTION

This function returns an AWR Snapshot Timestamp, based on Snapshot and DB IDs.





PARAMETERS

-TargetDB <String>

This can be a list of databases



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-DBUser <String>

Username if required



Required? false

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-PasswordPrompt [<SwitchParameter>]

Flag to ask for a password



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-DBID <BigInteger>

This can be a list of databases



Required? true

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Snapshot <BigInteger>

This is the snapshot to use to query the time



Required? true

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Mark <String>

Mark that defines if the snapshot is upper or lower boundary to the analysis



Required? true

Position? 5

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ErrorLog [<SwitchParameter>]

Switch to turn on the error logging



Required? false

Position? named

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-ErrorLogFile <String>



Required? false

Position? 6

Default value "$env:TEMP\\OracleUtils_Errors_$PID.log"

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>Get-OracleSanpshot -TargetDB myorcl -SnapshotID 1234 -DBID 567890123















RELATED LINKS