backup question 1

[TheDash]

Hi,
Could anyone tell if we need to backup redolog files for a cold backup of oracle 8i d/b? The d/b is running in ARCHIVE log mode.

I was planning to backup these

select * from v$datafile
select * from v$controlfile
select * from v$logfile -------> (Should this be done?)
Thanks.

 

[TheDash]

I am just planning to backup files from the above 3 (or 2) along with init.ora to a tape. Then startup d/b. Should redolog files (v$logfile) be backedup? Is there any other things that need to be checked? Any issues? Please suggest.

 

[KenCunningham]

I'd backup the whole shebang, they're usually not so big as to present an unacceptable overhead. That said, we don't copy the redologs when doing a clone of a database, but that's with a resetlogs in the cloning script.

 

[KenCunningham]

Should anyone disagree, please feel free to advise differently!!

 

[DBAwhosaysNIE]

yes, you do need to backup the online log files for a cold backup

that being said if you're running you database archivelog (which you should) you can run hot backups. there's reall no need to do cold backups in Oracle.

 

[alexhu]

I'm with DBAwhosaysNIE - hot backups - why shut the database down for a backup - its more complicated and therefore more liable to go wrong

Alex

 

[bugblast]

Thank you all for the input. However, the cold bakup is planned. Could anybody please suggest if there are any pre-checks, any important "must" things to do or check in/before

shutdown
backup
startup ?

Thanks again

 

[dbtoo2001]

Backup the controlfile to trace, copy that. Is the database using an ifile? Copy that, too, if it is.

What's the plan... shutdown abort, startup restrict, shutdown normal?

 

[TheDash]

I will just say "shutdown" What would you recommend?

 

[TheDash]

hi,

shutdown is taking longe. it's been an hour now? Any recommendations?

 

[Turkbear]

Hi, Use the sequence that dbtoo2001 posted:
Shutdown abort( kills all connections and shutsdown)
Startup restrict ( prevents new connections)
Shutdown normal ( will be fast now)

 

[appi]

or you can start
shutdown immediate
this will wait only for ending transaction and closes all connections.
shutdown abort will kill all processes - but be carefully, the data might be corrupted in the Databse.