My First Db activit ! Can someone verify

rzr

rzr

Member
Hello DBA's.... this is the first time i'm trying my hand at dba activity.... here's what I set out to do.... take an online backup of sports database....

1. I started a server for Sports db... for multi-user mode connection
proenv>proserve C:\Workdesk\Database\Sports\Sports.db
OpenEdge Release 10.2A as of Mon Nov 3 22:05:01 EST 2008
16:00:59 BROKER This broker will terminate when session ends. (5405)
16:00:59 BROKER 0: Multi-user session begin. (333)
16:00:59 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
16:00:59 BROKER 0: Physical Redo Phase Completed at blk 2 off 6254 upd 87. (7161)
16:00:59 BROKER 0: At end of Physical redo, transaction table size is 8. (13547)
proenv>
Click to expand...
2. Then Before I began my online backup, I checked if the Db was being used or not
proenv>proutil C:\Workdesk\Database\Sports\Sports.db -C BUSY
OpenEdge Release 10.2A as of Mon Nov 3 22:05:01 EST 2008
** The database C:\Workdesk\Database\Sports\Sports is in use in multi-user mode. (276)
proenv>
​
Click to expand...
3. Then I executed the probkup online command to start my backup.
proenv>probkup online C:\Workdesk\Database\Sports\Sports.db C:\Workdesk\Database\Sports\Backup\03March2011SportsRZR -verbose -com
OpenEdge Release 10.2A as of Mon Nov 3 22:05:01 EST 2008
1002 active blocks out of 1018 blocks in C:\Workdesk\Database\Sports\Sports will be dumped. (6686)
256 BI blocks will be dumped. (6688)
Backup requires an estimated 5.9 MBytes of media. (9285)
Restore would require an estimated 1518 db blocks using 1.5K of media. (9286)
Backed up 1258 db blocks in 00:00:00
Wrote a total of 20 backup blocks using 2.7 MBytes of media. (13625)
Backup complete. (3740)

proenv>
​
Click to expand...
4. I can see that the backup file 03March2011SportsRZR was created correctly.

5. Can the expert's :) please confirm if these steps i did were correct or are there any other steps/things i should take a note of ??

thanks very much !!
 
Checking if the database is in use seems rather unnecessary. The whole point of making an online backup is so that the database can keep on running and transactions can be made while creating a backup. The rest looks fine. But if it is a production database in stead of a little test to see if you can create an online backup, there are many other things to consider when starting a database.
 
So, if it is production Db and assuming it is already up with users working on it and I want to take online backup - the last step is sufficient ? Are there any other check i need to do before taking online backup or should i add any other flags to the probkup command ??
 
The command you give is enough to make a online backup. I don't use the -verbose, I only use the -com flag.
 
You must log in or register to reply here.
Back
Top