Does anyone have the steps to setup RMAN on a unix server without using
a repository ??

Thanks,

Brad

-----Original Message-----
From: Irfan Ahmad
[mailto:oracledba-ezmlmshield-x97857383.[Email address protected]
Sent: Thursday, April 26, 2007 12:22 AM
To: LazyDBA Discussion
Subject: Re: RMAN Steps for setup

hi
SQL>CONNECT SYS/SYS AS SYSDBA
SQL>SELECT * FROM V$LOGFILE;
SQL>SELECT * FROM V$CONTROLFILE;
SQL>SELECT TABLESPACE_NAME,NAME FROM V$DATAFILE_HEADER;
SQL>SHUTDOWN IMMEDIATE
COPY ALL DATAFILES + LOGFILES + CONTROL FILES AND PASTE IN A BACKUP
FOLDER;

SQL>STARTUP
SQL>CREATE TABLESPACE RMAN_DATA
DATAFILE 'D:/ORACLE/ORADATA/ORCL/RMANDF.DBF' SIZE 100M;

SQL>CREATE USER RMAN IDENTIFIED BY RMAN
DEFAULT TABLESPACE RMAN_DATA
QUOTA UNLIMITED ON RMAN_DATA
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED ON TEMP;

SQL>GRANT RESOURCE,CONNECT,RECOVERY_CATALOG_OWNER TO RMAN;

NOW FROM COMMAND PROMPT===

C:\>RMAN TARGET SYS/SYS RCVCAT RMAN/RMAN

RMAN>CREATE CATALOG;

RMAN>REGISTER DATABASE;

RMAN>RESYNC CATALOG;

RMAN>REPORT SCHEMA;

RMAN>LIST BACKUP OF DATABASE;

RMAN>LIST BACKUP OF TABLESPACE USERS;

RMAN>LIST BACKUP OF DATAFILE
'D:/ORACLE/ORADATA/ORCL/USERS01.DBF';

RMAN>LIST COPY OF DATABASE;

RMAN>LIST COPY OF TABLESPACE USERS;

RMAN>LIST COPY OF DATAFILE
'D:/ORACLE/ORADATA/ORCL/USERS01.DBF';

RMAN>BACKUP
FORMAT 'E:/RMANBK/df_%d_%s_%p.bus'
DATABASE filesperset=2;

RMAN>LIST BACKUP OF DATABASE;

RMAN>LIST BACKUP OF TABLESPACE USERS;

RMAN>LIST BACKUP OF DATAFILE
'D:/ORACLE/ORADATA/ORCL/USERS01.DBF';

RMAN>LIST COPY OF DATABASE;

RMAN>LIST COPY OF TABLESPACE USERS;

RMAN>LIST COPY OF DATAFILE
'D:/ORACLE/ORADATA/ORCL/USERS01.DBF';

RMAN>EXIT

C:\>


SQL>SHUTDOWN IMMEDIATE


DELETE DATAFILE BELONG TO TABLESPACE USERS;

SQL>STARTUP


PRODUCE ERROR DUE TO MISSING DATAFILE

NOW YOU ARE USING SINGLE DATABASE AND BOTH CATALOG DATABASE AND
PRODUCTION DATABASE ARE SAME.

SO YOU SHOULD OFFLINE YOUR TABLESPACE USERS (BLONG TO MISSING DATAFILE)

SQL>ALTER DATABASE OFFLINE DATAFILE
'F:/ORACLE/ORDATA/ORCL/USERS01.DBF';

SQL>ALTER DATABASE OPEN;



NOW AGAIN ON RMAN

C:\>RMAN SYS/SYS RCVCAT RMAN/RMAN

RMAN>RUN{
RESTORE DATABASE;
RECOVER DATABASE;
SQL "alter tablespace users online";
}

SQL>SELECT * FROM SCOTT.DEPT;

BE HAPPY HAPPY DONOT WORRY (".")
Irfan Ahmad----- Original Message -----
From: "M A Azeem " <oracledba-ezmlmshield-x99008088.[Email address
protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, April 26, 2007 9:47 AM
Subject: RMAN Steps for setup


> Hi
>
> I have installed oracle 9i on windows xp . I am new to RMAN and I
need to
> know the details steps require to setup RMAN. Do I need to create a
new
> database to setup RMAN or I can use the existing database only . what
are
> other things are require ? did any one knows and help me Plz . ?
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page