RE: hot-backup recovery question - more data

Actually, it has to be open:
=20
SQL> startup mount;
ORACLE instance started.
=20
Total System Global Area 2629832596 bytes
Fixed Size                    73620 bytes
Variable Size             662622208 bytes
Database Buffers         1966080000 bytes
Redo Buffers                1056768 bytes
Database mounted.
SQL> alter tablespace psapbtabd end backup;
alter tablespace psapbtabd end backup
*
ERROR at line 1:
ORA-01109: database not open
=20
Interestingly enough, I checked out v$backup and v$datafile_header on =
the
source and target systems.  Before doing the SRDF split on the source =
system,
v$datafile_header had =91FUZZY =3D YES=92 for all data files and =
v$backup had =91STATUS
=3D ACTIVE=92 for all datafiles.  That=92s exactly what I=92d expect to =
see, since I
did an =91alter tablespace <tsname> begin backup=92 for all tablespaces =
in the
database=85.
=20
Then I split the disks (symrdf =96g prd_data split) which takes about 60 =
seconds,
and confirm that they=92re split (symrdf =96g prd_data query =96 they =
all show a
=93Split=94 status).  I import the volumes & mount the file systems on =
the remote
system, and execute =91startup mount=92 as oracle.  When I query =
v$datafile_header
and v$backup on the target host, I see the following:
=20
=20
=20
--
Rich Holland        (913) 645-1950        SAP Technical Consultant
print unpack("u","92G5S\=3D\"!A;F]T:&5R(\'!E<FP\@:&%C:V5R\"\@\`\`");
  _____ =20

From: Fuad Arshad [mailto:fuadar@xxxxxxxxx]=20
Sent: Monday, March 14, 2005 11:12 AM
To: holland@xxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: hot-backup recovery question
=20
no the database has to be in mount state to end backup.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: