Home » RDBMS Server » Server Administration » Restoring Backup of 8i in oracle 9i
Restoring Backup of 8i in oracle 9i [message #146873] Mon, 14 November 2005 06:16 Go to next message
deepa_balu
Messages: 74
Registered: March 2005
Member
Hi,

We have an oracle 8i Database.

Is it possible to take a cold backup of Database and restore in a 9i server (unix platform)

Suppose if i am taking a hotbackup , can i be able to apply the archived logs in the same scenario.(8i to 9i)

Report message to a moderator

Re: Restoring Backup of 8i in oracle 9i [message #146881 is a reply to message #146873] Mon, 14 November 2005 08:18 Go to previous messageGo to next message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
No! You need to upgrade the database first. If you don't want to, install Oracle 8i on the target server before you restore the 8i DB to it.

Best regards.

Frank

Report message to a moderator

Re: Restoring Backup of 8i in oracle 9i [message #147131 is a reply to message #146873] Tue, 15 November 2005 20:14 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Do you have the option of doing an export from 8i and an import into 9i? Take care of invalid objects before you export. Set ignore create errors = yes on import.

Report message to a moderator

Previous Topic: INFORMATICA 7.1.1 DB2 BULK LOAD
Next Topic: Oracle 10.2.0.1 - Using DBUA, does it work?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 10 22:46:56 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.