[Oracle] instance recovery required, cannot set ARCHIVELOG mode

Posted by cikul | Posted in Oracle, SQL, Technology | Posted on 26-09-2012-05-2008

1

When I try to set archivelog in another machine using this guidance. I’ve got this error message :


SQL> startup mount;
ORACLE instance started.

Total System Global Area  320309648 bytes
Fixed Size                   731536 bytes
Variable Size             285212672 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Read the rest of this entry »

Share and Enjoy

[Oracle] Startup & Shutdown Oracle Instance

Posted by cikul | Posted in Oracle, SQL | Posted on 17-07-2012-05-2008

0

For DBA,  starting up and shutting down database is a routine operation. How to start and stop Oracle database (windows & Unix base)

Starting Up Oracle Database

To starting up Oracle Database,  you must connect using SQLPLUS /as sysdba or an oracle account that has DBA privilege.

Read the rest of this entry »

Share and Enjoy

[SQL-Oracle] Copying data from one table to another

Posted by cikul | Posted in SQL | Posted on 29-06-2012-05-2008

0

How to simply copy data from one Oracle table into another one? There is several ways to copy data, the common usage is exporting the data and then reupload the data to new table.

Read the rest of this entry »

Share and Enjoy