Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script to apply pending logs Expand / Collapse
Author
Message
Posted Monday, March 17, 2008 6:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 11:24 PM
Points: 169, Visits: 419
I am looking at the backupset view/table ; My aim is to regenerate the SQL statements to apply the archivelogs at the STANDBY; The name column is showing blank. How do i find the name of the file; Order by first_lsn gets me the required order.

TIA
Post #470584
Posted Thursday, March 20, 2008 4:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
TIA.

1) I think you are posting an oracle database question in sql server world :P
2) This is not a fundemental question..:)

Reshadit@hotmail.com
Post #472627
Posted Thursday, March 20, 2008 4:47 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 11:24 PM
Points: 169, Visits: 419
It does not matter if this is Oracle or Sybase related. The question is how to get the answer.
Post #472628
Posted Thursday, March 20, 2008 10:22 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 11:06 PM
Points: 3,109, Visits: 11,514
If you want help with a query, it would help if you posted the actual code of the query.

Post #472670
Posted Sunday, March 23, 2008 12:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 11, 2014 2:59 PM
Points: 46, Visits: 188
GK,

With all do respect it definetly matters. It matters on how successful you will be in searching for your answer. What I meant by my post was if you have oracle or sybase the chance of you getting the answer you need is not probable.

Again,

1) You are on a SQL Server microsoft realated which does the same things but differently.
2) This is not a fundamental question, it would be a slight more difficult question.

To help you get your answer that you are looking for(Which I presume since you have not recieved a posting) I would first and upmost find an oracle or sybase forum (Perhaps even a diverse forum for all databases. This will increase your chances of finding your 'answer'.

Thanks,

ReshadIT@hotmail.com
Post #473287
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse