RMAN-Recover Failure

Printable View

05-31-2003, 04:00 AM
hamhey

RMAN-Recover Failure

Hi all,
I'm testing rman on a server to put the server in production. My problem is when you have got media failure on system datafile and consequently the system tablespace.

The problem is:
when simulating removing the system data file from the disk after taking a level-0 backup. The ramn is not able to connect the target database catalog (when database is down) because the server can not be mounted and I got the following error message:
Recovery Manager: Release 8.1.5.0.0 - Production

RMAN-06005: connected to target database: SOLDB (DBID=2945300576)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-01033: ORACLE initialization or shutdown in progress

The problem exists, without opening the database you are not able to connect to database catalog.
And with system datafile missing you cannot open the database from another interface like sqlplus.

Do you how to handle the situation.

Regards
Hamhey
05-31-2003, 04:19 AM
adewri

Repeat after me

"RMAN catalog database should always be different from the target database"
"RMAN catalog database should always be different from the target database"
"RMAN catalog database should always be different from the target database"
"RMAN catalog database should always be different from the target database"
"RMAN catalog database should always be different from the target database"
"RMAN catalog database should always be different from the target database"
"RMAN catalog database should always be different from the target database"

Now does that make sense.
05-31-2003, 04:42 AM
hamhey

Thanks a lot,
Would you tell me how to create another database in the same machine. You mean another instance in the the same machine maybe.
I create catalog like the following. Would you correct me where in the instructions is wrong:
1. Create tablespace rman_ts ,20 MB
2. create user rman_dba and rman_ts as default tablespace
3. grant connect, resource, recover_..owner to rman_dba
4. create catalog tablespace rman
5. register databse.

Would you tell me what is wrong and how to create another database for catalog.

Thanks
Hamhey
05-31-2003, 04:51 AM
adewri

Create a new database the same way you created the existing database.

You should keep the RMAN database in a different machine altogether. So in case the PROD machine goes down you still have the RMAN to recover your DB. If they are on the same machine then if machine goes down your DB as well as the RMAN goes down.

In the 5th step after creating the catalog connect to remote target database and then register.

RMAN> connect target sys/password@remote.world catalog rman/rman@rcat
RMAN> register database.

For more details Read

http://download-west.oracle.com/docs...a76990/toc.htm

HTH
05-31-2003, 05:14 AM
hamhey

Thanks a alot Amar for the info.
Unfortunately I dont user and password to the page you refering. Would you mind sending me an attachment to the following email:
h.heydarzadeh@dpiran.net

Thanks in advance
Hamhey
05-31-2003, 05:21 AM
adewri

Registration is free. Do it and you will have access to all Oracle Documents. Go to www.oracle.com and get registered.
06-01-2003, 02:49 AM
hamhey

Everythings seems just fine except when logging to the rcat database. Creating user rman and the default tablespace rcvcat failed. It seems I stil being connected to the target database instead of rcat database (using: sqlplus /nolog@rcat and then connect / as sysdba ).
I think I was connected to the target database instead.
Do you know how to fix it. And is there any way to check what database you've connected to before issueing the command create user rman ...

//Hamhey
06-01-2003, 03:17 AM
akhadar

Either u can use connecting string for rcat while connecting as sysdba or use
Set sid=rcat
then /as sysdba
06-01-2003, 05:56 AM
hamhey

I think something is wrong. Connecting to rman catalog database getting error message that the database is not open. starting the rcat database resulting in error message that the pfile initRCAT.ora is missing.
Any idea.

//Hamhey
06-01-2003, 06:19 AM
akhadar

How did u created the catalog database?
06-01-2003, 06:31 AM
hamhey

I run the two sctipts from $ORACLE_HOME/rdbms/admin/catalog.sql and catproc.sql
followed by logging to rcat database and creating rman user etc.

//hamhey
06-01-2003, 06:50 AM
akhadar

What i want to know is ,did u clearly understand what exactly Amar has told u?.I think u are missing some thing here.He told u to create a seperate database itself exclusively to hold the catalog.Then what u have done?
06-01-2003, 06:56 AM
hamhey

According to the documentation I just the two script from
$ORACLE_HOME/rdbms/admin/catalog.sql and catproc.sql
to create the recovery catalog and then started to create the rman user and etc. ...

//Hamhey
06-01-2003, 07:00 AM
hamhey

