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@(protected)> 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 (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. > > -- > http://www.freelists.org/webpage/oracle-l >
-- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles. -- http://www.freelists.org/webpage/oracle-l
