|
Home > Archive > ASE Database forum > October 2005 > Load Database Messages...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Load Database Messages...
|
|
| Darwin Louie I. Altar 2005-10-27, 8:21 am |
| Dear All,
Im loading a database to our production server when at the
end of
the process this message appeared:
"Backup Server: 3.42.1.1: LOAD is complete (database
conlive).
Caution: You have set up this database to include space on
disk 10 for both
data and the transaction log. This can make recovery
impossible if that disk
fails.
Caution: You have set up this database to include space on
disk 11 for both
data and the transaction log. This can make recovery
impossible if that disk
fails.
All dumped pages have been loaded. SQL Server is now
clearing pages above page
640000, which were not present in the database just loaded.
SQL Server has finished clearing database pages.
Redo pass: 6000 records done (6%); 88111 records left.
Redo pass: 12000 records done (12%); 82111 records left.
Redo pass: 18000 records done (19%); 76111 records left.
Redo pass: 24000 records done (25%); 70111 records left.
Redo pass: 30000 records done (31%); 64111 records left.
Redo pass: 36000 records done (38%); 58111 records left.
Redo pass: 42000 records done (44%); 52111 records left.
Redo pass: 48004 records done (51%); 46107 records left.
Redo pass: 54004 records done (57%); 40107 records left.
Redo pass: 60004 records done (63%); 34107 records left.
Redo pass: 66004 records done (70%); 28107 records left.
Redo pass: 72004 records done (76%); 22107 records left.
Redo pass: 78004 records done (82%); 16107 records left.
Redo pass: 84004 records done (89%); 10107 records left.
Redo pass: 90004 records done (95%); 4107 records left.
Redo pass of recovery has processed 46 committed and 1
aborted transactions."
I would like to know the common reason why this REDO pass
appears and how does this affect the result of load database
process?
Thanks.
God Bless!!
| |
| Jayadeva 2005-10-27, 8:21 am |
| Hi,
It's not an error,
The ASE will remove the uncommited data (or transactions)
while loading the dump that is called as rollbackward (UNDO
PASS)
And the commited data will be rollforward which is called as
a REDO PASS.
This is because after loading the dump the ASE will check
the transaction log (syslogs table) and the data pages.
Regards,
-Jayadeva.
krjayadeva@gmail.com
> Dear All,
> Im loading a database to our production server when at the
> end of
> the process this message appeared:
>
> "Backup Server: 3.42.1.1: LOAD is complete (database
> conlive).
> Caution: You have set up this database to include space
> on disk 10 for both
> data and the transaction log. This can make recovery
> impossible if that disk
> fails.
> Caution: You have set up this database to include space
> on disk 11 for both
> data and the transaction log. This can make recovery
> impossible if that disk
> fails.
> All dumped pages have been loaded. SQL Server is now
> clearing pages above page
> 640000, which were not present in the database just
> loaded. SQL Server has finished clearing database pages.
> Redo pass: 6000 records done (6%); 88111 records left.
> Redo pass: 12000 records done (12%); 82111 records left.
> Redo pass: 18000 records done (19%); 76111 records left.
> Redo pass: 24000 records done (25%); 70111 records left.
> Redo pass: 30000 records done (31%); 64111 records left.
> Redo pass: 36000 records done (38%); 58111 records left.
> Redo pass: 42000 records done (44%); 52111 records left.
> Redo pass: 48004 records done (51%); 46107 records left.
> Redo pass: 54004 records done (57%); 40107 records left.
> Redo pass: 60004 records done (63%); 34107 records left.
> Redo pass: 66004 records done (70%); 28107 records left.
> Redo pass: 72004 records done (76%); 22107 records left.
> Redo pass: 78004 records done (82%); 16107 records left.
> Redo pass: 84004 records done (89%); 10107 records left.
> Redo pass: 90004 records done (95%); 4107 records left.
> Redo pass of recovery has processed 46 committed and 1
> aborted transactions."
>
> I would like to know the common reason why this REDO pass
> appears and how does this affect the result of load
> database process?
>
> Thanks.
> God Bless!!
|
|
|
|
|