on 09-17-2010 4:18 PM
Dear gurus,
Landscape: Win 2003 64bit + Oracle 10.2.0.4 + BW 3.5 + BRTOOLS + LTO2 (4 tapes) + Storage EMC on SAN arquitecture
Backup:
command: brbackup -p initBWP.sap -d tape -v BWPB011,BWPB022,BWPB033,BWPB044 -t offline_force -m all -k hardware -e 4
Status backup is success
Restore:
command: brrestore -b beebuyip.aft -m full
Status restore is success
Problem:
To end restore, the datafile system.data1 have different size, original size is 4GB and final size is 2GB.
Other datafiles from 1GB to 10GB were restored ok.
DBV file=system.data1 size=8192 is ok.
was recommended to uninstall the antivirus too.
No error in alertBWP.log
When looking at the size of the files while running the restore, its size grows up to 4 GB (windows explorer), however, when the process is finish changes its size to 2GB.
I'm lost.
Thanks for your cooperation and my bad English.
Best regards
Alberto Erazo
Hi Alberto,
There is no issue with the backup as well as the restore. Try to open the database after recovering.
Proceed as follows,
Login to the server with the user <SID>ADM
open a command prompt
Execute:
sqlplus /nolog;
connect /as sysdba;
startup mount;
recover database;
alter database open;
shutdown immediate;
startup;
If u r able to open the database, then ur restore is 100% complete.
Good Luck!!!
Regards,
Varadharajan M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My friend,
Database is in inconsistent state, then starts to recover other datafiles.
Backup and restore to disk (option "disk") works perfectly. however, for the option to tape
this fails, will the application "dd"?
We perform backup and restore yesterday with BRTOOLS and "DISK" option:
brbackup -p initBWP.dsk -d disk -t offline_force -m all -e 10.
This Backup and Restores ok, and instance SAP start up ok.
Command "DD" will be problem to Restore from TAPE media?
thanks
Alberto
Depends what you have configured in your init<SID>.sap file. Default value for tape backup is cpio.
follow http://help.sap.com/saphelp_nw70ehp1/helpdata/en/c7/c90e6b7cfd44309bd90b2b7a8a89fd/content.htm
Hi Alberto,
> Restore:
> command: brrestore -b beebuyip.aft -m full
> Status restore is success
Would you mind to stop using BRRESTORE and start using BRRECOVER?
BRRESTORE really shouldn't be used directly.
BRRECOVER does so much more "thinking" for you...
But this is not the problem here.
> Problem:
> To end restore, the datafile system.data1 have different size, original size is 4GB and final size is 2GB.
> Other datafiles from 1GB to 10GB were restored ok.
Where did you look up the original file size?
Windows Explorer as well?
What does dba_data_files say about the file size?
Are you using NTFS compression (not supported!) on this file?
> DBV file=system.data1 size=8192 is ok.
> was recommended to uninstall the antivirus too.
> No error in alertBWP.log
Can you startup the database with this system tablespace file?
>> When looking at the size of the files while running the restore, its size grows up to 4 GB (windows explorer), however, when the process is finish changes its size to 2GB.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Lars,
Would you mind to stop using BRRESTORE and start using BRRECOVER?
I need restored backup into other server and validate the consistency of the backup, no recovery.
Where did you look up the original file size?
Windows Explorer as well?
yes, windows explorer, oracle, dba_datafiles
What does dba_data_files say about the file size?
show: dba_datafile:
Filename File Id Status Enabled SCN last Checkpoint Size (KBytes) KBytes Created
SYSTEM.DATA1 1 SYSTEM READ WRITE 1993752569 4096000 2048000
BWP.DATA7 10 ONLINE READ WRITE 1993672138 10240000 10240000
...
...
...
Datafile was created with 2GB and after resize not add to datafile....be the problem?
Are you using NTFS compression (not supported!) on this file?
No
Can you startup the database with this system tablespace file?
No, enter to recovery status.
Best regards,
Alberto
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.