Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL Backtrack v4.00 for Oracle; Issues With Listing of Backups

SQL Backtrack v4.00 for Oracle; Issues With Listing of Backups

From: SAP BASIS Consultant <basis_consultant_at_hotmail.com>
Date: 18 Nov 2004 13:13:05 -0800
Message-ID: <dd2036f3.0411181313.65c7ed08@posting.google.com>


Hello,

I created a few successful online backups, and 2 successful cold backups, for a database using SQL Backtrack. The cold backup was taken today (Nov 18), and the online backups on Nov. 16 and Nov. 17.

However, when I try to restore my cold backups, they are not listed as 'previous database incarnations'. However, it seems like SQL Backtrack is asking for a data close to the cold backup, and not one associated with the online backup. (Unless it chooses the online and restores with the logs)..

Why would Backtrack not list the cold backups as database invocations, and ask for a Nov. 18 date range for restoring a Nov. 16 online backup?   

Thanks,
DF


   OBACKTRACK Database File Restore Menu

  1. Restore selected database files
  2. Perform a time-based recovery
  3. Perform a change-based recovery
  4. Perform a recovery from a retained backup

 Choose: 1-4 [c=cancel, q=quit, ?=help]
OBACKTRACK> 2    Select database incarnation

  1. Incarnation 1 - created on 11/15/2004 07:42:23
  2. Incarnation 2 - created on 11/16/2004 13:08:39
  3. Incarnation 3 - created on 11/16/2004 13:49:21

 Choose: 1-3 [c=cancel, q=quit, ?=help]
OBACKTRACK> 3
Enter a date between '11/18/2004 09:29:32' and '11/18/2004 13:57:34': Enter time to recover to. Use the following format: %m/%d/%y %H:%M:%S : Received on Thu Nov 18 2004 - 15:13:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US