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: 57642
Registered: March 2007
Location: Nanterre, France, http://...
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: Wed Apr 23 21:38:12 CDT 2014

Total time taken to generate the page: 0.11660 seconds