Skip to content

Archive for

Mar 29

RMAN-06059: expected archived log not found

When i try to take backup of archive log all using rman, it shows below error.

RMAN-00571: ========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ============
RMAN-00571: ========================================================
RMAN-03002: failure of backup command at 03/29/2010 12:20:05
RMAN-06059: expected archived log not found, lost of archived log co
coverability
ORA-19625: error identifying file D:\ORACLE\PRODUCT\10.2.0\FLASH_REC
ROKER\ARCHIVELOG\2010_03_25\O1_MF_1_257_5TQF22HV_.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Here what was the problem is, I was moved the archive log file using cut & paste when FRA location is fulled and then i changed the archive log destination also.In this case when i try to take backup of archive log ,the controlfile will search the oldest file on same location but it was missed, so that the system cannot find the file specified.

But i don’t want previous backup archive log.SO i try to fix following steps,Its ok now.

Step 1:

rman>crosscheck archivelog all;

Step 2:

rman>delete expired archivelog all;

Step 3:

rman>backup archivelog all;

input archive log thread=1 sequence=647 recid=400 stamp=714934627
channel ORA_DISK_1: starting piece 1 at 29-MAR-10
channel ORA_DISK_1: finished piece 1 at 29-MAR-10
piece handle=H:\RMAN\BROKER\BROKER714934764_S14_S1 tag=TAG20100329T165708 commen
t=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:07
Finished backup at 29-MAR-10

Starting Control File and SPFILE Autobackup at 29-MAR-10
piece handle=D:\ORACLE\PRODUCT\FLASHRECOVERY\BROKER\AUTOBACKUP\2010_03_29\O1_MF_
S_714934832_5V1DN201_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 29-MAR-10.

Now backup finished.

Mar 28

Solaris installation on Vmware

Step 1 : open your vmware, click new virtual machine and then new window will be appear.Choose typical and click next.

Step 2 : Here choose your operating system iso file.

Step 3: Here choose your path where your OS files will be store .So you must create one folder for new OS and name it solaris.The particular folder disk minimum 10gb enough space is better.

Step 4 : Here choose maximum disk space ,i choosed 50gb for solaris installation.

Step 5: Here Choose your hardware and memory size.

Step 6: After configuration, click power on this virtual machine , after clicked the solaris will be boot for installation, so you care fully do it your steps and most of the steps click default so i ignored some steps but you must choosed customized install for solaris because you should increase your swap space minimum 1024mb,it will be usefull for when you’re try to install Oracle on solaris and then your counting size will be equal.

Step 7 : hereafter some of the steps default select next what you want.

Step 8 : root password.

Step 9 : welcome screen

Step 10: Click default next but you  must choose customized install then only we can configure swap space and some space ,the spaces must be equal of your choosed disk space size.

Step 11 : Click Install Now.

Step 12: Solaris Installation will be progressing. It will take few minutes after installation,it automatically reboot and the welcome page will be appear.

Step 13 : Welcome to Solaris World and login root username and password.

Mar 28

VMWARE Installation On Windows 7

Step 1 :- Click vmware.exe setup file and then the vmware setup window will be appear.Click Next.

Step 2: Choose Typical and click Next.

Step 3:

Step 4: Ready for Install Click Install.

Step 5: Installation starting, it will take few minutes.

Step 6: VMWARE installation completed.

Mar 28

1 Comment

ORA-28365: wallet is not open

When i try to make export one table using datapump with encryption_password parameter , It shows following error.

ORA-39001: invalid argument value
ORA-39180: unable to encrypt ENCRYPTION_PASSWORD
ORA-28365: wallet is not open

So i try to fix this error,

Create folder for wallet in $ORACLE_BASE/admin/SID/wallet

and then go to add it this below statement to sqlnet.ora file.

WALLET_LOCATION = (SOURCE=
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY=D:\oracle\product\10.2.0\admin\ACE\wallet)
)))

then

SQL> alter system set key identified by test;

sytem altered.

Now you can able to using encryption_password parameter.

C:\Documents and Settings\Administrator>EXPDP SCOTT/TIGER@ace DIRECTORY=TEST ENC
RYPTION_PASSWORD=test tables=test

Export: Release 10.2.0.1.0 – 64bit Production on Sunday, 28 March, 2010 14:52:34
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit
Production
With the Partitioning, OLAP and Data Mining options
Starting “SCOTT”.”SYS_EXPORT_TABLE_01″:  SCOTT/********@ace DIRECTORY=TEST ENCRY
PTION_PASSWORD=********* tables=*********
Estimate in progress using BLOCKS method…
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “SCOTT”.”TEST”                              5.664 KB       4 rows
Master table “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  H:\TEST\EXPDAT.DMP
Job “SCOTT”.”SYS_EXPORT_TABLE_01″ successfully completed at 14:52:47.

Mar 28

1 Comment

RMAN: Create Catalog

How to create catalog for rman backup.I just provided here for step by step create catalog.

Mar 16

1 Comment

How to Enable Telnet on windows 7 and connect to Oracle Server

I just installed windows 7 on my new  machine and I try to connect Oracle server database through on Telnet but unfortunately i cannot connect  telnet. The telnet program doesnot configured on windows 7 when you’re done  first installation.so you need to configure Telnet program.In this case,you should follow these steps and then you can connect telnet program.

Step 1:  Open Control panel and Choose program on control panel,  then click Turn windows features on or off.

Step 2: After click , a new window appear, you can choose  Client telnet and then OK.

Step 3: The windows make new feautre.

Step 4:  After changes, you can now connect Telnet, cmd> telnet Enter.

Step 6: Now you can connect Oracle database through on telnet.

Step 6: Enter your OS oracle group  username and password.

Step 7: Finally you can connect database after you given oracle username and password.