cancel
Showing results for 
Search instead for 
Did you mean: 

Restore system.data1 with other size

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

lbreddemann
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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