Need help to backup

[lukman]

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

[shhuang]

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

[admin]

Pl check if your database is open if not then startup it first? thanks

[lukman]

I thought the database supposed to be down not up?

[lukman]

Hello all, I'd finally success in backup Vision Database and now I'm moving forward to restore and as usual as a newbie stuck at first step (

Step 1.1. What does it mean by "all the data files"? Is is all the files and folder under visdb (if the database is vis)?

Thank you for the help.

[anu_uma]

Hi,
It will be helpful if u post the step by step for Back up .....

Uma

[ahmadbilal]

Downoad Apps DBA document!

all steps are documented there

[quote]Hi,
It will be helpful if u post the step by step for Back up .....

Uma

<i><div align="right">Originally posted by anu_uma

[anu_uma]

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

[lukman]

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.

[ahmadbilal]

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

[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

[admin]

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

[lukman]

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?

[admin]

Yes but I am sure this all practice is on test machines. thanks

[lukman]

hahahaha, don't worry, my nerve and neck is not strong enough to test it on a live production machine, I'll be dead by then. as a newbie of course I'm testing on a test machine. thanks. I'm working it right now.