Re: hots/cold backup script for 9i on linux
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 10 Jan 2008 17:56:41 +0100
Message-ID: <7e59e$47864e49$524b5c40$16788@cache5.tilbu1.nb.home.nl>
Date: Thu, 10 Jan 2008 17:56:41 +0100
Message-ID: <7e59e$47864e49$524b5c40$16788@cache5.tilbu1.nb.home.nl>
ton de w wrote:
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 10 16:34:09 2008
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> connect / as sysdba
> Connected.
Are you on 9.2.0.4? Your SQL*Plus is, but that could be from another binary tree. Update to 9.2.0.5 and then to 9.2.0.7. Yes, that is 05 first, as there's a bug in updating the update process... This sequence avoids having to roll back CPU patches and 9.2.0.8....
Anyway; what's so hard about:
export ORACLE_SID=orcl
rman target /
shutdown immediate
startup mount
backup database
alter database open;
exit;
That's RMAN, baby! Just configure the darn thing once; control file autobackup would be nice...
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Thu Jan 10 2008 - 10:56:41 CST