Re: hot-backup recovery question - more data

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_at_guidancetech.com> 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_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
>

-- 
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l