- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Reduced oracle datafile sizes after remote restora...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2003 11:09 PM
тАО10-26-2003 11:09 PM
Reduced oracle datafile sizes after remote restoration with sapdba
When i remotely restored my database files into a new system using sapdba tools i noticed that all restored file sizes was less than the actual.
for example,
/oracle/YP1/sapdata1/system_1/system.data1 had a size 157286400 Bytes it became 12293120 Bytes.
/oracle/YP1/sapdata6/es30fd_1/es30fd.data1 had a size 2013265920 Bytes it became 157291520 Bytes
For your information the source backup was done locally while the restoration was remotely.
Anybody knows how to resolve this,
With best regards,
Ashraf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 01:07 AM
тАО10-27-2003 01:07 AM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
The sapdba tool may have simply reclaimed unused space during the restore.
I would question the sap supplier or check your documentation.
But if the restored system behaves as expected then I think you're ok.
If you're really paranoid then you can query the data dictionary to see that the objects in the restored file are what they should be.
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 01:17 AM
тАО10-27-2003 01:17 AM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
If the SAPtools did not gave errors I would not be very paranoid.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 11:51 AM
тАО10-27-2003 11:51 AM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
I would recommend performing an "alter database datafile
Thanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 05:51 PM
тАО10-27-2003 05:51 PM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
Actually Oracle didn't start because of this and it gave the following error:
ORA-00201: control file version 7.3.3.0.0 incompatible with ORACLE version 7.0.1.2.0.0
ORA-00202: control file: '/oracle/YP1/sapdata1/cntrl/cntrlYP1.dbf'
Even though that control file as well as all restored file sizes was different.
For you infromation sapdba tool is using dd command to backup the datafile.
Does any body suspect that dd had performed file size conversion during restore.
Appreciate your assistance,
Regards,
Ashraf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 07:11 PM
тАО10-27-2003 07:11 PM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
most likely, you have a version missmatch.
Looks like your Source System runs Oracle 7.3.3 and the system where you restored has Oracle 7.0 installed.
Now this suspects, that the SAP version does not match as well, in this case esp. the brrestore has to match the version of brbackup. In addition, the parameters of the backup/restore parameter file initYP1.sap have to match, otherwise you can get strange rearangements upon restore.
Tape format of a brbackup tape is
.tape.hdr0 -> cpio file (-> Blocksize from initYP1.sap)
Set of Parameter files -> cpio-fileset
datafile1 -> dd/cpio, depending on initYP1.sap
...
all datafiles as seperate set
logfiles -> cpio format
Now dd does not store the filenames to the tape, instead you need to have the logfile of the correct (!) backup belonging to the tape.
So your problem is either
a) you have an old logfile that you use for your restore-> thus the files simply get mixed up. Solution: restore the logs from the tapes first.
b) block-param mismatch in initYP1.sap with incompatible versions in addition (I think in older versions, initSID.sap and initSID.ora where saved as seperate filesets at the beginning of the tape). -> thus to a mismatch of the filesets at the beginning of the tape, your restored files are restored to the wrong filename.
Lastly:
- SAP 3.0F
- Oracle 7.0
- Oracle 7.3.3
are beyond support for quite a while now.
Hope this helps
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 07:52 PM
тАО10-27-2003 07:52 PM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
Volker:
The source system that i backed the information from had the following:
Operating system: hp-ux 10.20.
Database was oracle 7.3.4.3.0
Sap System: 3.0f
Sap kernel: 3.1i
The target system that i restored the database to has the following:
Operating system: hp-ux 11.0 (64-bit).
Database was oracle 7.3.4.1.0
Sap System: 3.0f
Sap kernel: 3.1i
However, the backup was done locally from the source machine while the restoration was remotely to the new machine.
All i done was installing sap 3.0f into the target machine with default configuration and tablesapces. Then i restored data through sapdba.
So There are no version mismatch either in SAP or oracle.
Do i need to alter tablespaces to match the source existing tablespaces before restoring the data.
Appreciate your time,
Regards,
Ashraf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2003 08:37 PM
тАО10-27-2003 08:37 PM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
in this case (asuming you used brbackup target "disk_copy") it is most likely, that you have diffret locations of the controlfiles on both machines.
(May be you can describe a little bit more detailed, what exactly you did do)
While on source they might reside in
/oracle/YP1/origlogA/cntrl
/oracle/YP1/saparch/cntrl
/oracle/YP1/sapdata1/cntrl
--> which is a proper setup
They might be located on target
/oracle/YP1/sapdata1/cntrl
/oracle/YP1/sapdata2/cntrl
/oracle/YP1/sapdata3/cntrl
-- and have diffrent names as well.
Check this in the initYP1.ora file parameter
CONTROL_FILES=(...)
on both machines.
Since your message is complaining that a version 7.0 controlfile is found, something has to be wrong.
Other question: I never knew that 7.3 was supported to run on 64-bit. Are you sure this system has ever been operatable before ?
Or did you just do an OS-Upgrade to 64-bit ?
So beside the point of a may be neccessary 64-bit migration of the database, you will need to run catalog.sql and catproc.sql after you are able to open the database to downgrade to your taget release 7.3.4.1.
Good Luck
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-05-2003 11:21 PM
тАО12-05-2003 11:21 PM
Re: Reduced oracle datafile sizes after remote restoration with sapdba
i copied all datafiles using fbackup and it is working fine. Then, I upgraded my sapdba program to the latest version.
Regards,
Ashraf