Toad World® Forums

Schema Backup Q


#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 …