OraFAQ Forum: Server Administration » archiver error. Connect internal only, until freed.(merged)

Home » RDBMS Server » Server Administration » archiver error. Connect internal only, until freed.(merged) (oracle 11.2.0.1.0 linux 2.6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

archiver error. Connect internal only, until freed.(merged) [message #516871]

Thu, 21 July 2011 04:50

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear Sir / Madam,

now DB is hanging; i am not able to connect both SQL and RMAN prompt. Is it possibel to move some old archives using ASMCMD prompt to datafile mount point location ?
Once i got some free space, then i can try connect RMAN and fire my script manually to take the backup and delete the same. ....

ASMCMD [+QSTAGE_T1_BACKUP_01/QSTAGE/ARCHIVELOG] > ls -ltr
cdType  Redund  Striped  Time             Sys  Name
                                        Y    2011_07_15/
                                        Y    2011_07_16/
                                        Y    2011_07_17/
                                        Y    2011_07_18/
                                        Y    2011_07_19/
                                        Y    2011_07_20/

i have free space at mount point : +QSTAGE_T1_DATA_01/QSTAGE/DATAFILE

i need to backup the archives first before deletion..as those are required for Streams.

backup script:

run {
backup archivelog all delete completed before 'sysdate-1';
}

note: i would like to remove the file which are older than one day

I request you to guide me further.

Thank you,
Kesavan

[Updated on: Thu, 21 July 2011 04:56]

Report message to a moderator

Re: archiver error. Connect internal only, until freed. [message #516872 is a reply to message #516871]

Thu, 21 July 2011 05:06

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

shutdown abort;
startup mount;
backup archivelog ...;

Regards
Michel

Report message to a moderator

ORA-00257: archiver error. Connect internal only, until freed [message #516973 is a reply to message #516871]

Thu, 21 July 2011 09:30

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

HI Michel,

This is a different scenario for the above error. End user says when they try to connect a schema ( informatica job they firing, and first it connects to the schema in the front end ), they get this error. Further when i tried to connect same schema in the server ( NODE-1 ) , i am also gettign the same error. but if i tried from NODE-2, i am able to connect schema.. there is no error. Further when i checked the disk group ( +RECO ), it has enough free space ( 32% free ).

i.e.

NAME       FREE_MB/1024 TOTAL_MB/1024     Free %
---------- ------------ ------------- ----------
SYSTEMDG     1162.98438      1164.375  99.880569
RECO         3935.42578         12000 32.7952148
DATA             365.75         75936 .481655605

if i connect ASMCMD prompt and check the no.of archivelog files, i am having only past 3 days files...

ASMCMD [+RECO/TEDW/ARCHIVELOG] > ls
2011_07_19/
2011_07_20/
2011_07_21/

DUKEDMTS03DB01:SYS@TEDW1> conn identity/*****
ERROR:
ORA-00257: archiver error. Connect internal only, until freed

DUKEDMTS03DB02:SYS@TEDW2> conn IDENTITY/*****
Connected.

how i can resolve this ? i can able to connect rman prompt.

i just want to retain the recent files within 2 hours, and older than 2 hours to be deleted. so, i need to fire the below:

run {
delete archivelog all completed before 'sysdate-2/24';
}

any other area should i check further ?

why node-1 giving error where node-2 is getting connected...

Kindly clafify the same.

Thank you,
Kesavan

Report message to a moderator

Re: ORA-00257: archiver error. Connect internal only, until freed [message #516974 is a reply to message #516973]

Thu, 21 July 2011 09:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the DATA volume is FULL & Oracle refuses to proceed until DATA volume contains some/more FREE space

[Updated on: Thu, 21 July 2011 09:33]

Report message to a moderator

Re: ORA-00257: archiver error. Connect internal only, until freed [message #516986 is a reply to message #516973]

Thu, 21 July 2011 10:57

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I already gave you an answer in another topic, why do you start a new one for the same question which start with a silly information for this topic "This is a different scenario for the above error", there is NO above error as you started a new topic.

Quote:

i need to fire the below

So proceed.

Regards
Michel

Report message to a moderator

Re: ORA-00257: archiver error. Connect internal only, until freed [message #517056 is a reply to message #516986]

Fri, 22 July 2011 03:05

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Hi Michel,

I am regretting for inconvenience..

I would like to clafify the below:

Further to Blackswan comment, we have requested to add some more space for +DATA diskgroup. And our onsite team have freed more space from +RECO diskgroup:

SELECT name,free_mb/1024,total_mb/1024,free_mb/total_mb*100 "Free %" FROM v$asm_diskgroup;

NAME       FREE_MB/1024 TOTAL_MB/1024     Free %
---------- ------------ ------------- ----------
SYSTEMDG     1162.98438      1164.375  99.880569
RECO         6282.41797         12000 52.3534831
DATA         277.632813         75936 .365614218

3 rows selected.

now, archive error has been suppressed. yday we had 3935 GB free space in +RECO, and now we have 6282 GB. i just tried to check the size of subdirectories for one database ( for e.g. TEDW ) , but the output takes much time :

> asmcmd -p
ASMCMD [+] > ls
DATA/
RECO/
SYSTEMDG/
ASMCMD [+] > cd RECO/
ASMCMD [+RECO] > ls
DAPPDM/
DBIREP/
DBRM/
DEDW/
DODS/
PEDWAUX/
SAPPDM/
SIPDR/
TAPPDM/
TBIREP/
TEDW/
TIPDR/
TODS/
ASMCMD [+RECO] > cd TEDW/
ASMCMD [+RECO/TEDW] > ls
ARCHIVELOG/
AUTOBACKUP/
CONTROLFILE/
FLASHBACK/
ONLINELOG/
ASMCMD [+RECO/TEDW] > du ARCHIVELOG/
Used_MB      Mirror_used_MB
 569848             1139696
ASMCMD [+RECO/TEDW] > du CONTROLFILE/
Used_MB      Mirror_used_MB
    132                 396
ASMCMD [+RECO/TEDW] > du ONLINELOG/
Used_MB      Mirror_used_MB
   8160               16320
ASMCMD [+RECO/TEDW] > du FLASHBACK/
Used_MB      Mirror_used_MB
 257524              515048
ASMCMD [+RECO/TEDW] > du AUTOBACKUP/
Used_MB      Mirror_used_MB
    928                1856
ASMCMD [+RECO/TEDW] >

it took around 18 min to get the " du <folders> " output.
for e.g. we have 23 databases sharing this +ASM1 instance. Do we have any alternate way to check the size of each subdirectories for one database thro SQL prompt ?

if so, kindly provide the same, so that we can check quickly that which database utilizing much space and can delete those files ..

(ii) could you please guide me how to check whether a specific archive log file applied in Streams ? in our env, we are keeping all the archives only for steaming. once done, we can just delete those.

Thank you,
Kesavan

[Updated on: Fri, 22 July 2011 03:08] by Moderator

Report message to a moderator

Re: ORA-00257: archiver error. Connect internal only, until freed [message #517296 is a reply to message #517056]

Mon, 25 July 2011 04:37

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

dear sir/madam,

Now i have freed around 3.5 TB in archivelog diskgroup (+RECO) , but still i am getting this archive error as below. What would be the reason, pls guide me further:

NAME       FREE_MB/1024 TOTAL_MB/1024     Free %
---------- ------------ ------------- ----------
SYSTEMDG     1162.98438      1164.375  99.880569
RECO         5426.87891         12000 45.2239909
DATA          3299.6875         75936 4.34535332

3 rows selected.

DUKEDMTS03DB01:SYS@TEDW1> conn edwstg/*****
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.


Warning: You are no longer connected to ORACLE.
DUKEDMTS03DB01:SYS@TEDW1> exit

ASMCMD [+RECO/TEDW] > cd ARCHIVELOG/
ASMCMD [+RECO/TEDW/ARCHIVELOG] > ls
2011_07_25/
ASMCMD [+RECO/TEDW] > du ARCHIVELOG/
Used_MB      Mirror_used_MB
 170538              341076

now archivelog folder having only size 170 gb around.

Report message to a moderator

Re: ORA-00257: archiver error. Connect internal only, until freed [message #517300 is a reply to message #517296]

Mon, 25 July 2011 05:16

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear sir/ madam,

adding some more:

after deleting the files in ASMCMD, i did CROSSCHECK ARCHIVELOG ALL; and able to see much free space for +RECO dg in "lsdg" output. howoever i am getting archive error while try connect some user in DB.

FURTHER, I am doing the followoing:

in RMAN, i have issued below command:

delete archivelog all completed before 'sysdate-1';

or ortherwise, i could have issued below 2 commands:

1 - RMAN>delete obsolete;
2 - RMAN>delete expired archivelog all;
3 - RMAN >list archivelog all;

is this correct ? could anyone guide me ?

Thank you,
kesavan

Report message to a moderator

Re: ORA-00257: archiver error. Connect internal only, until freed [message #518814 is a reply to message #517300]

Sun, 07 August 2011 07:09

Flyby
Messages: 188
Registered: March 2011
Location: Belgium

Senior Member

Have you tried "alter system switch logfile" to mention Oracle to continue?

Report message to a moderator

Previous Topic:	roll of undo in recovery
Next Topic:	can not execute dbms_redefinition.start_redef_table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 11:39:50 CDT 2024