Home » RDBMS Server » Backup & Recovery » Hot-Backup failure
Hot-Backup failure [message #7983] Mon, 21 July 2003 02:59 Go to next message
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
Re: Hot-Backup failure [message #7988 is a reply to message #7983] Mon, 21 July 2003 05:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.

Re: Hot-Backup failure [message #8008 is a reply to message #7988] Tue, 22 July 2003 02:03 Go to previous messageGo to next message
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
Re: Hot-Backup failure [message #8014 is a reply to message #8008] Tue, 22 July 2003 06:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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

-- 

Re: Hot-Backup failure [message #8016 is a reply to message #8014] Tue, 22 July 2003 06:55 Go to previous message
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
Previous Topic: RMAN
Next Topic: Backup
Goto Forum:
  


Current Time: Thu Mar 28 12:49:28 CDT 2024