Home » RDBMS Server » Backup & Recovery » user name to connect for archivelog after migration. (oracel 11g express release 2)
user name to connect for archivelog after migration. [message #561422] Sun, 22 July 2012 07:14 Go to next message
rajeshrajdaan
Messages: 16
Registered: July 2012
Junior Member
Dear Sir/Madam (and friends)

I have migrated my database to oracle and while migration i have followed all instructions and migrated to oracle.the connection and user having my tables and all object is

con name: orcltestcon user: orcltestuser and password: orcltestuser.


i want to turn on ARCHIVELOG Mode ON.
1) Please tel me is it good practice to turn on archivelog. also tel me cases where it is good.
2) to turn on ARCHIVELOG , with which command i should connect.

1) CONNECT SYS/<password> AS SYSDBA;
or
2) CONNECT orcltestuser/orcletestuser AS SYSDBA.

yours sincerely
Re: user name to connect for archivelog after migration. [message #561424 is a reply to message #561422] Sun, 22 July 2012 08:57 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1) Yes, ALWAYS.
2) Any of them that works

Regards
Michel
Previous Topic: Need to restore database, have all files
Next Topic: Recovery process
Goto Forum:
  


Current Time: Tue Dec 17 20:26:01 CST 2024