PrepAway - Latest Free Exam Questions & Answers

Which two commands could be used to resolve this error?

Because of an application abend, a database named PAYROLL needs to be restored to approximately
9:26 am on June 1, 2009. After the database is restored from a backup image, the command shown
below is executed:
ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP
When this command is executed, the error shown below is generated:
SQL4970N Roll-forward recovery on database “PAYROLL” cannot reach the specified stop point (endof-log or point-in-time) because of missing log file(s) on node(s) “0”. Which two commands could be
used to resolve this error? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
ROLLFORWARD DATABASE payroll TO END OF LOGS AND STOP

B.
ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP

C.
ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING LOCAL TIME AND STOP
OVERFLOW LOG PATH /mnt/arclog

D.
ROLLFORWARD DATABASE payroll TO 2009-06-01-09.26.44.609002 USING UTC TIME AND STOP
NORETRIEVE MISSING RECORDS


Leave a Reply