If you follow the replies earlier:
I did create the rman user on my a tablespace
in the target database and I got problem when restoring the system tablespace. What Amar suggested me was that to create the user in the rcat database with predefind tablespace and referred to a otn documentation. I restored the database from before I began creating user and catalog and did just as documentation says:

According to the documentation I just the two script from
$ORACLE_HOME/rdbms/admin/catalog.sql and catproc.sql
to create the recovery catalog and then started to create the rman user and etc. ...

Any idea what is wrong

//Hamhey
06-01-2003, 07:54 AM
akhadar

U totally missed what the manual says.A datbase creation is successful once u follow all the steps required for creating a database like
1.Creating a parameter file like initrcat.ora.
2.Creating a service for the new database.
3.Connecting to instance.
4.running a script which will create all the necessary files a database.
But u didn't created a seperate database to house the rcat.This is what Amar said.Once u will create a seperate database for it then run catproc.sql and catalog.sql. create the rman user and the catalog.Now register the database whose information u want to be stored in this catalog.
06-01-2003, 08:04 AM
hamhey

Isn't that the scitpts catproc.sql and catalog,sql
create the database. This was according to the documentation.

//Hamhey
06-01-2003, 08:07 AM
akhadar

Go through my edited portion
06-01-2003, 08:12 AM
hamhey

I'm I am not following you what edited portion u mean.

//Hamhey
06-02-2003, 12:10 AM
akhadar

check this

U totally missed what the manual says.A database creation is successful once u follow all the steps required for creating a database like
1.Creating a parameter file like initrcat.ora.
2.Creating a service for the new database.
3.Connecting to instance.
4.running a script which will create all the necessary files a database.
But u didn't created a seperate database to house the rcat.This is what Amar said.Once u will create a seperate database for it then run catproc.sql and catalog.sql. create the rman user and the catalog.Now register the database whose information u want to be stored in this catalog.
06-02-2003, 12:29 AM
vinit

You ran catproc and catalog.sql on your target database. You also created the rman user/tablespace on your target database and not catalog DB.
I think akhadar and amar are quite clear in terms of what you need to do. Reading the manual will help too.
Well here's what you can try - first shutdown your target database and bring it up only when you need to register it with the catalog. That way you could avoid the confusion.
06-02-2003, 01:03 AM
hamhey

Thanks for the info.
The thing that confused me mostly was the existence of two databases in the same machine. Two instances I've seen but two databases.

//Hamhey
06-02-2003, 01:21 AM
vinit

Quote:

Originally posted by hamhey
Thanks for the info.
The thing that confused me mostly was the existence of two databases in the same machine. Two instances I've seen but two databases.

//Hamhey

I think you're getting confused by Oracle and SQL Server.
In Oracle 1 Database = 1 Instance, unless using OPS.
06-02-2003, 03:46 AM
hamhey

I thinks get the point.
My question is when you create a new instance in the same machine (or database) do I have to include the system file and rollback segment in the script to generate the database. Or the new instance uses the same system file and rollback segments.

//Hamhey
06-02-2003, 03:50 AM
adewri

Read this...

Oracle9i Concepts
06-02-2003, 05:38 AM
hamhey

Thanks for the url you are refering to.

I just wonder (has not specified in the documentation) the system tablespace for rcat database.
When I create a small database like rcat do I have to create a separate system tablespace or can I skipp the creation of system tablespace including all the views and data dictionary again. The target database has the same info, if so do I have to the target database up and runnig all the time for using the data dictionary and views and all the information and what happens to the information stored in the datafiles of system tablespace.
The question was generally asked.
My problem today is if I cant use the same size of system tablespace of the target database and wonder how mush disk space AS MINIMUM do I need for system tablespace for 8.1.5 version to get the required function of system tablespace for rcat.

//Hamhey
06-02-2003, 05:50 AM
adewri

I seems you have never created a database before otherwise you would never ask such a question. Without system tablespace you cannot have a database in Oracle. A tablespace can belong to only and only one database.

Take a print out of Concepts Guide, take a leave for a week read it throughly. Without knowing the concepts i wonder how you going to backup and recover your PROD database. This is no joke, but a serious advice for you if you want to keep your job as a DBA. And do not forget to read the Backup and Recovery Concepts guide as well.

Download this documentation
http://download.oracle.com/docs/cds/F49540_01.zip
or browse online
http://download-east.oracle.com/docs.../DOC/index.htm

and read them.

HTH