OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Oracle 7.3

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Oracle 7.3 [message #163186 is a reply to message #162850]

Wed, 15 March 2006 06:57

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Try:

SVRMGR> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

Report message to a moderator

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...

Report message to a moderator

Re: Oracle 7.3 [message #163289 is a reply to message #163269]

Wed, 15 March 2006 23:52

Frank Naude
Messages: 4596
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

Report message to a moderator

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...

Laughing

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 08 04:14:38 CST 2025