Need help to backup
Need help to backup
Hello all, I need help to backup Vision Database 11.5.10.2. I followed the document v1.9 I got from this forum but stuck at the very first step (
After login as oracle user, set the environment and start sqlplus I stuck in step:
Enter user-name: sys as sysdba
Enter password:
What password must I enter? I didn't create anything when I installed Vision database. If I entered any password such as sys, apps, etc I got the message :
Connected to an idle instance
then if I tried the next step, which is check if database is in which status, by execute :
SQL> select Log_Mode from Sys.v$database;
I got error message like this :
ERROR at line 1:
ORA-01034: Oracle not available
How do I solve all that problems? Thanks for the answer
After login as oracle user, set the environment and start sqlplus I stuck in step:
Enter user-name: sys as sysdba
Enter password:
What password must I enter? I didn't create anything when I installed Vision database. If I entered any password such as sys, apps, etc I got the message :
Connected to an idle instance
then if I tried the next step, which is check if database is in which status, by execute :
SQL> select Log_Mode from Sys.v$database;
I got error message like this :
ERROR at line 1:
ORA-01034: Oracle not available
How do I solve all that problems? Thanks for the answer
maybe you should check your DB's status??
ORA-01034: ORACLE not available
Cause: Oracle was not started up. Possible causes include the following:
- The SGA requires more space than was allocated for it.
- The operating-system variable pointing to the instance is improperly defined.
Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation
ORA-01034: ORACLE not available
Cause: Oracle was not started up. Possible causes include the following:
- The SGA requires more space than was allocated for it.
- The operating-system variable pointing to the instance is improperly defined.
Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Hi,
Taking DBA pdf file, will not solve as like this....
Today almost two of my issues solved just because of erpstuff.com
It was easy to identify where we have done the mistake or to clarify the doubts.
As a functional consultant, these things may not interest me, but when going through the postings, it is interesting and wish to learn more for knowledge.
Pdf's are boring Ahmad.....
TIA
Taking DBA pdf file, will not solve as like this....
Today almost two of my issues solved just because of erpstuff.com
It was easy to identify where we have done the mistake or to clarify the doubts.
As a functional consultant, these things may not interest me, but when going through the postings, it is interesting and wish to learn more for knowledge.
Pdf's are boring Ahmad.....
TIA
hi anu_numa,
maybe reading pdf's file was boring but because of reading that I can improve my knowledge and skills and I'm grateful for admins who created that pdf.
for me as a newbie, all that file is my first & default help to search then asked people who had better experience than me for some help if I couldn't find in the docs. didn't you get bored sometimes if some newbie asked you the same question over and over again? wouldn't it be easily to create docs like that? it helps us to try first and get better experience too. at least that's for me. now, how about help me to solve my problem? thanks.
maybe reading pdf's file was boring but because of reading that I can improve my knowledge and skills and I'm grateful for admins who created that pdf.
for me as a newbie, all that file is my first & default help to search then asked people who had better experience than me for some help if I couldn't find in the docs. didn't you get bored sometimes if some newbie asked you the same question over and over again? wouldn't it be easily to create docs like that? it helps us to try first and get better experience too. at least that's for me. now, how about help me to solve my problem? thanks.
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Uma,
<b>There is no royal road to sucess </b>
you have to read such <u>booring PDFs</u>
for Download document
<b>http://erpstuff.com/topic.asp?TOPIC_ID=16</b>
this is not booring
[quote]Hi,
Taking DBA pdf file, will not solve as like this....
Today almost two of my issues solved just because of erpstuff.com
It was easy to identify where we have done the mistake or to clarify the doubts.
As a functional consultant, these things may not interest me, but when going through the postings, it is interesting and wish to learn more for knowledge.
Pdf's are boring Ahmad.....
TIA
<i><div align="right">Originally posted by anu_uma
<b>There is no royal road to sucess </b>
you have to read such <u>booring PDFs</u>
for Download document
<b>http://erpstuff.com/topic.asp?TOPIC_ID=16</b>
this is not booring
[quote]Hi,
Taking DBA pdf file, will not solve as like this....
Today almost two of my issues solved just because of erpstuff.com
It was easy to identify where we have done the mistake or to clarify the doubts.
As a functional consultant, these things may not interest me, but when going through the postings, it is interesting and wish to learn more for knowledge.
Pdf's are boring Ahmad.....
TIA
<i><div align="right">Originally posted by anu_uma
[quote]Uma,
<b>There is no royal road to sucess </b>
you have to read such <u>booring PDFs</u>
for Download document
<b>http://erpstuff.com/topic.asp?TOPIC_ID=16</b>
this is not booring
[quote]Hi,
Taking DBA pdf file, will not solve as like this....
Today almost two of my issues solved just because of erpstuff.com
It was easy to identify where we have done the mistake or to clarify the doubts.
As a functional consultant, these things may not interest me, but when going through the postings, it is interesting and wish to learn more for knowledge.
Pdf's are boring Ahmad.....
TIA
<i><div align="right">Originally posted by anu_uma
<b>There is no royal road to sucess </b>
you have to read such <u>booring PDFs</u>
for Download document
<b>http://erpstuff.com/topic.asp?TOPIC_ID=16</b>
this is not booring
[quote]Hi,
Taking DBA pdf file, will not solve as like this....
Today almost two of my issues solved just because of erpstuff.com
It was easy to identify where we have done the mistake or to clarify the doubts.
As a functional consultant, these things may not interest me, but when going through the postings, it is interesting and wish to learn more for knowledge.
Pdf's are boring Ahmad.....
TIA
<i><div align="right">Originally posted by anu_uma
Dear yudi_lukman,
In the recovery topic it is mentioned that after taking backup now we need to test it. How? Do we have another machine on which we will restore or we will use the same one. If same then we said that remove all the datafiles from the data folder of the database of which you took the backup. This is what we wanted to demonstrate that the disk on which you datafiles were damaged and now we have to restore our all datafiles. Now if you read the step 1.2 you can check that data files are extracted from backup file and restored on the default location. Hope the above will clear your confusion. Thanks
In the recovery topic it is mentioned that after taking backup now we need to test it. How? Do we have another machine on which we will restore or we will use the same one. If same then we said that remove all the datafiles from the data folder of the database of which you took the backup. This is what we wanted to demonstrate that the disk on which you datafiles were damaged and now we have to restore our all datafiles. Now if you read the step 1.2 you can check that data files are extracted from backup file and restored on the default location. Hope the above will clear your confusion. Thanks
Dear admin,
Thanks for reply my question. I re-read my Oracle Applications Concept disk and it stated that the <dbname>SID contains the data (.dbf) files of the Oracle database. So if my dbname is VIS and I installed as default directory then my data files would be under /visdata and I need to move all the files under that directory to another directory as means of testing recovery, am I right?
Thanks for reply my question. I re-read my Oracle Applications Concept disk and it stated that the <dbname>SID contains the data (.dbf) files of the Oracle database. So if my dbname is VIS and I installed as default directory then my data files would be under /visdata and I need to move all the files under that directory to another directory as means of testing recovery, am I right?
Who is online
Users browsing this forum: No registered users and 8 guests