Catatan kerja

Database beberapa permasalahan yang terjadi di tempat kerja

Database cannot be opened ( usaha terakhir ) October 28, 2008

Filed under: Oracle — aderahman @ 4:05 am

Step nya :
1. Shutdown Database nya
2. Add parameter ini di init.ora (take your own risk), parameter ini untuk force open database walaupun corrupt:
_ALLOW_RESETLOGS_CORRUPTION = TRUE
3. Startup mount
4. alter database open resetlogs;
5. Take Full Export backup.
6. Recreate the Database and Full Import.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s