Hi,
I do this a lot, and its usually because I forgot to check the user settings for the sidadm, or orasid users. specifically core, stack, data segment etc as defined in the o/s dependencies guide for your product.
Hi,
I have a service that has log-on as a specific user properties. This is stopped using net stop, so that it doesnt conflict with backup operations, and net started after the backup scripts run.
What we se is that the service fails to start due to a log-on failure. What we do to fix it (and...
SAP gets its time from the underlying database user I think.
I might be wrong, but I remember in the dim and distant past that UNIX runs on coordinated universal time, calculates the time based on the number of seconds its been since 1/1/1970 given the date and the time zone you're in, and...
I guess by now you've had an answer from another source, but fwiw, yes there's an order to things. Typically your developmnt/implementation crew dont put a lot of emphasis on this and it'll cause the occasional wild goose chase.
I'm guessing you asked this question because you have had...
Thanks,
my problem was that all recent backups had been damaged by faulty tape drive, and subsequent restores had trashed the transaction log files. Taking the database offline, then renaming the data files allowed deletion of the database while not losing the original data files, followed by...
Hi,
problem is: transaction log files deleted.
: Database data files intact
thus database is 'suspect'
ANyone know how to recover from this situation - we dont care what was in the transaction log, just want the database back.
tia.
Hi,
I have a (perhaps) similar problem ... I have my database files intact on disk, but the transaction log files have been deleted. The database opens in status 'suspect' ... is there any way I can 'use' my known good database files to re-constitute my database?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.