OraFAQ Forum: Server Administration » oracle 8i administration

Home » RDBMS Server » Server Administration » oracle 8i administration

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

oracle 8i administration [message #63035]

Thu, 02 September 2004 22:28

Ronnie Lee
Messages: 3
Registered: September 2004

Junior Member

Hi all,

How can I archive and backup oracle 8i

Please advise.

Report message to a moderator

Re: oracle 8i administration [message #63139 is a reply to message #63035]

Mon, 13 September 2004 23:14

Balaji
Messages: 102
Registered: October 2000

Senior Member

Hi Ronnie,

1. go to svrmgr on the dos or $ prompt on the machine hosting oracle
2.
$ svrmgrl
3.
SVRMGR> connect internal
connected
4.
SVRMGR> archive log list

the above command gives the info of the archive process, whether on archive log mode or not, the archive log destinations ,and the archive seguence numbers current,last archived ....

5.
Since yours is in NOARCHIVELOG mode

do the folowing changes in the initsid.ora file
by removing the hash symbol :
log_archive_format
log_archive_dest
log_archive_start=true

6. Shutdown the and backup the database for your safety.
7. Come to SVRMGR>

SVRMGR>startup mount
SVRMGR>alter database archivelog;
SVRMGR>archive log list

now you will be able to find all abt the database archive

SVRMGR>alter database open;
SVRMGR>exit
$exit

as for backup you can go for either hot or cold backups .

best regards
balaji

Report message to a moderator