| Oracle 7.3 [message #162850] |
Mon, 13 March 2006 20:33  |
G oracle7
Messages: 5
Registered: March 2006
Location: cabuyao, Philippines |
Junior Member |
|
|
We had a old server HP-UX HP9000 K200 running B20.10 with Oracle 7.3 which lost two disk that pertains to the tablespace..
we had a backup tape with the dmp.Z file.
I canot restore the data due to the error ORA-1033
i copied the control file from other volume .
i was able to mount the database
SVRMGR> startup
ORACLE instance started.
Total System Global Area 17917260 bytes
Fixed Size 38980 bytes
Variable Size 11291912 bytes
Database Buffers 6553600 bytes
Redo Buffers 32768 bytes
Database mounted.
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SVRMGR> ALTER DATABASE BACKUP CONTROLFILE TO TRACE RESETLOGS;
Statement processed.
Where could i found the sql created ?
Do you have any step/procedure that i would follow?
Any suggestion...
Thanks,
G
|
|
|
| Re: Oracle 7.3 [message #163186 is a reply to message #162850 ] |
Wed, 15 March 2006 06:57  |
Frank Naude
Messages: 3678
Registered: January 2002 |
Senior Member |
|
|
Try:
SVRMGR> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE; |
|
|
| Re: Oracle 7.3 [message #163269 is a reply to message #163186 ] |
Wed, 15 March 2006 18:49 |
G oracle7
Messages: 5
Registered: March 2006
Location: cabuyao, Philippines |
Junior Member |
|
|
ORACLE instance started.
Total System Global Area 17917260 bytes
Fixed Size 38980 bytes
Variable Size 11291912 bytes
Database Buffers 6553600 bytes
Redo Buffers 32768 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/system_db3.dbf'
SVRMGR> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00279: Change 3234198 generated at 02/26/06 10:04:33 needed for thread 1
ORA-00289: Suggestion : /oracle/dbs/arch/1_549.dbf
ORA-00280: Change 3234198 for thread 1 is in sequence #549
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oracle/dbs/arch/1_549.dbf
ORA-00308: cannot open archived log '/oracle/dbs/arch/1_549.dbf'
ORA-07360: sfifi: stat error, unable to obtain information about file.
HP-UX Error: 2: No such file or directory
SVRMGR> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00279: Change 3234198 generated at 02/26/06 10:04:33 needed for thread 1
ORA-00289: Suggestion : /oracle/dbs/arch/1_549.dbf
ORA-00280: Change 3234198 for thread 1 is in sequence #549
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oracle/dbs/arch/1_547.dbf
ORA-00310: archived log contains sequence 547; sequence 549 required
ORA-00334: archived log: '/oracle/dbs/arch/1_547.dbf'
i tried this '/oracle/dbs/arch/1_547.dbf' because this is the only archive log i have..
How do i change the sequence from 549 to 547?
another question : how do i use import backup file if the database is closed but already mounted?
Thanks...
|
|
|
| Re: Oracle 7.3 [message #163289 is a reply to message #163269 ] |
Wed, 15 March 2006 23:52 |
Frank Naude
Messages: 3678
Registered: January 2002 |
Senior Member |
|
|
Try to enter your on-line logfile names into the RECOVER DATABASE ... session.
SQL> SELECT member FROM v$logfile;
MEMBER
--------------------------------------------------------------------------------
/app/oracle/product/10.2.0/db_1/oradata/o10gr2/redo03.log
/app/oracle/product/10.2.0/db_1/oradata/o10gr2/redo02.log
/app/oracle/product/10.2.0/db_1/oradata/o10gr2/redo01.log
|
|
|
| Re: Oracle 7.3 [message #163296 is a reply to message #163289 ] |
Thu, 16 March 2006 00:29 |
G oracle7
Messages: 5
Registered: March 2006
Location: cabuyao, Philippines |
Junior Member |
|
|
Thanks man.. i already open the database...
now i need to try importing the backup tape...
|
|
|
]
Members
Search
Help
Register
Login
Home
