Schema Backup Q

Toad for Oracle
1

Schema Backup Q

2

Hello Rob-

–a couple housekeeping chores before launching rman backup scripts…
–change location of DATAFILE to %ORACLE_HOME%\ORADATA

– Create tablepsace to hold repository
CREATE TABLESPACE “RMAN”
DATAFILE ‘C:\ORACLE\ORADATA\W2K1\RMAN01.DBF’ SIZE 6208K REUSE
AUTOEXTEND ON NEXT 64K MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

– Create rman schema owner
CREATE USER rman IDENTIFIED BY rman
TEMPORARY TABLESPACE temp
DEFAULT TABLESPACE rman
QUOTA UNLIMITED ON rman;
GRANT connect, resource, recovery_catalog_owner TO rman;

now you can login as RMAN user and have access to rman tablespace

Norm/Roger did i miss anything?
Martin

…standard caveats apply…

3

Just a note – you do not have to create an rman repository to use rman
– it will work (with less features/capabilities) without – it works
off the control files then …