Topic: Backup & Recovery >> Backup restored
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| seenu |
Posted: Sep 24, 2008 05:45:02 AM |
Total Post: 97
Joined: Apr, 2008
|
I have restored my corrupted datafiles?
but still database is not able to up?
what are the steps need to be check from my end?
pls help.....
Version:Oracle 9i
OS:Linux 5.5 |
|
|
 scorpio |
| Posted: Sep 24, 2008 07:32:48 AM |  |
|
Total Post: 20
Joined: Sep, 2008
|
Senu
a very little information to guide u to recover the database .
Can u tell what the error message u r getting and what excatly u have done .There can be multiple reason why ur database is not starting up .
A general steps :
1 ) connect to RMAN and look for suitable backups to recover
rman nocatalog target /
2) RMAN> list backup;
3) RMAN> restore datafile 'filename.dbf';
4) RMAN> recover datafile 'filename.dbf';
* I am assuming the controlfiles and spfile are in tact.
now login to sql plus
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces;
SQL> select FILE#,STATUS,ENABLED,NAME from v$datafile;
if its offline
SQL> alter database datafile 'filename.dbf' online;
SQL> alter tablespace <name of tablespace> online;
|
|
|
|
|
| GOPU |
| Posted: Sep 24, 2008 12:58:12 PM | |
|
Total Post: 340
Joined: Apr, 2008
|
why you are not able to up the db?
what is the issue you are facing to make the db up?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Vinoth Kumar | 357 |
| Gopu Gopi | 340 |
| Gitesh Trivedi | 322 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
