Home » RDBMS Server » Backup & Recovery » Oracle 7.3
Oracle 7.3 [message #162850] Mon, 13 March 2006 20:33 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
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 Go to previous message
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...

Laughing
Previous Topic: RMAN for 8i Database
Next Topic: import with blob column
Goto Forum:
  


Current Time: Thu Mar 28 18:04:48 CDT 2024