hot backup instructions

[looser]

Hi there,

Does anyone here have or used some kind of a documentation on doing a hot backup step-by-step?

I'm new at this stuff, and want to try some. I rather not trial by error, I rather get an instruction from an expert and work off that.

I appreciated if someone can help me with this venture.


thanks

[sreddy]

[url]http://www.dbasupport.com/forums/showthread.php?threadid=6587[/url]

Better not be 'looser' in database administration. Nothing much happens, Just Nightmares...

[Edited by sreddy on 02-22-2001 at 07:36 PM]

[looser]

cool

thanks

[rohitsn]

Hi,
This is Rohit Nirkhe from India.U want some help regarding doing hot backup.
Hot backup is done when ur database can't be shutdown.It is meant for databases running 365*24*7 days.
This kind of backup requires ur database in archivelog mode.If ur database is in noarchivelog mode(default),shutdown the database with normal,immediate,transactional.Dont use abort option;
SVRMGR> shutdown immediate/normal/transactional

Change ur init.ora parameters for putting ur database in archive log mode.
In init.ora
LOG_ARCHIVE_START=true (Arch process will
automatically archive ur log
files)
LOG_ARCHIVE_DEST=dest (destination where ur
archived log files will be
kept)
LOG_ARCHIVE_FORMAT="%s.arc" (format for arch files)

Startup ur database in mount state and
SVRMGR > startup mount pfile=<parameter file>

SVRMGR> alter database archivelog (changes ur database
into archivelog and
reflects ur control file)
SVRMGR > alter database open

U can find out the status of it from v$database view.
After putting ur database into archivelog mode ,all ur previous backup taken when ur database was in noarchivelog mode has become obsloete.
To take backups for ur archivelog database,put each tablespace in ur backup mode and then take the backup.

SVRMGR> alter tablespace SYSTEM begin backup;
SVRMGR> host copy c:\system.dbf a:
SVRMGR> alter tablespace SYSTEM end backup;

Perform the above steps to backup all ur tablespaces one-by-one.At the same time also backup the archived log files which were getting generated while the backup was going.This backup of tablespace files + archived log files will be applied in case of any failure to the database. If u have any kind of doubts please contact me at this email id
rohitsn@hotmail.com

[LND]

a time ago I read some article about uniquenes of RMAN in that is allows to make hot backups ant there was some statements about

alter tablespace SYSTEM begin backup;
SVRMGR> host copy c:\system.dbf a:
SVRMGR> alter tablespace SYSTEM end backup;

being possibly wrong approach if some conditions regarding data block buffers size and OS block buffer size are met.

Anyone has more about it?

[rogerF]

Backups are a big enough pain in the ass that even if you get a good script you should figuire out whats happening.

Get a good book:

Oracle8i DBA Bible
[url]http://www.idgbooks.com[/url]

is well worth the 40 bucks if you are being payed to keep that database running.

Oracle 8i Backup and Recovery Handbook: Implement Sound Data Protection Techniques
by Rama Velpuri, Anand Adkoli, George Williams

will be a book that only deals with backup.

To get started quick, get the free hotbackup scripts from backup central:

[url]http://www.backupcentral.com/toc-free-backup-software.html[/url]

These scripts are just about ready to go out of the box.

If your broke read the online oracle8i backup guide that comes on the CDROM. It explains the gruesome details of the alter this and that statements.

Cheers,

Roger

[pando]

alter tablespace SYSTEM begin backup;
SVRMGR> host copy c:\system.dbf a:
SVRMGR> alter tablespace SYSTEM end backup;

this is a wrong approach for NT/2000 since to copy datafiles in NT/2000 during hot backup you have to use OCOPY