In a mounted state: select 'ALTER DATABASE DATAFILE '''||name||''' END BACKUP;' from v$backup b, v$datafile f where b.file#=f.file# and b.status='ACTIVE' / SQL> alter database datafile <path> end backup; that one is forever burned into memory ... Paul On Mon, 14 Mar 2005 17:23:26 -0500, Rich Holland <holland@xxxxxxxxxxxxxxxx> wrote: > 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. > > -- > //www.freelists.org/webpage/oracle-l > -- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles. -- //www.freelists.org/webpage/oracle-l