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 (See ORA-01109.ora-code.com): 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@(protected)]=20 Sent: Monday, March 14, 2005 11:12 AM To: holland@(protected); oracle-l@(protected) Subject: RE: hot-backup recovery question =20 no the database has to be in mount state to end backup.
