Need help to backup

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Need help to backup

Post by 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
Posts: 7
Joined: Thu Aug 24, 2006 6:31 am
Location: Taiwan

Post by 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
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Pl check if your database is open if not then startup it first? thanks
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by lukman »

I thought the database supposed to be down not up?
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by 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
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post by anu_uma »

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

Uma
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by 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
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post by 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
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by 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
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by 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
Posts: 456
Joined: Sat Feb 03, 2007 4:39 am
Location: India
Contact:

Post 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
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by 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
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by 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
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

Yes but I am sure this all practice is on test machines. thanks
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by 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.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests