Operating System - HP-UX
1751792 Members
4997 Online
108781 Solutions
New Discussion

Re: how to set a database in archive mode

 
SOLVED
Go to solution
Steven E. Protter
Exalted Contributor

Re: how to set a database in archive mode

You need exclusive access to the database, even if its in cluster mode to turn on archive log mode.

here is how to do it from either svrmgrl or sqlplus

svrmgrl
connect internal
startup mount cc1;
alter database archivelog;
archive log start;
alter database open;

Its the same in sqlplus except your command line is sqlplus internal

Steve
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Steven E. Protter
Exalted Contributor

Re: how to set a database in archive mode

Have you heard of tnsping?

Its an oracle utility that lets you test your tnsnames.ora sqlnet.ora and listener.ora configuration and validate you have proper connectivity and that the daemons(listener, etc) are configured properly.

Steve.
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com