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_at_yahoo.com]=20
Sent: Monday, March 14, 2005 11:12 AM
To: holland_at_guidancetech.com; oracle-l_at_freelists.org
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
Received on Mon Mar 14 2005 - 17:27:01 CST
