Previous Topic: Partial Restore to a Different DirectoryNext Topic: Best Practices


Using BACKINT Command Line for Querying Backup Information

You can use the BACKINT command line to query backup information.

To query backup information using BACKINT command line

  1. Query all backed up information using a BACKINT call. The call requires no further specifications. The input file must contain the entry ‘#NULL’ and optionally the ‘-o’ switch.
    backint -u <SID> -f inquire -t file -p <util_profile> -i <input_file> [-o <output_file>]
    

    SID: Oracle SID

    util_profile: util file init<SID>.utl path

    input file: the input file which context must contain an entry ‘#NULL’

    For example:

    backint -u CER -f inquire -t file -p “F:\oracle\product\10.2.0\db_1\database\initcer.utl” -i “c:\input.txt” [-o “c:\output.txt” ]
    
  2. Query all backed up information using a BACKINT call. You must specify the backup_id. The input file must contain the entry ‘<backup_id>’ and optionally the ‘-o’ switch.
    backint -u <SID> -f inquire -t file -p <util_profile> -i <input_file> [-o <output_file>]
    
  3. Query all backed up information using a BACKINT call. You must specify a value for file_name. The input file must contain the entry ‘#NULL <backup_id>’ and optionally the ‘-o’ switch.
    backint -u <SID> -f inquire -t file -p <util_profile> -i <input_file> [-o <output_file>]
    
  4. Query all backed up information using a BACKINT call. You must specify a value for backup_id and file_name. The input file must contain values that are similar to ‘<backup_id_1><file_name_1>', ’<backup_id_2><file_name_2>', or both, and optionally the ‘-o’ switch.
    backint -u <SID> -f inquire -t file -p <util_profile> -i <input_file> [-o <output_file>]