| Neeraj |
Posted: Mar 14, 2008 06:42:20 AM |
Total Post: 252
Joined: Jan, 2007
|
hi,
i have onl;y dbf files of my oracle 9i database(not redo & control files) so is it possible i can up my this database on 10g somehow.
if yes then tell me how ? if not then also tell me y not.
thxs |
|
|
 Gitesh |
| Posted: Mar 14, 2008 11:05:58 PM |  |
|
Total Post: 322
Joined: May, 2005
|
Do you have archives files? Then it is possible. Otherwise it is not possible.
1) Open database with startup no mount stage.
2) Create controlfile with using "create controlfile command.
3) Recover database from last archives using "recover database until cancle"
4) Open database with resetlogs
5) After opening database. Shutdown normal/immediate
6) take full cold backup
7) Proceed for upgradtion to 10g.
|
|
|
|
|
| Neeraj |
| Posted: Mar 15, 2008 05:18:15 AM | |
|
Total Post: 252
Joined: Jan, 2007
|
i dont hav archivie files, i m trying to do all steps of database cloning
i hav dont till creating controlfiles but when i give
alter database open resetlogs ;
it shows
ora-01194
ora-01110
how to solve it ?
is it possible or not ?
y is it showing error ?
thxs
|
|
|
|
|
| Mohammed Taj |
| Posted: Mar 15, 2008 08:17:16 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
..i have onl;y dbf files of my oracle 9i database(not redo & control files) so is it possible i can up my this database on 10g somehow...
simply NO,
if you have archivelog then also NO.
you have to first create database in oracle 9i as mention above steps (for archivelog).
and without controlfile how can you mount your database ?
try again with below steps.
if you have controlfile then use below steps
1. recover database until cancel;
2. alter database open resetlogs;
if you don't have controlfile and redolog file then try with
1. startup nomount
2. create controlfile through "create controlfile statement" with RESETLOGS options.
REgards
Taj
|
|
|
|
|
| Neeraj |
| Posted: Mar 18, 2008 01:18:28 AM | |
|
Total Post: 252
Joined: Jan, 2007
|
i just created new controlg file reuse set database 'name' resetlog noarchivg
..
.
.
;
but i m not able to open database
when i write
alter database open resetlog;
i find error
is it possible wt i m tryting to do or i m making any mistake.
thxs
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
