Comment below.
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"TurkBear" <jgreco1_at_mn.rr.com> wrote in message
news:d6878ucvj0n1181vh60ifnlekuc9vm7t0e_at_4ax.com...
>
> A little clarification, please:
>
> By 2 databases do you mean 2 instances ( separate init<sid>.ora file,
separate control files and a unique tnsnames.ora alias
> entry) or 2 schemas ( object owners ( users with resource privs))..
>
> Do they really share tablespaces or do they just use their own data files
in the same directories?
>
> The tablespace data files are not sufficient to restore the database -
> simple copying is not a practical solution( Look into Export/Import or
RMAN)
>
Simple copying is a perfectly practical solution. She shuts the database
down first, and isn't running in archivelog mode. That's a cold backup
scenario, and cold backups are performed... er, by simply copying the
datafiles (and the controlfiles, and the online redo logs too, if you like
to keep things simple -so you;re right about the tablespace data files not
being sufficient in and of themselves).
Suggesting she move to export/import or RMAN is complete overkill!
Regards
HJR
> You need to really understand the DBA concepts manual ( at a minimum ) to
effectively manage an Oracle database...
>
> BTW, what version of the Oracle and on what platform...
>
>
> cmcalear_at_pulsion.co.uk (Carol) wrote:
>
> >Hi there
> >
> >I am new to oracle and I am trying to get up to speed very quickly.
> >I have recently took over administration of two oracle databases on
> >the same server, these two databases share a temporary and data
> >tablespace, my question is with regards to backup and restore. At the
> >moment the first database is shutdown and the files are copied to a
> >backup directory using a batch file which just copies them using
> >operating system commands, once this is complete the second database
> >is shutdown and the files are copied in the same way. Will I be able
> >to recover both the databases in the event of a failure or will I be
> >told that the temp and data file for one of the databases has failed a
> >verification check? Also the directory structure on this server is
> >obscure, would in the event of failure would I be able to copy these
> >files to a new server and restore the database? The databases are
> >both running in noarchive log mode.
> >
> >Thanks in advance
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Mon Mar 04 2002 - 10:47:55 CST
