OraFAQ Forum: Backup & Recovery » Hot-Backup failure

Home » RDBMS Server » Backup & Recovery » Hot-Backup failure

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

Hot-Backup failure [message #7983]

Mon, 21 July 2003 02:59

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi,
I just try to initiate the hot backup script from http://www.orafaq.com/scripts/back_rec/backup.txt.
But I got failures by generating the sql-script which is the result of the first script.
declare
*
ERROR at line 1:
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 35
ORA-06512: at "SYS.DBMS_OUTPUT", line 198
ORA-06512: at "SYS.DBMS_OUTPUT", line 139
ORA-06512: at line 31

I don't know where this ORA-20000 is set, we've only one in the exception for ArchiveLog, but no other.
We're using Oracle 9.2.0.1 on Solaris 9.
Any suggestions ?
regards
Uwe

Report message to a moderator

Re: Hot-Backup failure [message #7988 is a reply to message #7983]

Mon, 21 July 2003 05:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

execute this before running the script or
call it along the script or set it in the session level.

exec dbms_output.enable('1000000'); -- or any higher value.

Report message to a moderator

Re: Hot-Backup failure [message #8008 is a reply to message #7988]

Tue, 22 July 2003 02:03

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

Hi Mahesh,
thanks - that works fine. Is this limitation a standard value ? I am not sure tha we set this anywhere.
Second problem :
How to start sqlplus in a shell-script for Oracle 9i for sys as sysdba ? Logon fails if we try
sqlplus sys as sysdba / passwd.
For automatirizing the hotbackup we do nee to start this in a script.
Any more suggestings ??

Uwe

Report message to a moderator

Re: Hot-Backup failure [message #8014 is a reply to message #8008]

Tue, 22 July 2003 06:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

syntax would be

-- just to connect
sqlplus "sys/password@tnsconnectionstring as sysdba" 

-- to connect and execute some commands
-- write the commands into a sql file and call it
-- make sure u have a exit statment in sql script. else, the connection will 'stay' inside the sqlplus.
-- if you use sqlplus -s , u will get connected in silent mode.
sqlplus "sys/password@tnsconnectionstring as sysdba"  @script.sql

--

Report message to a moderator

Re: Hot-Backup failure [message #8016 is a reply to message #8014]

Tue, 22 July 2003 06:55

Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland

Senior Member

yes, I fixed that out but what I realy want to have is:

calling that hotbackup script from cron as shell script. connect inside that shell script to sqlplus and generate a backup sequence for our database.
By now I get the connect using sqlplus /NOLOG and connect sys/passwrd as sysdba. But what not works is that the right output is generated with spool. I tried to use the hotbackup-script from the tools side here to make a dynamicly hot-backup.
Now the result file has only the statements from the generation script and not the results. If I use it from sqlplus as sql-script it works fine.+
Do you have any hint for me ?
I will try to call it via sqlplus @script.
rgds
Uwe

Report message to a moderator

Previous Topic:	RMAN
Next Topic:	Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 22:37:10 CST 2024