on 03-23-2009 6:49 PM
Hi All,
1.I have to do system reeboot.
My OS is HP_UX.
I tried to find from the manual. I login via root,then I typed man shutdown but couldnt get it in the documentation.Please help me.
2.In HP_UX OS where to see the backup logs at OS level..?My system is down and at that time
online backup was happening.I think some of the table might get locked and I might need to run recover database command after loging via sqlplus.Please suggest.
3. For 1 particular client I have to to BD recovery. DB is SQL2005. I want to know do I need to run any database command after the restore.
Any help will be highly appreciated.
Regards,
Hi,
1. To shut down and reboot an HP-UX system, use the shutdown -r command
2. your backup would have failed but there is absolutely no need for running any commands for recovery
3. What is BD?
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot Rohit.
My mistake. Actually I have to do database recovery of SQL 2005 server for a particular cleint.
I need to know do I have to run any of the SQL database command after this.
Also as per I know my database sytem would have got hanged as my online backup has terminated so do I need to run recover database command.
Also where in HP_UX I can see the backup logs at OS level.
Regards,
No we take backup via HP Data Protector.And once in HP Dataprotector when I checked it says backup copmlete with RC = '0'.
But later on we find via DB12 that it actually failed.
Today we cannot login to SAP as our system is down while backup was happening and I am not sure whether it happens or not.In HP DP it says its done,but I want to check the log at OS level.
Please help.
Regards,
No Joe,I am sorry I think I didnt write my question well.
For your clarification.
1. I was asking how to ckeck backup log at OS level in HP_UX.We haev HP_UX with Oracle database.
2. My next question was that for particular client I have to to a restore.They have SQL2005 on windows 2003 OS.Now my quesiom was do I need to run some database command after a restore.
Sorry again for the confusion I created.
Regards,
I'm afraid I still don't fully understand ...
And I don't know, if or how HP Data Protector is interacting with SAP's brbackup.
The backups you can see in DB12 usually have logfiles; the full path of sapbackup directory usually is /oracle/<SID>/sapbackup. (That's what was in my previous answer, before editing.) So look for logiles there! And it doesn't matter whether or not sapbackup is a mount point.
And as for restoring SQL2005 on windows 2003, I suggest you either look for the MSSQL restore manuals (I don't know where they are, btw) or start a separate thread.
regards
Hi
Please check the following links:
1. http://www.oracle-base.com/articles/misc/OSBackupCommands.php
2. http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/glossary.htm
3. http://cs.scu.edu.cn/~zuojie/oracle/server.101/b10734/rcmconc3.htm
I hope it helps you
Regards
Chen
Hi Joe
I would also suggest you to start a new thread for SQL server 2005 restore
My team has just finished doing the system refresh of ERP,BI and SRM systems in SQL server 2005,so I hope I will be able to help you in detail on this
Also please refer to SAP Notes 193816 and 151603
These will be damn useful when you plan to start with restore
Rohit
Hello Joe
Please refer to rules:
"Only One Question Per Posting
For each question that you have, make a separate posting. Don't ask multiple questions in one posting, this is confusing for people and might not get answered, since the subject line does not reflect all your problems. If a new and unrelated question comes up during a thread, start a new thread.
"
moreover this sql restore will be better answered if it is in Database and OS platforms
and this is just a suggestion
Rohit
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.